I am trying to concatenate the first 7 characters of two fields (Field 1 and Field 7). Can I use formula tool for this?
Please see below for example:
Input:
Field 1 | Field 2 | Concatenate Outcome |
NewYorkCity | Lime | NewYorkLime |
WashingtonCommercial | LLC | WashingLLC |
Ohio | CompanyLLP | OhioCompany |
Solved! Go to Solution.
@mustufa2019 - yes, you could certainly use a formula tool.
Your formula would go something like:
Left([Field 1], 7) + Left([Field 2],7)
@AbhilashR thank you! this worked!