DSXchange

Hi,
I am writing into a sequential file and I get this error after 196054 records!.

" invalid quotes, row 196054 column ZLGSERNO = "MCEEO811400830"" the field ZLGSERNO is SQL type Char, 25 length and Nullable.
Any help is appreciated.
Thanks,

Also is there a way I can use EReplace or Change function to replace any " in the field by blank.

There are more quote char in that row enclosing a particular field value. Look into the file for the mentioned row.

To remove any quote char as part of the data, you can do
EReplace(YourString, '"','') Or Trim(YourString, '"', 'A')

Hi,
If I use EReplace(YourString, '"','') Or Trim(YourString, '"', 'A') am I replaceing double quotes (") or blanks?
Thanks,

You are removing the double-quotes.