String Function Purge Text Values keep Number Values

[#1]

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

Order No
N000001
1235
G000002

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

[#2]

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

Order No:

G00001

N00001

     1235

G00002

        35

Actual Order No:

1235

35

[swuehl · Accepted solution]

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)