Extract text from String to map in Excel

[Ripusudan_Sharma]

Hello All,

we want Extract Specific text from String and Map in in Excel as shown in Image attached .
We want extract all Serial no and Model no from Text so we can map then in excel.
So kindly help us with logic to implement same.

[Palaniyappan (Forum Leader)]

You can get the value with Regex like this

Use assign activity to get the Regex matches like this
For example

out_matches = System.Text.RegularExpressions.Regex.Matches(Strinput.ToString, “your Regex expression”)

Check this out for more insights

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…

Hope this helps

Cheers @Ripusudan_Sharma

[Yoichi]

Hi,

Can you try the following sample?

mc = System.Text.RegularExpressions.Regex.Matches(strData,"Model:\s*(?<MODEL>.*?)\s+SN#:\s*(?<SN>\w+)")

Sample
Sample20231010-1aL.zip (3.3 KB)

regards,

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @Ripusudan_Sharma ,
You can get text by regex then compare them
or
use string replace,

How to manipulate a part of string: Split, Trim, Substring, Replace, Remove, Left, Right

Hi, if you are a beginner in the world of automation and would like to know how you can manipulate text based on the solutions available in the VB.NET code and using REGEX (regular expressions) then you are in the right place. In the topic below, you will learn how to easily extract data from any part of the search text using various methods. The topic includes solution examples with descriptions and graphics to better understand the topic for functions such as: Split Substring Left Right R…

regards,