Calculations can extract the different parts of this text as long as the text has exactly the same format each time.
For example, RightWords ( "352623_J.Doe_8.5x11_UV_5k_UPS" ; 1 ) will return "UPS" and there are also Leftwords and Middlewords functions that you can use for this to extract text between the underscore characters.
Thank you Phil, can you give me a little example and i finish it on my own? Im totally lost on this one.
Thank you in advance.
I already did:
RightWords ( "352623_J.Doe_8.5x11_UV_5k_UPS" ; 1 ) will return "UPS"
You can either define your fields as calculation fields that extract the needed text from your "folder name" field or the same script that sets the folder name field can then set individual fields for project name, quantity, shipping method, etc.
Never mind, sorry, i got it, i was overthinking this.
Thank you Phil.