Convert txt files into excel

Help StudioX
,
1

Hello, can help me how to create workflow of:

  1. converting txt files into excel
  2. manipulate the format from txt files into excel
    Thanks!
2

Hi,

Can you share your sample txt file and expected result?

Regards,

3

Hi, thank you for replying.

Oh I am a new user hence can not upload file. How long I have to wait to able upload file?

4

Hi,

How long I have to wait to able upload file?

I’m not sure about it.
We can write text as preformated in post using ‘</>’ button in menu.
Can you try this if data is not large?

Regards,

6

Hi,

As it seems not structured text, need to specific result format and its definition.

Regards,

7

Looking at that file, the question should be asked: can we get the source file in a better format?

Always look for ways to improve processes, rather than automating bad processes.

12

can help me with the workflow? i can provide the sample data

13

Hi @wenwen

Hi @Nur_Amin

To convert the text to datatable and write to excel. Follow the below process.
=> Read Text File" activity: This will read the content of the text file. Output - String Variable

=> “Generate Data Table” activity: This will create a data table to store the text data - output - Datatable Variable

=>“Excel Application Scope” activity: This will open an Excel instance to write the data.
“Write Range” activity: This will write the data table to an Excel file. Output - Excel file

Note - In the generate datatable activity you have to give the sample text and you can preview how the text is extracting as datatable. Here based on your requirements you can configure things.

Hope it helps!!

14

Hi @Nur_Amin ,
My solution

image
image1557×786 43.3 KB

Can you share your text file?
I will test your sample
Regards,
LNV

15

Hi, this is my sample. the text file and also expected output.
demo.txt (446 Bytes)
demo.xlsx (9.8 KB)

16

Hi @Nur_Amin ,
My solution

image
image1236×717 42.8 KB

My in/out
image
image1763×981 74.5 KB

Regards,
LNV

17

can u share this workbook?

18

Hi @Nur_Amin ,
demo.txt (448 Bytes)
demo.xlsx (10.1 KB)
Regards,
LNV

19

hi this is not studio x workbook

20

for filter wizard what u use for column as i use output data table n it show as colum error

21

Hi,
Can you share your error
Regards

22

image
here it is

23

appreciate if u can share your workflow studio x

24

Hi,
Your image so small
my column

image
image1116×535 28.8 KB

Regards
LNV

25

this is mine
image