challenging Case.Parts of a string - Qlik Community

kaldubai · ‎2017-01-22

i have a field which holds the codes for all the toppings the default once and the extra once

the field look like the following

field name : toppings

value:-061;-061;-061;-061;-061;-061;-061;-061;-061;-061;-061;-061;-061;-061;-061;-061;-061;-061;-061;-061;-061;-061;-061;-061;-061;-061;-061;-061;-061;-061;-061;-061;+636;601;671;024;023;043;061;033;059

you can see here that i have - and + value

what i want is to extract only the + once as it denote the extra toppings

your help very much appreciated

Anil_Babu_Samineni · ‎2017-01-22

Is this you want to show?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

vinieme12 · ‎2017-01-22

if your field is numeric then

Field>0

if it's string then use

left(Field,1) = '+'

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

kaldubai · ‎2017-01-25

thank you for your response

i only need the once that is prefixed with + and the value may have more than one sub string which is prefixed with a +

kaldubai · ‎2017-01-25

thanks for your replay

my field is not numeric

and the string formula you provided i do not it serves what i need

vinieme12 · ‎2017-01-25

can you post an excel sample?

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

sasiparupudi1 · ‎2017-01-25

Try

TextBetween(value,'+',';') as NewValue