7 Replies Latest reply on Oct 29, 2013 6:14 AM by BruceHerbach

    Bug in Substitute?


      I'm building a list of values that has multiple items per line. When the second item in the list is a long string the substitute function used to put the line items into a list I can use to set fields with seems to stop or fail. So I only end up with the first two values. Is this a bug? Has anyone else seen this?


      The formula to build the list looks like this.




      ProductList::Item & "|*|" &

      ProductList::Descriptions & "|*|"

      ProductList::UnitCost & "|*|" &

      ProductList::Formula & "|*|" &

      ProductList::SELECT_AREA & "|*|" &

      ProductList::SortOrderLine &"|*|" &

      ProductList::ID & "|*|" &



      To extract the data I use:

      Substitute( GetValue($IDlist; $lpos ); "|*|" ; ¶ )


      For the set field script steps, I use GetValue().



      It is the Description value that is long and seems to be causing the issue. If I change the order and put the Description value last, I get all of the items. So I have a work around.