QUERY-1:
Non-acceptance info:43506056450
how can i create a pattern to extract the data with the name “non-acceptance information”
(i.e) inside the pattern i need to enter the name “non-acceptance information” and it need to extract the “non-acceptance info” data.
QUERY-2:
“:22-6-2022”
I need to extract the date without the colon. I don’t know how to specify the pattern for this.
Hi @agathiyanv
I think we may need a bit more information.
Query 1.
Will it be the only text? Will it be the top line?
Query 2:
Will it be the only text? Will it be the top line?
In the meantime I have made some interim patterns.
Query1 Regex Pattern - Preview/test it here.
Query2 Regex Pattern - Preview/test it here.
Let me know how these go.
Hopefully this helps.
You can learn Regex from my Regex MegaPost
Cheers
Steve
1 Like
I created a loop and inside the loop i created a general regex patten to extract the values ,if you see between date/time/period to free text the dates are begin with colon(

this is the general pattern-“(?<=(”+names+“))(.*)”.[names(variable)-changes after every looP]
I don’t know how to modify the pattern and it won’t affect other data also???
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.