Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.

Extract parts of material name and populate iProperties

Anonymous

Extract parts of material name and populate iProperties

Anonymous
Not applicable

Hello

 

4718800 GLV ZAM 1.6mm(16Ga)PLT   11H8376M5PZ

 

This is what my material name looks like, I want to extract the first "4718800" and the last "11H8376M5PZ"

I want to know how to write my code so that it reads the name from the left and right up until there is a space. "4718800" should then be populated in the iProperties under "Custom" tab and "AREA". and the "11H8376M5PZ" to be populated under the iProperties "Project" , "Stock Number"

 

I can do a code that counts a number of spaces and the uses that but, I would like it to read just till space and the use that as not all of the names are the same lengths.

 

Can anyone help me, please?

0 Likes
Reply
Accepted solutions (1)
391 Views
1 Reply
Reply (1)

dean.morrison
Advocate
Advocate
Accepted solution

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.

 

 

0 Likes