Avatar

Employee Advisor

Which schema does the memo belong to? can you share screenshots, you can get an idea of the memo xml structure by using the expression toString(memo) in the output column and share it here.

 

for example in javascript, given the following xml structured field, the substring will return the value between the indices 23 and 29 (example in https://jsfiddle.net/02tvr7e5/)

 

The substring() method extracts characters, between to indices (positions), from a string, and returns the substring.

 

xml = '<?xml version="1.0"?> <people>   <person first-name="eric" middle-initial="H" last-name="jung">     <address street="321 south st" city="denver" state="co" country="usa"/>     <address street="123 main st" city="arlington" state="ma" country="usa"/>   </person>    <person first-name="jed" last-name="brown">     <address street="321 north st" city="atlanta" state="ga" country="usa"/>     <address street="123 west st" city="seattle" state="wa" country="usa"/>     <address street="321 south avenue" city="denver" state="co" country="usa"/>   </person> </people>';

alert(xml.substring(23,29));

value returned = people

 

In adobe campaign the function is Substring(memo,0,255) you can find more information on this thread https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/substring-function/m-p/2598...