x12 substring manipulation
How do I manipulate a string in Ensemble DTL (X12 document) to extract a string starting from the right, or end, of the string?
I need to have 10 digit phone numbers, however some of the source data records include the "1" for the long distance dialing and I need to exclude this.
I have tried using Right(), SubStr(), and even SubString(string,*,-10) but it will not compile.
I find it hard to believe that Ensemble does not have the ability to read a string from the right.
Thank you for any assistance.