This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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
Go to Solution.
Go to Solution.
You have your parse hardcoded for 8 digits - you can change it to any number of word characters (alphanumeric) which come before a space by starting it with:
That should extract the Sales Order Number...
Would Getword([field1],6) suffice?
In you're case you have to find the correct pattern to split the field:
Hope this helps,
Attached the workflow,
That works except for Item Number 24073256UCV it's dropping the (UCV) part of the item number.
What would you do in these situations
In this case you add an Or (|) condition
Thanks Messi007, that's amazing man...
Love to know how to do this
but I'II keep trying,
also thanks to everyone else you gave solutions.
Happy to help man 🙂 & happy analyzing.