I have following data on pdf which I need to extract using regex
Now the question which is “Who has access to the digital solution?” will be constant and I need to extract below options which will be dynamic value,
here you can see two options are available which are a and c but it may contain one or more options.
So any suggestion on how to extract the options using the question above with the help of regex?
How about the following expression?
System.Text.RegularExpressions.Regex.Match(yourString,"(?<=Who has access to the digital solution\?\r?\n)[\s\S]*?(?=\r?\n\r?\n)").Value
did it work for you ?
Not working for me though
Can you set your string to yourString variable?
see, I am doing like below, using activity
In the input section, I have put the data
@Debartha_Mitra_DE - there is no groups in the pattern which @Yoichi shared…
so just use Matchvalues(0).value.tostring
tried but threw the same error.
It might be no match.
Can you share your string as text (or text file), if possible?
“# Who has access to the digital solution?
a. PwC Owning Member Firm Users - Employees/Contractors of owning territory
c. Client Users - Client Users”
There can be text before ‘#’ which is not required and after the end of options which is not required
Can you try the following sample?
Sample20210325-1.zip (2.6 KB)
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.