topic Re: select string value from starting to a special character. in QlikView

select string value from starting to a special character.

Architect — Mon, 14 Dec 2020 09:36:18 GMT

I have a field value that looks like =

ABB-343

BADDD-7787

GG3WW-889H.

THESE VALUES ARE made up with the logic --" ITEM_TYPE & '-'& ITEM_NO AS FIELD1".

now help me select only "ITEM_TYPE" FROM THE FIELD1 string.

My understanding we have to select data from the 1st left value up to '-'.

Taoufiq_Zarra — Mon, 14 Dec 2020 10:28:37 GMT

=subfield(Field,'-',1)

Field is ITEM_TYPE & '-'& ITEM_NO AS FIELD1

like for example :

Architect — Mon, 14 Dec 2020 11:54:36 GMT

Thanks, Taoufiq,

But I have used the below method, and it is working well.-

TextBetween(FIELD1 ,'','-') AS ITEM_TYPE.