How to export data from text file

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

This 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.