Looks like LefWords (theAboveFieldHere ; 2 )
This calculation will pull the pieces apart into SKU and the Item Name.
The part before the second space will be treated as the SKU.
The part after the second space will be the item name.
theString = YourField; // Edit this to use your field name, e.g. the original ItemName field.
posn2ndSpace = Position(theString; " "; 1; 2); // Locate the second occurrence of space.
theSKU = Left(theString; posn2ndSpace - 1);
theItemName = Right(theString; Length(theString) - posn2ndSpace)
theSKU & "|" & theItemName
I made the calculation return both values separated by a vertical line. Edit to return one or the other as needed.
AQ 12100 WINTER IN SCOTLAND --> AQ 12100|WINTER IN SCOTLAND
HB 101 AFRICAN TAPESTRIES: TEMBA --> HB 101|AFRICAN TAPESTRIES: TEMBA
H-B 102 EASY CHAIR --> H-B 102|EASY CHAIR
That displays the first 2 words only. I want to remove the first two words and display anything after starting with the third word.
1 of 1 people found this helpful
MiddleWords(theAboveFieldHere; 3, WordCount(theAboveFieldHere))
Will skip over the first two words and return everything after that starting with the 3rd word.
Thanks all for the help!