What is the Regex Pattern to find a part of the text?

[Vaishnav_Tej]

Hi All,

I would like to know the regex pattern to extract “First Name” from below text. It is a column name.
Sort by:
First Name
Sorted: None
Show actions

Any help would be appreciated

[supermanPunch (Arpan)]

@Vaishnav_Tej

I would like to know the regex pattern to extract “First Name” from below text. It is a column name.
Sort by:
First Name
Sorted: None
Show actions

Hi @Vaishnav_Tej ,

We don’t see any value for the First Name field, Is the Value present next to it or is it present in the Next Line ?

If it is present next to it, then you could use the below Expression :

(?<=First Name).*

[Vaishnav_Tej]

It is present in the next line exactly as shown

[supermanPunch (Arpan)]

@Vaishnav_Tej ,

Did you want to extract in the below way :

(?<=Sort by:\r?\n).*

[Vaishnav_Tej]

@supermanPunch

(?<=Sort by:\r?\n).*

Yes, Thank you.

May I know how to learn regex?

[supermanPunch (Arpan)]

@Vaishnav_Tej

May I know how to learn regex?

@Vaishnav_Tej ,

We already have the Tutorials listed here :

Regex help tutorial MEGAPOST – Making your first Regex post, Reusable Regex Patterns, Regex Troubleshooting, Sample Workflow and more

THE PURPOSE OF THIS POST IS TO HELP NEW REGEX USERS If you need help with Regex be sure to provide in your post, a Sample, the Output and the Pattern (as much as you know). CONTENTS: Section : I need a Regex Pattern ASAP! - My first Regex Post Section : Regex samples that you can use! Section : I need help applying regex in UiPath Section : Regex Matches and Groups Section : Le…

[CheatSheet] - System.Text.RegularExpressions | RegEx

This CheatSheet introduces the basic use of regex functions. With further examples also special cases are presented. Introduction From the namespace System.Text.RegularExpressions following methods are offered: Regex.Match Regex.Matches Regex.isMatch Regex.Replace Regex.Split A simple usage for example would look like this: [grafik] Recommendation: add System.Text.RegularExpressions to the imports: [grafik] it allows to use the shortened statement, as the namespace part can be ommited…

[Nitya1 (Nitya Tomar)]

Hi @Vaishnav_Tej

Try this one-

\bFirst Name\b

Thanks!!

[Vaishnav_Tej]

How to replace all the column names in the excel or DataTable using regex?

[Nitya1 (Nitya Tomar)]

You can try this-

Read the Excel file and store the data in a DataTable variable. Use a For Each activity to iterate over the columns in the DataTable. Set the TypeArgument property to `System.Data.DataColumn.Within the For Each loop,use an Assign activity to update the column names using regex.

item.ColumnName = System.Text.RegularExpressions.Regex.Replace(item.ColumnName, pattern, replacement)

Thanks!!

[Vaishnav_Tej]

Hi Nitya,

I’m getting error as shown below .