Regex Extraction Query

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 :slight_smile:

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(:slight_smile: and i don’t want that one.
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???

Hey @agathiyanv

Can you paste the sample and bold/highlight expected output?

Cheers

Steve

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