Skip to main content

Hello ,

i have read text file but I see only one column in FME

Important data starting from fifth column

fifth row include the name of each column

| col1 |col2|col3|col4| col5|

rest of columns include data like this

|..0383004|Abcd…………|383903…..|Dhaka Gheny 2|………|

I see in one column all data ,as what I explained above .

i would like to get the data into excel file .

i would like to export the name or number between | | so I need to have five columns and each column include the data that belongs to this column as text file

 

thanks in advance

FME 2021

 

 

 

If you read it with the CSV reader, use the | as separator character and specify which line to start reading and which has the column names you should be able to then write it to Excel.


If you read it with the CSV reader, use the | as separator character and specify which line to start reading and which has the column names you should be able to then write it to Excel.

thanks for ur reply

but I have put at delimiter character |

data start line 5

but I see the output is null at the column

but I keep it auto in delimiter character ,i got many columns

two Data inserted in one column

|number|string| some not at different cells .

could u provide small workspace to use it correctly .

i believe ,csv reader the reader that I need to use .

thanks for help


thanks for ur reply

but I have put at delimiter character |

data start line 5

but I see the output is null at the column

but I keep it auto in delimiter character ,i got many columns

two Data inserted in one column

|number|string| some not at different cells .

could u provide small workspace to use it correctly .

i believe ,csv reader the reader that I need to use .

thanks for help

imageThis is what I'm getting. Since the line starts with a | FME inserts an empty column col0 but you can safely ignore that.

 

You say: data start line 5, but in your first post you said the column names are on line 5, maybe that's it.


Reply