How to trim a value?

jim_chan — Sat, 16 Nov 2024 03:46:11 GMT

Hi guys,

I have a problem here. the existing code looks like SG01_MEATY_ABCD_SG and i need to trim it removing front and back , and just keep the word "MEATY". other code like "SAUSAGE001" with no special code at the front and back , should remain as it is.

I have attached a sample qvw file.

Please help guys!

Thanks.

Rgds,

Jim

Re: How to trim a value?

izzat_amir — Thu, 25 Apr 2019 02:19:08 GMT

Can u try the code below:

table1:
LOAD my_code,
if(wildmatch(my_code,'*_*'),subfield(my_code,'_',2),my_code) as new_my_code;
LOAD * INLINE [
my_code
SG01_MEATY_ABCD_SG
SG02_MEATY_CDEF_SG
SAUSAGE001
];

topic How to trim a value? in QlikView

How to trim a value?

Re: How to trim a value?