bring this non standard csv file into my kdb db,

Community Support
1

I would like to bring this txt file into my kdb db, could anyone helpme here with some cmd q code?I can do normal csv but I am not sure if q can do it without someprocessioning of these text filesEURBBDN2.8335|2.862|2.364|3.0129|07:52EURBBDN2.8335|2.862|2.364|3.0129|07:52EURBMDN1.4235|1.4235|1.1761|1.4989|07:52EURBMDN1.4235|1.4235|1.1761|1.4989|07:52EURBNDN1.7196|1.72|1.667|2.1053|07:52EURBNDN1.7196|1.72|1.667|2.1053|07:52EURBSDN1.4235|1.4235|1.1875|1.5138|07:52

2

(“SFFFFU”;“|”)0:fileSymbol

Theres a section on this in q for mortals

Sent from my iPhone

3

Return-Path: rohit.tripathi@capgemini.com

The very first “field” is=20

>EURBBDN2.8335

Does he want to separate out the numbers from alphanums?=20

________________________________________
From: personal-kdbplus@googlegroups.com [personal-kdbplus@googlegroups.com]=
On Behalf Of manni patel [manni.patel@gmail.com]
Sent: Tuesday, September 13, 2011 10:04 PM
To: personal-kdbplus@googlegroups.com
Subject: Re: [personal kdb+] bring this non standard csv file into my kdb d=
b,

(“SFFFFU”;“|”)0:fileSymbol

Theres a section on this in q for mortals

Sent from my iPhone

4

Ah ok, in that case parse in as string and process.

If the syms are always 7 long it will be easy with a #’

If not then a funkier function using .Q.A/n

Sent from my iPhone

5

Or better still, use perl (or whatever your fave is) to pre process. Q
isnt great for regexp type of stuff.

Sent from my iPhone