Hello, can help me how to create workflow of:
- converting txt files into excel
- manipulate the format from txt files into excel
Thanks!
Hi,
Can you share your sample txt file and expected result?
Regards,
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?
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,
Hi,
As it seems not structured text, need to specific result format and its definition.
Regards,
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.
can help me with the workflow? i can provide the sample data
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!!
Hi, this is my sample. the text file and also expected output.
demo.txt (446 Bytes)
demo.xlsx (9.8 KB)
can u share this workbook?
hi this is not studio x workbook
for filter wizard what u use for column as i use output data table n it show as colum error
Hi,
Can you share your error
Regards
here it is
appreciate if u can share your workflow studio x
this is mine
sharazkm32
ashokkarale
marquezd
RGTaffy
SorenB
cprima
KB_Fleet
Nithinkrishna
V_M_P_Bharath
Nisha_K21