Hi,
I am having issue importing TXT file that has double quotes. My file structure looks like this
and I have used below import settings without getting the desired outcome
any advice how I can get well structured 4 columns.
Solved! Go to Solution.
Hi,
see attached for sample file
Please see below :
Attached the workflow,
Please save the txt input file in the same folder as the workflow.
Hope this helps !
Regards,
I still have error as my file doesn't have Field_1 column but yours have.
Hi,
some progress but now see the issue that I am having. I have tried with the actual data that I am working on and could see that some columns contains blank values hence the reason why I am not getting the desired output.
Hi @Wafarian
You are very close, perhaps the "Flat ASCII" (*.flat)" interface, to define the fields is a little fuzzy; these are my steps:
The preview panel (bottom left of the image above) help you to assign the name of the colum, which we do on the "Flat File Layout" on the right, just override the "Field_#' with the corresponding name, also select the field type.
NOTE:
Fixed width text files were very popular several years ago, until the late 80s, you may still find them; in this type of files, each field has a fixed lenght, you can appreciate that with the numeric fields in your sample data, harder with the string one.
hth
Arnaldo
Hi,
the issue is now resolved. basically, I changed the dilimeter to tab and it resolved it.
thankss
User | Count |
---|---|
19 | |
15 | |
15 | |
8 | |
6 |