topic Re: Delete symbol and change string to numerical value in QlikView

Delete symbol and change string to numerical value

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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!!

Re: Delete symbol and change string to numerical value

Thu, 24 Nov 2016 11:47:49 GMT

Hi,

try this :

Load

KeepChar(FieldName,'0123456789') as FieldName

from

abc.xls;

Re: Delete symbol and change string to numerical value

antoniotiman — Thu, 24 Nov 2016 11:51:35 GMT

Hi Charlotte,

use

PurgeChar(Field,' <>')

Regards,

Antonio

Re: Delete symbol and change string to numerical value

Anil_Babu_Samineni — Thu, 24 Nov 2016 11:53:27 GMT

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

];

Re: Delete symbol and change string to numerical value

Anonymous — Thu, 24 Nov 2016 12:49:36 GMT

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