Q. I have used the Excel functions LEFT, MID, and RIGHT to dissect cells. However, I have some spreadsheets where each piece of information is a different length and uses different delimiters. Is ...
@%1-3 are variables that's replaced by our system. So far so good. Here's the tricky part. A new requirement is to send a part of the JobNo (@%2), to another field as well, that we might call LineNo.
Results that may be inaccessible to you are currently showing.
Hide inaccessible results