extraction first "0", and the length if "0" is at the beginning

Highlighted
AnastasiiaSolom
Level 1
extraction first "0", and the length if "0" is at the beginning
Jump to solution
Good afternoon,

Is it possible to get the first character as 0? For example i have two numbers

24567 and 02456, so i tried the fonction get (x,0,1) but at the sacond case its giving to me "2" instead of "0", as well if i calculate the length, it will be "4" instead of "5". Which function should i use to get first 0 and the legth of characters as 5?

PS: I tried transfer my data to string and after use the function but it didnt work.



Thank you in advance! Anastasiia
0 Kudos
1 Solution

Accepted Solutions
Clément_Stenac Dataiker
Dataiker
Re: extraction first "0", and the length if "0" is at the beginning
Jump to solution
Hi,

Formula will always autocast when referencing the column directly, even if the storage type is string. To avoid that, replace x in your formula by strval("x")

So it would look like: substring(strval("x"),0,1)

View solution in original post

1 Reply
Clément_Stenac Dataiker
Dataiker
Re: extraction first "0", and the length if "0" is at the beginning
Jump to solution
Hi,

Formula will always autocast when referencing the column directly, even if the storage type is string. To avoid that, replace x in your formula by strval("x")

So it would look like: substring(strval("x"),0,1)

View solution in original post

Labels (2)