Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this in the where clause
LOAD FieldName
FROM Source
Where Len(Trim(KeepChar(Upper(FieldName), 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'))) = 0;
UPDATE: Sample attached
May be this in the where clause
LOAD FieldName
FROM Source
Where Len(Trim(KeepChar(Upper(FieldName), 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'))) = 0;
UPDATE: Sample attached
Hi Bro,
Try
keepchar(FIELD, '/0123456789') as NEWFIELD
in your load or equivalent in an expression.
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