Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
Hi,
try this :
Load
KeepChar(FieldName,'0123456789') as FieldName
from
abc.xls;
Hi Charlotte,
use
PurgeChar(Field,' <>')
Regards,
Antonio
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
];
Made it work I guess it was a typo somewhere, my mistake. Thank you all!