An "-" issue (hyphen)

[skunal]

When i trying to import the file which contains "-" for example

445;777;88;hi;uu;678
123;abc;tt;-;yy;456 ---- (hyphen is before "yy" )

I am getting the previous value that is "uu" and when i keep the second record which contains - as first I am getting blank.

But if i use other notations like # @ etc in place of "-" I am getting correct value..Can anyone let me know why "-" is taken as blank..or previous value comes in place of "-".

Thanks,

 

[mosfin]

i think you should post here your code fragment that imports the file, in order to understand & help you
Note: don't forget to surround it with CODE tag

 

[Stefan]

See the help file reference on the IMPORT statement:

If an input data line contains an unquoted hyphen in place of a data value, then the corresponding field is skipped, as it is in UPDATE. If you specify a hyphen (-) as the delimiter character, all hyphens are treated as delimiters. If you use the UNFORMATTED option, the hyphen is treated the same as any other character.