In Customer Shipment Entry, the ship to is a single string delimited with a tilde. I am writing a BPM to email shipment notifications and am needing to replace that tilde with a carriage return chr(10). The string looks like this…
COMPANY NAME~STREET ADDRESS~CITY STATE ZIP~COUNTRY
Any help would be greatly appreciated!
Thanks,
Chris
Exactly what I have tried:
strShipTo = replace(ttShipHead.AddrList, ‘~’, chr(10))
but validating gives me this error:
More than 32000 characters in a single statement–use -inp parm.
BTW - 9.05.702A Ran into this not working as it did in 605.
When attempting to execute the BAQ it throws ye olde: Table: , Level:, Type: , RowID: , Text: Business Query Execution error. Please contact your System Administrator.
So Replace(OrderHed.SalesRepList, '~~' , ', ')
stopped working, not sure why, maybe using the tilde as a break makes Progress think the query is being hacked or something… might be a setting or issue with OpenEdge, who knows.
What did work was using the ASCII value for the tilde, 126: Replace(OrderHed.SalesRepList, CHR(126) , ', ' )
Just in case someone is still on 9 or on their way to 10 had to upgrade to 702A.