topic Re: How to load only numbers in field? in App Development

How to load only numbers in field?

daisy1438 — Fri, 23 Nov 2018 07:39:07 GMT

I have field Data like below

Data:

abc1927-23

2345asjjh123sdh

dr34

text123

111.

222.

333.

I want load only numbers instead of string.and remove the (.)in number.

Output:

111

222

333

Thanks

Re: How to load only numbers in field?

marcus_sommer — Fri, 23 Nov 2018 07:53:21 GMT

Try it with:

t: load replace(FIELD, '.', '') as FIELD from Source where isnum(replace(FIELD, '.', ''));

- Marcus

Re: How to load only numbers in field?

cfitzpatrick69 — Fri, 23 Nov 2018 09:18:25 GMT

keepchar(FIELD,'1243567890') as FIELD where isnum(keepchar(FIELD,'1243567890'))
which would remove all non-number chars

Re: How to load only numbers in field?

sunny_talwar — Fri, 23 Nov 2018 12:24:25 GMT

Another possibility

Table:
LOAD Num(Num#(Data, '##.')) as Data
Where Num(Num#(Data, '##.'));
LOAD * INLINE [
    Data
    abc1927-23
    2345asjjh123sdh
    dr34
    text123
    111.
    222.
    333.
];