Hello Experts,
I want to extract phrases in a sentence using uipath. How can I extract these phrases?
for example:
I have the following sentence:
“CN/MDY/MCP/2200008 -210,200.00 210,200.00 -22,000.00”
and want to extract like this:
CN/MDY/MCP/2200008
-210,200.00
210,200.00
-22,000.00
If thre is any solution or work around, please let me know. Thanks.
Hello you can use the split method to do this. Firstly you would need to split on “-” and then by " " to get the splits you want I believe
It contains whitespace and I only want to extract the data. How can I fix this. Please let me know. Thanks.
Hey!
What’s your expected output?
Regards,
NaNi
Hello @Zaw_Win_Htun1
Try this
yeah I want to remove whitespace and get only data in a sentence.
my text string can contain whitespace between phrases like this:
“CN/NPT/MCP/2200001 -25,700.00 -25,700.00 -2,600.00”
How can I extract the data? If there is any solution, please let me know.
Hi
Regards,
Dhanush
Hi
you want to remove the whitespace or u want to add the more whitespace
Regards,
Dhanush
I want to remove the whitespace.
Best Regards,
Hi @Zaw_Win_Htun1,
Please use string split by space. You will get string type array
Hello bro,
I have got the following output:
I want to remove the whitespace in my output.
Hey Try this:
System.Text.RegularExpressions.RegEx.Match(StrInputVariable,"\w.*[A-Z]{1,}.\d{1,}|[-]\d{1,}.\d{1,}.\d{1,}|\d+.\d{1,}.\d{1,}").ToString
Reference:
Regards,
NaNi
This is the solution I want. Thanks @Gokul_Jayakumar for your solution. Best Regards.
@Zaw_Win_Htun1
Happy Automation 
ashokkarale
Akash_Javalekar1
KezayAlperen
Yoichi
naveen.s