leftear13

Extracting Data

Discussion created by leftear13 on Jul 19, 2017
Latest reply on Jul 19, 2017 by leftear13

Hi,

 

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.

 

Examples Below:

 

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.

 

Thanks!

Outcomes