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

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