Semi Colon issue when using summary fields then Part function

Question

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
------------------------------

MarkShnierYou · Answer

If this is helpful, the delimiter is actually

space semicolon space.

so if you replace " ; " with something, say a pipe |, then it is unlikely that regular text would use a semicolon that way with space semicolon space.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community