Delete symbol and change string to numerical value

[Anonymous]

Hi all!

I have a column consiting of string-values with either "<" or ">" before a number:

< 25

< 36,0

>100

I wish to delete the symbol before the number and then convert the numbers to numerical values. How can I do this? I've tried the mid-function in my LOAD stage as a first step but can't make it work. Any advice?

Thanks!!

[#2]

Hi,

try this :

Load

KeepChar(FieldName,'0123456789') as FieldName

from

abc.xls;

[antoniotiman · Accepted solution]

Hi Charlotte,

use

PurgeChar(Field,' <>')

Regards,

Antonio

[Anil_Babu_Samineni]

Why not simply this, How values looking. Does this Value has same format then you can use this

LOAD PurgeChar(Value,'<>') as Value Inline [

Value

< 25

< 36,0

>100

];

[Anonymous]

Made it work I guess it was a typo somewhere, my  mistake. Thank you all!