Hi Joseph,
I am a little confused about what you are trying to achieve here, however, I don’t think that the standard multivalue functions are going to give the desired result as they all preserve the multivalue structure whereas you appear to want to omit completely the blank items.
You may need to walk through the dynamic array using the REMOVE operation and copy only the desired items to an output string. A useful thing to know about REMOVE is that you can determine whether the item returned is a field, value or subvalue by looking at the delimiters either side of it. The item type corresponds to the lower of the two delimiters.
Martin
From: ope...@googlegroups.com <ope...@googlegroups.com>
On Behalf Of josephv...@gmail.com
Sent: 07 April 2022 14:07
To: OpenQM <ope...@googlegroups.com>
Subject: Help creating subroutine
EXTERNAL EMAIL |
--
You received this message because you are subscribed to the Google Groups "OpenQM" group.
To unsubscribe from this group and stop receiving emails from it, send an email to
openqm+un...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/openqm/eeb79dc8-457d-43ad-bd41-46859552f83bn%40googlegroups.com.
================================
Rocket Software, Inc. and subsidiaries ■ 77 Fourth Avenue, Waltham MA 02451 ■ Main Office Toll Free Number: +1 855.577.4323
Contact Customer Support: https://my.rocketsoftware.com/RocketCommunity/RCEmailSupport
Unsubscribe from Marketing Messages/Manage Your Subscription Preferences - http://www.rocketsoftware.com/manage-your-email-preferences
Privacy Policy - http://www.rocketsoftware.com/company/legal/privacy-policy
================================
This communication and any attachments may contain confidential information of Rocket Software, Inc. All unauthorized use, disclosure or distribution is prohibited. If you are not the intended recipient, please notify Rocket Software immediately and destroy
all copies of this communication. Thank you.