Convert Unstructured Text File To CSV

[Abhi15 (Abhi)]

Hi Everyone,

I need to convert a unstructured text file to csv in below format , could any one help me in this. Attached the input text file and the csv file desired output below.
savedFiles.txt (5.0 KB)
Output.csv.xlsx (9.5 KB)

[Yoichi]

Hi,

Can you try the following sample?

Sample20220412-4.zip (3.3 KB)

This sample assumes that the header name is known in advance.

Regards,

[Abhi15 (Abhi)]

Thanks you so much for the sample its working fine.
I need output file in csv format but while using write csv the first column Call ID is showing in scientific notation like 7.08544E+18 but the actual call id in text file is 7085441100918363473. Do you know how to convert this?

[Yoichi]

Hi,

Can you try either of the following?

Modify to the following expression

strTable = String.Join(vbCrLf,mc.Cast(Of System.Text.RegularExpressions.Match).Select(Function(m) "'"+m.Value.TrimEnd()))

OR

Use System-File-Workbook-WriteRange activity.

OR

FormatCells activity might help you.

Format Cells

Regards,