Semi Colon issue when using summary fields then Part function
I have run into this a couple times, and don't have a good solution, perhaps someone else does.
I have many scenarios where I have a combined text field, and then look at each Part individually for different reasons. However, if one of the fields combined includes a semi-colon, this will of course 'trick' the system when looking at each part.
All I could come up with is searchandreplace the semicolons prior to combing text. Anyone have a better solution that allows me to leave the semi-colons undisturbed?
------------------------------
Mike Tamoush
------------------------------
I have many scenarios where I have a combined text field, and then look at each Part individually for different reasons. However, if one of the fields combined includes a semi-colon, this will of course 'trick' the system when looking at each part.
All I could come up with is searchandreplace the semicolons prior to combing text. Anyone have a better solution that allows me to leave the semi-colons undisturbed?
------------------------------
Mike Tamoush
------------------------------
