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
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
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?