Skip to main content
Question

log file text line data -- Separate columns

  • February 20, 2023
  • 4 replies
  • 18 views

Forum|alt.badge.img+5

 

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

4 replies

ctredinnick
Supporter
Forum|alt.badge.img+19
  • Supporter
  • 225 replies
  • February 20, 2023

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.


arnovananrooij
Contributor
Forum|alt.badge.img+5
  • Contributor
  • 73 replies
  • February 20, 2023

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

image


Forum|alt.badge.img+5
  • Author
  • 170 replies
  • February 20, 2023

Thanks for the reply, @ctredinnick​ 

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

 

image 


arnovananrooij
Contributor
Forum|alt.badge.img+5
  • Contributor
  • 73 replies
  • February 20, 2023

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