How to extract data from txt format file. And save into one data table. Need help on this

Help Studio
1

I want exratct data from txt. Fromat file. And save required data from that file to the one data table

2

Hey @Rahulthombare ,
1.You can use Read text file activity and store the output in String Varibale
image

2.Then use Generate data table activity to generate a data table

image

Cheers,

3

@Rahulthombare

image

this will give you data table

image

also you can modify how you want inside options

image
image933×634 14.3 KB

Hope this helps
Cheers

4

My file like below

IMG_20230330_132135
IMG_20230330_1321351920×609 107 KB

5

And I want only Number which is starting from H which is in first column in this file… And that all HNmubers saved in one data table.

6

I don’t want other column which is also present in this same file I just want only one that is first column which contains only Number start from H. Rest of all numbers from first column not required except number start with H… So in shortly I want only first column with numbers start with H