Producer (Hardware) = Company Contoso Products-123123SPEC = BMQ3321,ASSR G4545 SPECCUST = ABP234234-43
BMQ3321,ASSR G4545 ABP234234-43
REPLACE(REPLACE(STRINGVALUE,"SPECCUST = ","",false),"SPEC = "," ",false)
Producer (Hardware) = Company Contoso Products-123123SPEC = BMQ3321,ASSR G4545 SPECCUST = ABP234234-43
BMQ3321,ASSR G4545 ABP234234-43
REPLACE(REPLACE(STRINGVALUE,"SPECCUST = ","",false),"SPEC = "," ",false)
The ER formula language doesn’t directly support complex string parsing. However, with a combination of SEARCH, RIGHT, LEFT, and REPLACE functions, you can get close to the desired output. Here’s a method to extract the values for "SPEC" and "SPECCUST" without the attributes and equal signs.
Given your input:
Find the Position of "SPEC":
Use SEARCH("SPEC = ", STRINGVALUE, 1)
to locate where "SPEC" starts.
Extract Right from "SPEC":
After finding "SPEC", use RIGHT
to extract everything after "SPEC = ".
Remove Extra Text After "SPEC" Value:
Find where "SPECCUST" starts, so you can remove any extra characters after the "SPEC" value and before "SPECCUST".
Apply Similar Steps for "SPECCUST":
Repeat steps 1–3 to get the value after "SPECCUST = ".
Concatenate and Trim:
Combine the extracted values for "SPEC" and "SPECCUST" and ensure there are no extra spaces.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,269 Super User 2024 Season 2
Martin Dráb 230,198 Most Valuable Professional
nmaenpaa 101,156