How to Extract String with Spaces using Regex

Help Activities
,
1

Hi All,

I want to extract data from Email Body in which one filed has space in between the string value. Can anyone help me in getting this please?

Ex : Vendor Name : this is for Test
so here i want to extract Vendor Name value which is " this is for Test".

2

Hello @Aswini,

Yes, you can extract the value of the field like “Vendor Name” using Regex (Regular Expressions).

Use this Query:-

System.Text.RegularExpressions.Regex.Match(yourEmailBodyText, “Vendor Name\s*:\s*(.*)”).Groups(1).Value

1 Like
3

The image depicts a text editor containing a regex pattern, a test string, and the highlighted extracted value from the string. (Captioned by AI)
The image depicts a text editor containing a regex pattern, a test string, and the highlighted extracted value from the string. (Captioned by AI)768×255 19.3 KB

4

Its working Thank u so much

5

@sagar.singh1 when i tried with actual data im getting the next line data as well. can u help me with this please?i just want vendor name from the below text is it possible to extract?

Received and reviewed, please process

Program Name: Falls Lake - JSA
Vendor Name: McAngus Goudelock , LLC
Vendor Address 1: PO Box 964
Vendor Address 2: not specified
Vendor City: Test
Vendor State/Location: NC
Vendor Postal Code (ZIP): 28296-1234
Vendor Tax ID (FEIN): uu16548
Claim #: P10000
Claim Professional: Wanda
Final Invoice: No
Invoice #: 164119
Total To Pay: 1727.72

6

Hi Aswini,

Could you add word bound at the end and try as below.

image
image876×454 38.8 KB

7

Vendor Name\s*:\s*(.*)

Vendor Name – matches the literal text.

\s* – matches any optional whitespace.

: – matches the colon.

\s* – matches any optional whitespace after the colon.

(.*) – captures everything after that (the desired text).

Mark solution if its help :blush:

8

Hi @Aswini,

This is also working ‘Vendor Name\s*:\s*(.*)’ and @Saravanan_Samy your query is correct.

@Aswini both query is correct.

1 Like
9

This seems like working in regex editor but when it comes to UiPath not giving the desired output

image
image1479×942 68.2 KB

10

Will Vendor Name always be at the start of a new line?
If that’s the case you could try adding a ^ before the expression:
^Vendor Name\s*:\s*(.*)\b

11

Hello @Aswini,

you can use this two Regex Query.

1.Vendor Name\s*:\s*(.*)$

2.Vendor Name\s*:\s*([^\r\n]*)

Check and confirm once done.

12

Hello @sagar.singh1

Its working for me its giving me just Vendor name. Thanks for your help. However i am getting the result including the Field name as 'Vendor Name: McAngus Goudelock & Courie, LLC ’

13

Hello @Aswini,

You are getting the result including the Field name as 'Vendor Name: McAngus Goudelock & Courie, LLC ’

Because you are using Regex Builder activity if you are using assign activity then my query is give the output only ’ McAngus Goudelock & Courie, LLC ’ .

If you are free then schedule a meeting i will fixe.

14

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