Does anyone know if it is possible to modify a text string (configuration specific custom property) using an equation? I would like to trim a description. I know that I can do it using a design table and Excel but I am trying to avoid having to add in the design table. Any ideas?
Thanks for the quick response. I tried running through the example and I couldn't figure it out. I'm not a VB guy so this is all new to me. Here is what I would like to do. I have a custom property called "raw material description pn" that is being entered by the user via the Property Tab Builder. It looks up a description in an Excel spreadsheet. I would like to modify that description. Here is an example: "5000025, Steel Rounds, Ductile Cast Iron, 3.125". I would like to remove the "5000025, " from the description and save the rest as "raw material description". I would also like to save the "5000025" as "Raw Material Part Number".
In the design table I simple used a replace command: =replace(A1,9,""). Is there any way of doing that in VB?
There's probably a faster way than this, but
dim long_string as string 'this is your input
dim short_string as string 'this is your output (last 9 characters truncated)
dim long_string_len
long_string_le = len (long_string)
short_string = left(long_string, 1, long_string_len - 9)
HOwever, since you already have an excel spreadsheet as a lookup source why not add a column to it and parse the description there?