Formula Help - Coda equivalent to ARRAYFORMULA(JOIN("",LEFT

Was asked this on a personal thread. Sharing here as I am sure others have similar asks -

“I’m trying to figure out what the equivalent to ARRAYFORMULA(JOIN(”",LEFT(SPLIT(B3," "),2))) would be in coda. I am looking to reduce a verbose campaign name to a shortened string made up of the first x characters of each word of the campaign name. i.e. “Spring Northstar Campaign” > “SpNoCa”

My way -
FormulaMap(Split(“Spring Northstar Campaign”," " ),Left(CurrentValue,2 ) ).Join("")

Join("",FormulaMap(Split([“Spring Northstar Campaign”," " ),Left(CurrentValue,2 ) ))

1 Like