Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Delete symbol and change string to numerical value

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

1 Solution

Accepted Solutions
antoniotiman
Master III
Master III

Hi Charlotte,

use

PurgeChar(Field,' <>')

Regards,

Antonio

View solution in original post

4 Replies
Not applicable
Author

Hi,

try this :

Load

KeepChar(FieldName,'0123456789') as FieldName

from

abc.xls;

antoniotiman
Master III
Master III

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

];

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Anonymous
Not applicable
Author

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