Hi Community,
I had another issue earlier and was advised to use REGEX, and honestly I'm only very, very basic on this,
I've looked at some YouTube videos to try to learn, and I've found a funny issue, I'm using data I get form people via email, where in excel I'd use a text to columns etc.
Picture below is me trying to use Regex to parse out the data, but when one Item is longer than our usual 8 digits, it's jumping over to the Sales Order Number
We have Item Number's ranging from 3 to 15 characters (Alpha/ Numeric now a days) just to make life more difficult .
Anyway in this example more are 8 digits, but 1 is 11 characters (Alpha/ Numeric) so I'd like to understand how to build the Regex logic using this sample data, to parse all the lines correctly.
Sample Workflow You can see my bad attempt at Regex, and the sample data in a Notepad format.
I'd like in the end to see the Item Number, the Sales Order No, the current Qty, and the new (Reduced Qty) so I can learn
TIA
Karl.
