0 votes
I'm looking to import a fixed-width file into DSS. The basic import is working fine, but my additional need is that the first line of each file has a date field. I need to extract that field and append as a new column to the dataset.

For example,

F317AF0205008:02:07    19/07/22    0960 1

01234567890   ABCDE     ABC DEF                      98765ABC432109DEFG                          15.245

 

I have column widths to split line 2 and the rest of the file. What would you suggest I try to get the date? Also, we expect to get a file everyday.

 

Srini
by
reopened by

1 Answer

0 votes
Best answer
Hi Srinivas,

I don't see any built-in solution for that in DSS
I would suggest using python to parse these files, you store them in a folder, then extract the date of the first line and add it to a new column.

Matt
by
selected by
OK. Thank you
1,296 questions
1,323 answers
1,506 comments
11,862 users

┬ęDataiku 2012-2018 - Privacy Policy