I want to cut the word that is inside the ‘-’, either the word of any length. Example:
String: -----HELLO-----
SubString : ‘HELLO’
thank you…
I want to cut the word that is inside the ‘-’, either the word of any length. Example:
String: -----HELLO-----
SubString : ‘HELLO’
thank you…
Hi Javi,
If you have CapeSoft StringTheory look at:
Between: http://www.capesoft.com/docs/StringTheory/StringTheory.htm#Between
and
FindBetween: http://www.capesoft.com/docs/StringTheory/StringTheory.htm#FindBetween
Regards
Johan de Klerk
As Johan says, StringTheory helps here - there are lots of options.
another option would be to use trim to remove ‘-’ from front and back of the string:
st.setValue(’-----HELLO-----’)
st.trim(’-’)
stop('string is now ’ & st.getvalue())
cheers
Geoff R
Failing string theory there’s an included SystemString class from SV.
Or just use INSTRING() and SUB() to get there