Concatenate Set Number of Characters

Question

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 1Field 2Concatenate OutcomeNewYorkCityLimeNewYorkLimeWashingtonCommercialLLCWashingLLCOhioCompanyLLPOhioCompany

AbhilashR · Accepted Answer

@mustufa2019 - yes, you could certainly use a formula tool.

Your formula would go something like:

Left([Field 1], 7) + Left([Field 2],7)