Hi can anyone please help me solve regex issue

Help Studio
, ,
1

~AA40% -~13,683.89
~FINALDATA

~PA RT#
This is the input from here i only want to extract FINALDATA as output, but im facing space issue between ~PA RT# and FINALDATA
I provided regex in matches as \S.+\n(?=(~PA RT#)),I have similar txt files,but all are reading FINALDATA in those txt files space is not there between FINALDATA nad ~PA RT#. Can anyone please help me to resolve this

2

Hello @Chippy_Kolot ,

You can do as per the below screenshot.

\S.+\n(?=(~PA RT#))|\S.+\n\n(?=(~PA RT#))

image

Thanks,
Sanjit

3

[A-Za-z ](FINALDATA)[A-Za-z ]

image
image740×463 14.7 KB

4

You can do something like this if your text is the same.

image

5

Hello

Take a look here.

Preview the pattern here.

Pattern:
[A-z\s]+(?=[\r\n]+~PA\s+RT)

image
image1128×1252 94.5 KB

Cheers

Steve

6

Hi @Chippy_Kolot

You can try with Regex expression

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

Output : FINALSUM & FINALDATA

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

Output : DATA# & PA RT#

image
image1120×429 33.7 KB

7

Hello @Chippy_Kolot
Kindly try this
(?<=~).*(?=\n\n~PA)

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

image

8

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

Let us know do you having any queries?

Regards
Gokul

9

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