how to remove string values in a field?

[daisy1438]

Hi

I have one field like below it showing numbers and string values.so if requirement keep string in a field remove numbers or if requirement keep numbers  remove strings.how?

data:

1203

4567

OBALT

OBALT

9200

3456

22334

OEUROPE

OEUROPE

like that.

data is field name.

Thanks

daisy

[ychaitanya]

Hello Daisy

load PurgeChar(data,'OBALTEUORPEABCDEFGHIHKLMN')  as Data1,

KeepChar(data,'OBALTEUORPEABCDEFGHIHKLMN') as data2;

LOAD * INLINE [

    data

    1203

    4567

    OBALT

    OBALT

    9200

    3456

    22334

    OEUROPE

    OEUROPE

];

Please mark the posts as Helpful or answered to close the discussion so that it would be helpful for others in the community