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

 

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!
This entry was posted in HFT High Frequency Trading, Quant Development and tagged , , on by .

About caustic

Hi i there My name is Bryan Downing. I am part of a company called QuantLabs.Net This is specifically a company with a high profile blog about technology, trading, financial, investment, quant, etc. It posts things on how to do job interviews with large companies like Morgan Stanley, Bloomberg, Citibank, and IBM. It also posts different unique tips and tricks on Java, C++, or C programming. It posts about different techniques in learning about Matlab and building models or strategies. There is a lot here if you are into venturing into the financial world like quant or technical analysis. It also discusses the future generation of trading and programming Specialties: C++, Java, C#, Matlab, quant, models, strategies, technical analysis, linux, windows P.S. I have been known to be the worst typist. Do not be offended by it as I like to bang stuff out and put priorty of what I do over typing. Maybe one day I can get a full time copy editor to help out. Do note I prefer videos as they are much easier to produce so check out my many video at youtube.com/quantlabs