Thanks for the continued support!
Wondering if it is possible to have multiple expressions in the Multi-Field tool?
For example: I currently have the following expressions working with one expression per Multi-Field tool. (Currently making this replace in 2 address fields). Was looking to have multiple expressions in the tool.
Multi-Field Tool 1 has the following expression: Replace([_CurrentField_], 'AVENUE', 'AVE')
Multi-Field Tool 2 has the following expression Replace([_CurrentField_], 'PARKWAY', 'PKWY')
Multi-Field Tool 3 has the following expression Replace([_CurrentField_], 'STREET', 'ST')
Any help would be greatly appreciated.
Solved! Go to Solution.
@ABCDA - try this:
replace(replace(replace([_CurrentField_], "AVENUE", "AVE"), "PARKWAY", "PKWY"), "STREET", "ST")
Thanks! Worked perfectly!