I have a table for physical addresses and a formula field to convert linked records to an array. Below is an example of the array.
“Main Residence: 123 Main, New York, NY 10001”, “Office: 789 Left Ave, 3b, New York, NY 10001”, “Vacation: 456 Right St...
See the attached screenshot for an idea of what I’m trying to accomplish. I’m using a formula to concatenate the names of sellers and buyers. Simple except that if there are two or more names, how can I remove the identical last name, or add an & bet...
I could use some assistance with extracting a word from a string.
Here is an example of the string.
200 East Broadway #Z001 (Jacob to Seymore)
This is the formula that almost has what I need but missing something.
MID({Transaction Name},
SEARCH("#",{...
Thank you both for your input. I struggled with trying to explain this so I created a new base and built an example to share. While doing this, I found where I was stumbling. Long story short, I did not have all the ingredients that I needed.
I posted the question too soon as I now have a working formula.
TRIM(MID(SUBSTITUTE({Transaction Name}," “,REPT(” “,99)),MAX(1,FIND(”#",SUBSTITUTE({Transaction Name}," “,REPT(” ",99)))-50),99))
