topic Sample Data trim in QlikView

Sample Data trim

abhaysingh — Wed, 25 Nov 2020 16:16:04 GMT

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

bbbbbbbbbbbbbbbbbbbbb

bbbbbbbbbbbbbbbbbbbbb1

bbbbbbbbbbbbbbbbbbbbb2

bbbbbbbbbbbbbbbbbbbbb3

cccccccccccccccccccccccc

cccccccccccccccccccccccc1

cccccccccccccccccccccccc2

cccccccccccccccccccccccc3

cccccccccccccccccccccccc4

cccccccccccccccccccccccc5

];

OUTPUT REQUIRED

bbbbbbbbbbbbbbbbbbbbb

cccccccccccccccccccccccc

MK_QSL — Fri, 13 Jan 2017 07:03:28 GMT

PurgeChar(YourFieldName,'0123456789') as YourOutPutFieldName

susovan — Fri, 13 Jan 2017 07:19:32 GMT

Try This,

Data:

LOAD * INLINE [

data

bbbbbbbbbbbbbbbbbbbbb

bbbbbbbbbbbbbbbbbbbbb1

bbbbbbbbbbbbbbbbbbbbb2

bbbbbbbbbbbbbbbbbbbbb3

cccccccccccccccccccccccc

cccccccccccccccccccccccc1

cccccccccccccccccccccccc2

cccccccccccccccccccccccc3

cccccccccccccccccccccccc4

cccccccccccccccccccccccc5

];

LOAD *,

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

Resident Data;