How to split string variable

[Ivan_torres_oliva]

how can I divide a string like this after the money symbol and before space

Support is requested for tickets (suburban and taxis) in the state of Chiapas for an amount
of $ 600.00. for each auditor

the exit would be this

600

[Prafull_B (Praf)]

@Ivan_torres_oliva

first split by "$ " – store its 1st index in variable
then split by “.” — store its 0th index in variable

here’s sample for reference

[Yoichi]

Hi,

If you want to extract only the value (like 600), the following expression might help you.

System.Text.RegularExpressions.Regex.Match(yourStrData,"(?<=\$\s*)\d+").Value

Regards,

[pattyricarte (Patty Boy)]

Hi @Ivan_torres_oliva

You can read this article below for your reference.

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…

cheers

Happy learning

[Mohansadaiyapillai (Mohanraj S)]

Split.xaml (4.5 KB)

I have created a xaml based on your requirement.

[vinay_reddy]

Hi,

String variable str1 = Support is requested for tickets (suburban and taxis) in the state of Chiapas for an amount of $ 600.00. for each auditor

Use

Assign activity

Str1 = str1.split(“$”.tochararray)(1).trim.split(“.”.Tochararray)(0)