Regex for Invoice number and discreption

(1) Share

Report

Posted on by Dg_Reddy

Hi,

Column Result

Finance Desc 12345678 12345678 Finance Desc

12345678 Description 12345678 Description

des 12345678 12345678 des

Description Description

My Task is. first number should come and then desc has to come. See the result field for reference. if number is not vailable it should come only description in the result. Kindly suggest how to write regex for this. Thanks in advance

Regards,

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

Rkv_ 166 on at

Like
a
(0)

Report
Copy link

Link copied!

@Dg_Reddy You can use two parse text actions, One is to retrieve the Text and other is to Retrieve the number.

To retrieve text you need to use [A-Z,a-z,\s?]+ as regex in the parse text action and \d+ to retrieve the number.

I hope this helps you.

Was this reply helpful? Yes No
Verified answer

Rkv_ 166 on at

Like
a
(0)

Report
Copy link

Link copied!

@Dg_Reddy You can use two parse text actions, One is to retrieve the Text and other is to Retrieve the number.

To retrieve text you need to use [A-Z,a-z,\s?]+ as regex in the parse text action and \d+ to retrieve the number.

I hope this helps you.

Was this reply helpful? Yes No
Dg_Reddy 25 on at

Like
a
(0)

Report
Copy link

Link copied!

This is worked but some times description is having number. kindly provide regex for
ex:
Column: Result:
Finance 12345 12345678 12345678 Finance 12345

1) Find 8 Digit Number - 12345678
2) Find Rest of all apart from 8 Digit Number - Finance 12345
??
thanks in advance

Was this reply helpful? Yes No