NthLine(Address,1)
for a field that when copied and pasted here displays as:
424 W Malvern Ave
Fullerton CA 92832
is displaying both lines of text. What is the trick to make this work. In Word, displaying the text does show a ¶ after each line.
Using
NthLine(Address,2)
displays nothing.
gary
March 8, 2021, 8:00pm
2
It seems your address has line feeds instead of carriage returns. You can use:
nthline(lftocr(Address),2)
I would imagine the nthline(
function should actually work with either line feeds or carriage returns.
KJM
March 8, 2021, 8:14pm
3
Gary has provided an excellent tool in the Database Exchange: “Reveal Invisible Text.pandb” than displays which invisible characters are contained in your text field.
Dang. I thought Word would be honest with me. When I used reveal hidden characters, this is what it showed me.
Guess those paragraphs symbols don’t mean the same thing everything where. A note to others then.
Thanks Gary