Sample Data trim

[abhaysingh]

Hi Guyz,

i have this kind of data with have some number like 1,2,3,4,5,6,7 at the end of the of the string, and string length is not defined,

how i can truncate it..

kindly suggest

LOAD * INLINE [

     data

     A

     A1

     A2

     A3

     A4

     bbbbbbbbbbbbbbbbbbbbb

     bbbbbbbbbbbbbbbbbbbbb1

     bbbbbbbbbbbbbbbbbbbbb2

     bbbbbbbbbbbbbbbbbbbbb3

     cccccccccccccccccccccccc

     cccccccccccccccccccccccc1

     cccccccccccccccccccccccc2

     cccccccccccccccccccccccc3

     cccccccccccccccccccccccc4

     cccccccccccccccccccccccc5

  ];

OUTPUT REQUIRED

A

bbbbbbbbbbbbbbbbbbbbb

cccccccccccccccccccccccc

[MK_QSL · Accepted solution]

PurgeChar(YourFieldName,'0123456789') as YourOutPutFieldName

[susovan]

Try This,

Data:

LOAD * INLINE [

    data

    A

    A1

    A2

    A3

    A4

    bbbbbbbbbbbbbbbbbbbbb

    bbbbbbbbbbbbbbbbbbbbb1

    bbbbbbbbbbbbbbbbbbbbb2

    bbbbbbbbbbbbbbbbbbbbb3

    cccccccccccccccccccccccc

    cccccccccccccccccccccccc1

    cccccccccccccccccccccccc2

    cccccccccccccccccccccccc3

    cccccccccccccccccccccccc4

    cccccccccccccccccccccccc5

  ];

LOAD *,

Replace(if(Right(data,1)<=1,data),'1',' ') as New_Data

Resident Data;