Reverse Concat?

[DaveRa4]

Hello All, Looking for some assistance to split a field. I want to take the entry from the COMPANY field (in project details), and split it into two fields, while dropping some of the text Example if COMPANY = ATL090 MVI ATLAS COPCO MEXICANA SA DE CV I want to have two Custom Fields CUSTOMER CODE = ATL090 CUSTOMER = ATLAS COPCO MEXICANA SA DE CV I want to drop the MVI portion when doing this. Is this possible, and if so can somebody provide some guidance? Dave Randall PMP Atlas Copco Tools

[Doug_Den_Hoed__AtAppStore]

Hiya Dave, The mother lode of these types of computation options is "https://support.workfront.com/hc/en-us/articles/217196767-Understanding-Calculated-Data-Expressions">here , and as often the case, there's a smorgasbord of options: LEFT and RIGHT REPLACE SUBSTR SEARCH LEN TRIM I'll leave you to puzzle out your favorite approach, but suggest that if your "ATL090 MVI" prefixes are always of that length that TRIM(LEFT(Company.Name, 6)) and TRIM(RIGHT(Compay.Name,LEN(Company.Name)-6)) might suffice. Regards, Doug Doug Den Hoed - AtAppStore Got Skills? Lend a hand! https://community.workfront.com/participate/unanswered-threads

[DaveRa4]

Thanks Doug! Dave Randall PMP Atlas Copco Tools