Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Is this you want to show?
if your field is numeric then
Field>0
if it's string then use
left(Field,1) = '+'
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 +
thanks for your replay
my field is not numeric
and the string formula you provided i do not it serves what i need
can you post an excel sample?
Try
TextBetween(value,'+',';') as NewValue