Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
PurgeChar(YourFieldName,'0123456789') as YourOutPutFieldName
PurgeChar(YourFieldName,'0123456789') as YourOutPutFieldName
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;