Hello and thank you for any help. I am working on a process where I use data scraping to pull a value from a website. The value being pulled is US currency amounts and they appear as USD 200.00 or USD 558.0, etc. I need to perform logic on the value scraped but I cannot do that with the "USD " on t…

@mworth123 Great. Could you please close this thread my marking above post as solution. It will help others also the one who are looking for same solution.

You can explore substring to get the value that you want @mworth123

@ pattyricarte - Thank you but I’m not seeing substring in the list of activities. How do I access it?

@mworth123 Maybe i can give you some article to be your reference.right now i cant give example.im driving going to work my apologies.

@ pattyricarte - Thank you, I can wait. Your safety is more important than my process

@ pattyricarte - I found this but it’s throwing an error. I am a noob [2019-10-14_164805]

Before it was saying I can’t convert an integer to a string so I tossed in the To.String - it didnt help

@mworth123 Try below one. Str = “USD 200.00” requiredStr = Str.Replace("USD","").Trim

Hi @mworth123 My apologies for the late reply.What exactly do you want to do.? cheers :smiley: Happy learning :smiley:

By the way you can read this as your reference to your issue. @mworth123 [image] How to manipulate a part of string: Split, Trim, Substring, Replace, Remove, Left, Right Tutorials Hi, if you are a beginner in the world of automation and would like to know how you can ma…

Hi @mworth123 , Get the string and use if, like if yourstring.contrains(USD) Assign … Yourstring = yourstring.replace(“USD “,””) this will give only the valeu you have whant, now do the same to other curencies

Help with string manipulation

Help

pattyricarte (Patty Boy) October 15, 2019, 6:22am 10

By the way you can read this as your reference to your issue. @mworth123

cheers

Happy learning

2 Likes

Topic		Replies	Views
How to fetch only the value from the string leaving behind currency symbols Studio studio , question , activities_panel	8	974	January 18, 2023
Get a specific value from string Help uiautomation , activities , question	9	5291	November 8, 2019
How to split amount of USD Activities activities , web , question	6	818	September 27, 2022
Strip out certain data from a string Help studio , variable	26	4095	October 29, 2018
How to split string variable Help activities , string , question , data_manipulation	6	4195	December 7, 2019

Help with string manipulation

Related topics