bug in kdb2.7,file processing
I have a text file that contains data in the form
“TESS” NOTE, OPTN TEN
when I read the data from the file It is read as
TESS” NOTE, OPTN TEN
The double quotes in the beginning are removed
I read the file using the below command
table1: flip `acct`accountStatus`fullname!(“SSS”;”|”) 0:`:outdata1.dt
select fullname from table1 where acct=`0720002C
fullname
———————
TESS” NOTE, OPTN TEN
Can someone suggest a workaround?
==
Recent versions of q use Excel rules for escaping quotes and commas, but only in a 0: with comma as a separator, and only for fields parsed as string (“*”).
NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!