Tag Archives: file processing

bug in kdb2.7,file processing

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 (“*”).

 

HOW DO YOU START A PROFITABLE TRADING BUSINESS? Read more NOW >>>

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!