Text file to Excel file conversion

Help Studio
, ,
1

Hi,
Please help to convert Text file into Excel file.
please help me .

Regards
TextTOExcel.txt (301 Bytes)
TextToExcel.xlsx (8.5 KB)

2

Hi
hope the below steps would help you resolve this

  1. Use a READ TEXT FILE activity where pass the filepath of text as input and get the output as string named Strinput

  2. Then use a GENERATE DATATABLE activity and pass Strinput as input variable and get the output as dt DATATABLE

  3. Now use a WRITE RANGE activity and pass dt as input and enable add headers property and mention the filepath where you want to write

Mention the column separator as “ “
A space that’s it

image

Cheers @Priyanka_Jadhav1

2 Likes
3

Hi,

Can you try as the following?

img20211112-b
img20211112-b1226×696 39.7 KB 

strdata = System.Text.RegularExpressions.Regex.Replace(strdata," +"," ")

Regards,

1 Like
4

FYI, the above workflow file:

Sample20211112-2.zip (2.6 KB)

Regards,

1 Like
5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.