I am extracting data from a field for a guy who thought it was a good idea to include his Sku# into the ItemName field.
The problem is that the Sku# varies in the number of characters (4 or more) between both letters and numbers separated with a space, so they are not consistent.
AQ 12100 WINTER IN SCOTLAND
HB 101 AFRICAN TAPESTRIES: TEMBA
AWR 53621 THE CLASSICS
BEAU 16025 HEALING TOUCH
But, what is consistent is that the Sku# always ends before the second space.
Example1 - AQ (space 1) 12100 (space 2) and then the Item Name (WINTER IN SCOTLAND).
Example2 - HB (space 1) 101 (space 2) and then the Item Name AFRICAN TAPESTRIES: TEMBA
I am looking for help on writing a script where anything before the second spacer, starting from the left, is removed. Or extract all data after the second space into a new field. Either or would work, but not sure of the best way to do this, nor do I know how.
Any insight you can offer would be greatly appreciated.