topic String Function Purge Text Values keep Number Values in QlikView

String Function Purge Text Values keep Number Values

Thu, 05 Sep 2013 09:06:02 GMT

Hi,

In need of help!

This should be simple but I cannot think of the function to do this.

I have a field that contains text strings and number values e.g.

G000001 35

All I want to do is Keep the Number Values so that I end up with a table e.g.

123535

Actual Order No

I need to do this in the load script. Any help appreciated?

Thanks

Nikki

Thu, 05 Sep 2013 09:07:46 GMT

Sorry the Tables didn't display properly, they should be:

Order No:

G00001

N00001

1235

G00002

Actual Order No:

1235

swuehl — Thu, 05 Sep 2013 09:09:58 GMT

Your sample table looks a bit distorted, so not sure how your data really looks like.

Try something like

LOAD OrderNO FROM ... WHERE isnum(OrderNo);

If you need to split a value first into a text and a number part, try subfield(OrderNo, 'SeparatorChar', 2)