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

Extract parts of material name and populate iProperties

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?