I have several expressions, two which get a Substring of a string and three which concatenate strings using Trim(str) to ensure there are no spaces in the results. My issue is that one of the Substring calls and two of the Trim calls are producing errors, where the others are not.
The Substring takes in a string similar to "ZIP 44434", "ZIP 44434-3344", "ZIP". There are two fields with the same data format which I need to strip the "ZIP " from. I am using Substring(ZIP_FIELD,4) to start at character 4 and give me just the zip code. One expression works, the other gives the Invalid arguments error.
In the Trim expressions, I am taking AREA_CODE and PHONE_NUMBER to push them together into one field using Trim(AREA_CODE) + Trim(PHONE_NUMBER). In one of the expressions this works, in two others I am getting the Invalid argument errors.
Any thoughts on why this is happening, and how to get it to work is greatly appreciated.
