Question

how to extract table data from text file ?

  • 11 August 2022
  • 1 reply
  • 30 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

Userlevel 3
Badge +7

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

Reply