Remove Records

[gautik92]

I have a table with records containing alphabets and numbers but i want to remove the records whic contain alphabets.

ID

101/001

101/002

UPAXY

NFKAO

MAJFJF

I have to remove the records which contain alphabets

[sunny_talwar · Accepted solution]

May be this in the where clause

LOAD FieldName

FROM Source

Where Len(Trim(KeepChar(Upper(FieldName), 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'))) = 0;

UPDATE: Sample attached

[ajsjoshua]

Hi Bro,

Try

keepchar(FIELD, '/0123456789') as NEWFIELD

in your load or equivalent in an expression.

[tamilarasu]

Hi Bro,

If the field values are fully text or number, then you can try like below,

If(Isnum(Left(FieldName,1)),FieldName) as FieldName

or

Where Isnum(Left(FieldName,1))= -1