Skip to main content
  • EN

 

how can I separate the data into separate columns?

 

E.g

Date                         Information           result
 
2023-02-20 07:24:00         inform             Current FME version: FME 2022.2.0.0 (2022110)

 

image

CSV represents any text file structure where columns are separated by a delimiter, usually a comma. The delimiter can be anything you like, not just a comma. Read the log file with a csv reader, I'm sure you can figure it out from there, and all you need to do is set the schema.

You can use the CSV reader with a pipe (|) as the delimiter

image

Thanks for the reply, @ctredinnick​ 

I'm stuck on one more thing; how can I separate them now?

 

image 

Thanks for the reply, @ctredinnick​ 

I'm stuck on one more thing; how can I separate them now?

 

image 

This is not a fme log file...​

Reply


Community Stats

30,161
Posts
114,500
Replies
37,813
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.