Need to extract data using REGEX

[manu_sept]

Hi,

I need to extract the data from the sentence mentioned below coming after Item Number of Purchasing Document into sperate column. I am trying to use RegEx but I am not able to figure it out.

SENTENCE: Client: 100; Purchasing Document Number: 4514967096; Item Number of Purchasing Document: 00020; Delivery Schedule Line

Looking forward to hear it from the community 

Thanks 

[atcodedog05]

Hi @manu_sept 

You can Try Regex parse mode expression

Item Number of Purchasing Document: (\d+)

[atcodedog05 · Accepted solution]

Hi @manu_sept 

Here is an example for the explanation.

Hope this helps 🙂

[messi007]

@manu_sept,

below the Regex that will do it as well 🙂

Attached the workflow,

Regards,