Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, please advise how to convert the text with number in it into just number in the load editor.
I have a field Duration with string data that has a number of days, and I want to convert it to just a number:
Duration string Duration num
12 Days 12
1 Day 1
2.5 Days 2.5
Please notice, the string could be 'Days' or 'Day'.
I tried Num#, it didn't really help.
Thank you!
in your load script use below
Left(YOUR_COLUMN,Index(YOUR_COLUMN,' ')) as YOUR_COLUMN
basically get the index of the space and get the character to the left of it
Subfield([Duration string ], ' ', 1) as [Duration num]
Please use keepchar() function .
Keepchar([Duration string],'0123456789.') as [Duration num]
in your load script use below
Left(YOUR_COLUMN,Index(YOUR_COLUMN,' ')) as YOUR_COLUMN
basically get the index of the space and get the character to the left of it
Subfield([Duration string ], ' ', 1) as [Duration num]
Please use keepchar() function .
Keepchar([Duration string],'0123456789.') as [Duration num]
Thank you all!
I tried all the suggestions and they all worked! I don't even know which one to choose as a solution 🙂 All methods worked for me.
Thank you again!