challenging Case.Parts of a string

[kaldubai]

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]

Is this you want to show?

[vinieme12]

if your field is numeric then

Field>0

if it's string then use

left(Field,1) = '+'

[kaldubai]

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]

thanks for your replay

my field is not numeric

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

[vinieme12]

can you post an excel sample?

[sasiparupudi1]

Try

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