Table relations

[Bryce Lee]

I am trying to set up a BOM table but our PDM system adds 9 under scores and a 6 digit number after our part number. I am trying to write a relation to only include the part numbers before the under scores.


Example: 174490_________535303.prt (need to only keep 174490)


Any ideas!!


Thanks!!


Lee

 

[wsylvester]

this may fill your needs





[url]http://www.mcadcentral.com/proe/forum/forum_posts.asp?TID=31 394&PN=3[/url]

 

[Bryce Lee]

Thanks!! Do you know the wild card fornumber.





Example: 174490_________535303.prt


in relations would be


??????_________??????





Thanks,





Lee

 

[wsylvester]

not sure there is a wildcard, but you can use







search(string, substring)

Searches for substrings. The resulting value is the position of the substring in the string (0 if not found).



extract(string, position, length)

Extracts pieces of strings.search for underscore, get that value then extract