Guide me from should i start this

Help Studio
, ,
1

Hello People’s
I have alot of text file and i want to extract some particular text from text file and insert that data into excel including there headers so guide me how should this and please guide me. I am new in this field.

2

Hi @Akash5 ,
Can you share your text file or image about sample of them?
you can try this step

image
image399×538 14.5 KB

read text file get String
generate data table
write range data table to excel file
regards,
LNV

3
  1. Use read text file activity pass the variable of file path
    2.Extract the text
    3.Write range activity check the add headers in properties panel
4

Can you provide the sample text file

5

can you share your text file to test?
text_to_data.xaml (7.3 KB)
regards,
LNV

6

HI @Akash5 ,
in assign activity use
string Array VarName= Directory.getFiles(“Path where all text file stored”)

it give Array of complete file path.
Inside For each activity perform action mentioned by @Nguyen_Van_Luong1.

Note:if desired data from text file is some specific text then you can use regex/ string manupulation tp extract the data

7

send me your text file, I will test it