Skip to main content
Topics#Tableau Desktop & Web Authoringkuldeep Singh Chouhan's Question
kuldeep Singh Chouhan (ICE) asked in #Tableau Desktop & Web Authoring
Apr 8, 2022, 9:09 AM

how to remove zero from a string

i have a column name "S_id" which contains numeric & alphanumeric values

 

000001231231

0000sdfsdf231

 

here i want to remove remove zero from these values

1 answer
  1. Mavis Liu
    Apr 8, 2022, 10:35 AM

    Hi Kuldeep,

     

    Please use the replace function:

     

    REPLACE([Field],'0','')

     

    Thanks,

     

    Mavis

Write an answer...
0/9000