Read txt file and Split Each Row

[prerna.gupta]

Team,
Need to Read a txt file with 50K Records, Read each row and extract desired output such as Value 1 = 1 and Value 2 = Abby.

Input = Text File with 50K Rows
Sample Row Eg = 1~Abby~null~1~1~0~2009-10-27 05:00:00~2018-07-02 16:06:22~2023-09-06 12:40:03~2018-07-02 16:06:22~2009-10-28 01:13:34~
Value 1 =1
Value 2 = Abby

Thanks in advance

[sasi_poosarla (sasi p)]

value1=inputtext.split(“~”,c)(0)
value2=inputtext.split(“~”,c)(1)

Hope it Helps!!

[Nguyen_Van_Luong1 (Nguyễn Văn Lương (Albert Nguyễn))]

Hi @prerna.gupta ,
Have you try read text file to get String then generate data table
use regex with each row,
can you share image about your file?
regards,

[Shiva_Nikhil]

@prerna.gupta

use match collection in regex so that you will all the rows values

collectionoutput=system.text.regularexpression.regex.matches(inputstr,“\d{1}~[a-zA-Z]+”)

[prerna.gupta]

@Shiva_Nikhil

system.text.regularexpression.regex.matches(inputstr,“\d{1}~[a-zA-Z]+”)

File Snipet

[prerna.gupta]

@sasi_poosarla

inputtext.split(“~”,c)(0)

Tried this one but not working.
PFA

[prerna.gupta]

TestFile.txt (597 Bytes)

[sasi_poosarla (sasi p)]

by this you will get all the matches collection.

splitting the desired values

[Praveen_Mudhiraj]

H! @prerna.gupta

You can try this xaml
practice task 4.xaml (11.5 KB)

you can see the output

[prerna.gupta]

Can you pls share Snapshot of xml code ?
Multiple lib and VB error while opening this one.

[prerna.gupta]

NOT working for me. can you share the snapshot of code as well ?

[sasi_poosarla (sasi p)]

[Shiva_Nikhil]

@prerna.gupta

taskforum.zip (2.8 KB)

check this

[Praveen_Mudhiraj]

Take assign activity and create a variable
str_input= “YourText”

And pass in for each and give the condition like this = str_input.Split({vbLf},StringSplitOptions.RemoveEmptyEntries)

for value 1

for value 2

[prerna.gupta]

Thanks much this is working as expected.