Can anyone please Help me to solve this regex

Help Studio
, ,
#1

~AA230% -~104,561.91
~FINALSUM

~DATA#

This is the input i want to extract FINALSUM as the output.“~AA230% -~104,561.91” it can vary.it wont be same in next case.
Can anyone please help me to solve this issue.

#2

FINALSUM, is the static keyword ?

#3

HI @Chippy_Kolot

Can you share the Output

Try with the below regex expression

System.Text.RegularExpressions.Regex.Match(YourString,"\d+[,.].*").Tostring

image

Try with the below regex expression

System.Text.RegularExpressions.Regex.Match(YourString,"(?s)~(\S+\d.*%)").Groups(1)

image

Regards
Gokul

#4

Try this, If -FINALSUM is word in TexT
(?<=~).*(?=\n~FINALSUM)

System.Text.RegularExpressions.Regex.Match(YourString,"(?<=~).*(?=\n~FINALSUM)").Tostring.Trim

Also try this
(?<=~).*(?=~FINALSUM)|(?<=~).*(?=\n~FINALSUM)
image

#5

I want to extract “FINALSUM”, this is the output

#6

is the static one @Chippy_Kolot

#7

Hi @Chippy_Kolot ,
try this:
System.Text.RegularExpressions.Regex.Match(YourString,“FINALSUM”).Tostring

Thanks & Regards,
Shubham Dutta

#8

It is not static

#9

This is the Output @Chippy_Kolot

#10

@Chippy_Kolot
Kindly provide 2 different inputs and indicate the expected output.It help us to provide you better solutions

#11

HI @Chippy_Kolot

How about this expression

System.Text.RegularExpressions.Regex.Match(YourString,"(?<=~)(\S+\d.*%)\s-~(\d.+)").Groups(1)

System.Text.RegularExpressions.Regex.Match(YourString,"(?<=~)(\S+\d.*%)\s-~(\d.+)").Groups(2)

System.Text.RegularExpressions.Regex.Match(YourString,"(?<=\d\n~)\S+").ToString

image

image

image
image1117×379 28 KB

Regards
Gokul

#12

HI @Chippy_Kolot

You can try with these regex expressions

System.Text.RegularExpressions.Regex.Match("Your string variable","(?<=\d\n~).*").ToString

or try this

System.Text.RegularExpressions.Regex.Match("Your string variable","\S+(?=\n{2}~DATA)").ToString.Replace("~","")

Regards
Sudharsan

#13

Hi @Chippy_Kolot ,
try this:
System.Text.RegularExpressions.Regex.Match(YourString,“(?<=\d\n~)\S{1,}”).Tostring

image

Thanks & Regards,
Shubham Dutta

#14

Have you tried the above expression @Chippy_Kolot , Did you received correct output?

Let us know do you having any queries

Regards
Gokul

#15

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.