Skip to main content
Question

log file text line data -- Separate columns

  • February 20, 2023
  • 4 replies
  • 12 views
A
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+18
    • ctredinnickSupporter
    • Supporter
    • 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

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

    image

    A
    Forum|alt.badge.img+5
    • asadamjad
    • Author
    • 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
    asadamjad wrote:

    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


    Helpful Members This Week

    Community Stats

    31,341
    Posts
    118,857
    Replies
    38,930
    Members

    Latest FME

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

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