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

Create a new column and insert the dax as follows

 

trimlastcharacter= LEFT(tablename[columnname],LEN(tablename[columnname])-1)

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Abi,

     

    The apostrophe could be anywhere in ths string ie  O'Neil

     

    Thanks

     

    C

    • 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!