RegEx for Text File

Help Studio
, ,
1

Hey All,
I am using a txt file with 5 lakh records where in i need to extract desired string from each row.
have stored text file in Match Collection and using for each row to iterate as below :
image

Input Eg : 1168~abcd~null~3~1~0~2009-10-27 05:00:00~2009-10-27 05:00:00~2021-06-16 10:13:35~2009-10-27 05:00:00~2009-10-28 01:13:34~

Desired Output : Need to extract 1st value before ~ and storing in str_SerialNo variable=1168

2

@prerna.gupta

are you facing any issue with it?

Can you please elaborate the issue

You can use item.Value.Split("~"c).First

Assuming matchcollection is a collection of match and not strings

Can you please let us know what is there is match collection if this does not work

Cheers

3

Hi @prerna.gupta

You can use the below regular expressions.

System.Text.RegularExpressions.Regex.Matches(yourstringinput.ToString,“(^\d+(?=~))”)

image
image1428×345 17.1 KB

Hope it helps!!

4

@prerna.gupta

image
image1435×356 13.7 KB

5

The expression u r using is already correct
May I know what issue u r facing
@prerna.gupta

6

This is similar to item.ToString.Split("~"c)(0) and it extract only 1st numeric digit before ~ ie 8 instead of 1168
For each - list of match collection only

7

HI @prerna.gupta

str_SerialNo=strinput.Split({“~”},StringSplitOptions.RemoveEmptyEntries)(0)

strinput = “1168~abcd~null~3~1~0~2009-10-27 05:00:00~2009-10-27 05:00:00~2021-06-16 10:13:35~2009-10-27 05:00:00~2009-10-28 01:13:34~”

image
image778×478 19.2 KB

you can try this

8

item is of match collection type.
Suggested is throwing error MatchCollection cannot be converted to String

9

Okay @prerna.gupta Use the below one

System.Text.RegularExpressions.Regex.Match(yourstringinput.ToString,“(^\d+(?=~))”).Value

Hope you understand!!

10

you can change the variable type to matchcollection

image
image738×230 6.2 KB

then it will work

@prerna.gupta

11

@prerna.gupta

Can you please use a log message and show what is there is each item…please log the item…looks like the matchcollection itslef is missing 116 in it

Cheers

12

I need to extract multiple values from Input String due to which not using RemoveEmptyEntreis function

To be precise i need to extract 2 values
Value 1 = Anything before 1st ~ symbol = 1168
Value 2 = Anything after 1st ~ symbol = abcd (this is working good using item.ToString.Split("~"c)(1))

13

Issue Facing - Getting only 1st numeric digit before ~
Output = 8
Desired Output = 1168

14

HI @prerna.gupta
1.Value 1 = Anything before 1st ~ symbol = 1168

System.Text.RegularExpressions.Regex.Split(strinput,“~”)(0)

2.Value 2 = Anything after 1st ~ symbol = abcd
System.Text.RegularExpressions.Regex.Split(strinput,“~”)(1)

let me know its working or not for you

15

Multiple Errors

image

16

I’m sharing the xaml you can follow same as it is

Xaml : - RegEx for Text File.zip (1.9 KB)

@prerna.gupta

17

Sure let me try. Thanks

18

if not you can try this screenshots

image
image796×685 23.4 KB

you can see the out

image
@prerna.gupta

19

image
image980×282 20.9 KB

Dependencies errors

20

can you share the screenshots of your flow
@prerna.gupta