Invalid Quotes

vinaymanchinila · Post by **vinaymanchinila** » Tue Apr 26, 2005 5:54 am

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,

vinaymanchinila · Post by **vinaymanchinila** » Tue Apr 26, 2005 6:00 am

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

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Apr 26, 2005 6:06 am

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')

vinaymanchinila · Post by **vinaymanchinila** » Tue Apr 26, 2005 6:12 am

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

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Apr 26, 2005 6:13 am

You are removing the double-quotes.