Removing " from a string

2 posts / 0 new
Log in or register to post comments
Last post
Thu, 02/09/2023 - 01:36
#1
atul2312
Offline
Joined: 02/09/2023 - 01:30
Removing " from a string

Hi, How do I remove " from a string. If I use " " " , it shows an error as Invalid parameter.

Top
Thu, 02/09/2023 - 05:18
Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Hi atul2312,

You have to use the ASCII code to get ridof the " in a string.

In the equation editor the formula would be:

@Remove(DATA, @Chr(34))

@chr(34) represent the "

 

Top