Extracting integer data from field

[#1]

Hi,

i know it is very simple question but just want to know the syntex for it.

I want to extract integer data only from below field.

DATA
0 AU
1 IN
2 UK

output

DATA
0
1
2

[tresesco · Accepted solution]

try like:

Load

          KeepChar(DATA, '0123456789') as DATA

[Anonymous]

use left (Data,1) if you have 1 Digit numbers

[#4]

no i have two,three  digit numbers also

[ecolomer]

subfield(DATA,' ', 1)

[ecolomer]

subfield(DATA,' ', 1)

[#7]

Hi,

Use can use Subfield(DATA,' ' , 1)

or

you can also use Left function (if your country code length will always be 2 )  like this

=Left(DATA, len(DATA)-3)

Regards,

Vivek