i want to extract the item description and currency from this text. what’s the regex line for this matches
Item Description Quantity Price Per Total
Various paper supplies 1 269033 USD 269033 USD
Subtotal: 224194 USD
Hello, I would like to help you, So you in this case the output should be
Item: Various
Description: Paper Supliers
Currency : USD
Right?
And Also do want each of them in a differet variable?
thank you so much but output will be
item description : Various paper supplies
Currency : USD
but it will be dynamically changes not fixed text but the same formula
You want the Total or Price amount??
no only Currency like USD EUR
@Mohamed_Hassan1 - In the given text, it’s on 3 places…so let us know which one you want exactly??
any one of them
@Mohamed_Hassan1 - Please check this…
StrDescrption = System.text.regularexpressions.regex.matches(yourtext,"?<=Total\r?\n)(.+)\s+\d+\s+\d+\s+([A-z]{3})")(0).groups(1).tostring
Strcurrency = System.text.regularexpressions.regex.matches(yourtext,"?<=Total\r?\n)(.+)\s+\d+\s+\d+\s+([A-z]{3})")(0).groups(2).tostring
For your reference
Hope this helps…
thank you if i want only Various paper supplies in variable and currency USD in variable what the regex
that’s what I provided…check $1 and $2…which groups1 and groups2…
how can i used in uipath sequence
I gave the 2 assign statements, all you have to do is just copy and paste and run…for more on how to use Regex…please refer this page here…
I share with you anothe Expresion
str_Currency = System.Text.Regularexpressions.Regex.Match(str_Text,“(?<=Subtotal:\s(\d+\s)).+”).tostring
str_Description = System.Text.Regularexpressions.Regex.Match(str_Text,“(?<=Total\n).+(?=\s\d?\s)”).tostring
Try to use it and let me know if that works
Instead of .Matches it’s just .Match
System.Text.Regularexpressions.Regex.Match(str_Text,“(?<=Subtotal:\s(\d+\s)).+”).tostring
@Mohamed_Hassan1 - looks like your input text might be different than what you have provided…can you please show your assign statement?