I have a title "Beginning / Intermediate Jazz" and I want to move the "Beginning / Intermediate" to the end with a colon before it so I need:
"Beginning / Intermediate Jazz" changed to "Jazz: Beginning / Intermediate"
============
I have in the formula
if instr({title}),"Beginning / Intermediate") = 1
then
ltrim( mid({title},25,len({title})-24) & ": " & "Beginning / Intermediate")
==============
It is changing the title to "/ Intermediate Jazz: Beginning" so I'm thinking the forward slash is causing the problem.
Help is appreciated.
"Beginning / Intermediate Jazz" changed to "Jazz: Beginning / Intermediate"
============
I have in the formula
if instr({title}),"Beginning / Intermediate") = 1
then
ltrim( mid({title},25,len({title})-24) & ": " & "Beginning / Intermediate")
==============
It is changing the title to "/ Intermediate Jazz: Beginning" so I'm thinking the forward slash is causing the problem.
Help is appreciated.