Cutting a string into pieces

thomas_deschle — Tue, 15 Sep 2020 14:07:53 GMT

Hi community,

I am trying to do something in Qlik that I've been used to do in Excel.

Our erp has searchnames for articles that we have standardized, meaning exactly first 7 characters product name, then type of product (variable length), "-" and further information, like
NAMEISAtype1-long
NAMEISBtype2-short
NAMEISCtype23-shortest

How should the formula in the editor look so I have a new field "producttype"? In the example this would contain
type1
type2
type23

In Excel I would use the search-function for the position of the "-" and cut off the rest with left and right. Couldn't find something similar in the data editor.

Thanks for your help.

Re: Cutting a string into pieces

Taoufiq_Zarra — Tue, 15 Sep 2020 14:22:23 GMT

@thomas_deschle

Serveral options, one :

=textbetween('-'&mid(Field,8),'-','-')

output:

Re: Cutting a string into pieces

thomas_deschle — Tue, 15 Sep 2020 14:32:28 GMT

Thank you Taoufiq! Works 😀.

topic Re: Cutting a string into pieces in App Development

Cutting a string into pieces

Re: Cutting a string into pieces

Re: Cutting a string into pieces