David J Murray Dev
~ Learn and Do - Excel and Share ~

Quick text and-ing

Jul 21, 2006
You're Reading: Quick text and-ing

A post in Ideas & Techniques

I have a lot of multivalued fields (strange that) which contain text descriptions or logical codes which I wanted to display in a help message for users. I needed to string the text together with a ‘and’ between them.

The most logical and quickest was it to replace the @VM with ‘ and ‘:

TEXT = CHANGE(TEXT, @VM, " and ")

or in SB+ land:

TEXT = REPL(@VM, " and ", TEXT)


About the Author

<a href="https://davidjmurray.dev/losucag/davidjmurray/" target="_self">djm</a>


I have been in the computer/IT industry for over 35 years. After spending half a life-time in highly proprietary database environments, I have succumbed to the WordPress Eco-system and I'm well down the chasm. I am specializing in AWS hosting, Wordpress CMS, Elegant Themes, in particular Divi and Extra themes.


Submit a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Pin It on Pinterest

Share This