Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.
dean.morrison
in reply to: Anonymous

Hi,

 

You could use split to do it, but the number of parts must be the same - in your case below it would be 5.

 

If you can count the number of spaces, i'm sure you could modify it so it works if the number is different.

 

Anyway it goes like this..

 

MatSplit = Split(MaterialName, " ")
For i = 0 To UBound(MatSplit)
Part1 = MatSplit(0)
Part2 = MatSplit(1)

Part3 = MatSplit(2)

Part4 = MatSplit(3)

Part5 = MatSplit(4)
Next

 

I hope that helps you.

 

Dean.