Read and process fixed width file

Solved!
srinivas_anand
Level 2
Read and process fixed width file
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
0 Kudos
1 Solution
Mattsco
Dataiker
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
Mattsco

View solution in original post

0 Kudos
2 Replies
Mattsco
Dataiker
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
Mattsco
0 Kudos
srinivas_anand
Level 2
Author
OK. Thank you
0 Kudos

Labels

?
Labels (2)
A banner prompting to get Dataiku