Remove "

Help
, ,
1

Hello everyone,
I have one string i need to remove ¨V⁄¶}⁄ »⁄·¤“O⁄ À⁄flƒQV⁄◊⁄fl in ¨V⁄¶}⁄ »⁄·¤“O⁄ À⁄flƒQV⁄◊⁄fl 245.10, but the problem i am facing is “, after »⁄·¤ there is double inverted comma, i am not able to perform the string manipulation, I have tried with String.Replace(char(34),string.Empty)
Can anyone help!!!

Thanks in advance,
Jyothi M B

2

Hi,

Can you attach a text file contains your string because this forum automatically convert some characters such as double quote to others?
Or Please use Preformatted text (Use </> on menu) .

Regards,

3

computation.txt (63 Bytes)

I need only 245.10

4

Hi,

Can you try Replace activity with the following settings.
Input: yourStrData
Pattern : "^.*?(?=\d)"
Replacement : ""
Result : yourStrData

Regards,

5

@jyothi_M.B use regex to get that value

\d.+
try that regex

6

@jyothi_M.B Can you please clarify every time whether the format of 245.10 is same or different

7

different

8

@jyothi_M.B Try this Regex and let me know

9

its not working

10

Hi,

Can you try the following?

Main.xaml (5.6 KB)

I’m glad if you could point my misunderstanding if there is.

Regards,

11

Screenshot (333)
Screenshot (333)1920×1080 157 KB

Thanks Yoichi,
Its working fine but i getting error here

12

Can you share the error message? (Please hover mouse pointer on blue exclamation mark)

13

Screenshot (333)
Screenshot (333)1920×1080 157 KB

14

For that
use
“»⁄·¤”+“”“”+“O⁄ "
so it will take “””" as " as string

15

Hi,

Still cannot see error message, but probably it’s caused by double quote character in your data.

You can solve it by one of the following

・Please add " before “O⁄ like as follows
"¨V⁄¶}⁄ »⁄·¤"“O⁄ À⁄flƒQV⁄◊⁄fl 245.10"

or
・Save the string to text file and read it using Read Text File activity.

Regards,

16

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.