fbpx

bug in kdb2.7,file processing

(Last Updated On: June 6, 2012)

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!

Subscribe For Latest Updates

Sign up to best of business news, informed analysis and opinions on what matters to you.
Invalid email address
We promise not to spam you. You can unsubscribe at any time.

NOTE!

Check NEW site on stock forex and ETF analysis and automation

Scroll to Top