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!
Don't miss out!
Get my TRADE LIKE A BOSS 2 PDF Books

You will received instantly the download links.

Invalid email address
Give it a try. You can unsubscribe at any time.

NOTE!

Check NEW site on stock forex and ETF analysis and automation

Scroll to Top