trim on number

simran_dua

Hi all

I need to trim a column which has a number from 11 digits to 10 digits . 

I tried converting it to string first using the "Tostring" function . (I created a new column to do this ) 

Post that the "Metadata" showed the type to be V_String . 

The new column I created above which did show the format to be V_string , I used that for the trim function but it gave me an error 

Parse error at char (0) : Type mismatch. Number provided where a string is required .

otherwise is there some way to trim a number ?

can you please suggest what should I do ?

thanks 

fmvizcaino

Hi @simran_dua ,

The only thing you are missing are the quotes in the 2nd parameter.

trim([Filed name],'5')

But you need to use trimleft or trimright to remove character from the sides. Trim function as you wrote will remove the number 5 from the edges of your number. For example, the number 515 = 1, 15 = 1

Best,

Fernando Vizcaino