Verified Answers

If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it!  Learn more

  • State Suggested Answer
  • Replies reply
    1
  • Answers answer
    1
  • Subscribers subscribers
    19
  • Views views
    155
  • Users 0 members are here
Related
Options

Extract multiple values from a comma delimited string field

Phil Sayle

We have a customer on SMAX 24.2 that is trying to extract multiple values from a comma delimited string field.

Each of the values extracted then needs to be processed separately.

For example this may look like 'AA001, AB002, AC003, AD004, AE005' but no specific limit on the number of values.

These would then be processed as AA001 then AB002 then AC003 etc.

Suggestions so far have been to try the Split, substring and indexof functions in the expression language but nothing has yet given the result required.

An Array and loop would be really handy at this point.

Does anybody have any suggestions on how to extract the values?

  • Suggested Answer

    0  

    Hi Phil,

    I think the best way to achieve what you are trying to do is use the Integration Engine. This then allows you to create an Array as well as split the text to create the individual elements that will make up the array.

    As an example I added a string to the change Record as shown here:

     

    Now using the Integration Engine I can extract that field from the record:

    Then split the string to add to an array:

    Then for each item in the array create a new request:

    In this scenario it produces 5 new requests:

    Hope that helps.

    Thanks

    Dave

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.