Cutting a string into pieces

[thomas_deschle]

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.

[Taoufiq_Zarra · Accepted solution]

@thomas_deschle 

Serveral options, one :

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

output:

[thomas_deschle]

Thank you Taoufiq! Works 😀.