Skip to main content
Ground Control | Tier 1
August 11, 2022
Question

how to extract table data from text file ?

  • August 11, 2022
  • 1 reply
  • 367 views

I need to extract table from text file but the but I am unable to extract table into csv using space or tab delimiter

Below attached is the table in text file .

Thanks

image

    1 reply

    Ashwin A.K
    Navigator | Tier 3
    August 19, 2022

    Hi @Pratiksha Pawar​ ,

     

    First, try extracting the data from the Text File using the Text file: Get Text Action.

    Next, you can use the String: Replace Action toggled to is a regular expression and replace tabs with commas.

     

    image 

    Then you can write it to CSV and read it using the CSV Actions to receive a Data Table.

     

    Kind Regards,

    Ashwin A.K

    Blogs at TheCodingTheory - https://www.thecodingtheory.com