Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

How to strip out characters from a string

Hi,   I have two seperate systems where one stores the surname with '  apostrophes etc and one which stores them without.   How would I go about removing the ' from a string.  I have tried using ...
Need Help
  • abhi9255's avatar
    abhi9255
    8 years ago

    for example remove "-" from the string

     

    =SUBSTITUTE([columnname], "-", "")

abhi9255's avatar
abhi9255
Advocate II
8 years ago

for example remove "-" from the string

 

=SUBSTITUTE([columnname], "-", "")

Anjan88's avatar
Anjan88
New Member
3 years ago

Excellent, almost cracked my head before viewing this. Thank you very much!