Skip to main content

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

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