Resurrecting a past topic, it seems that there are constant issues around line breaks. There are numerous avenues that create unwanted variants.
Typing into a cell and using the return key applies line feeds.
13733•LF•12171•LF•19214•LF•20807
When the cell is closed it looks like this:
Copy and paste the record and that same text gets converted to vertical tabs.
13733•VTAB•12171•VTAB•19214•VTAB•20807
When the cell is closed it looks like this:
In a procedure, produce the same list using cr() and it creates this
13733•CR•12171•CR•19214•CR•20807
When the cell is closed now, it again looks like this:
Obviously this becomes problematic when trying to process the cell’s contents for an array or anything else that employs the separator.
Yes, we have ways to handle the variations with the likes of lftocr( and crtolf(. And I can understand why copy record would need to eliminate the line breaks. But as often as I find myself trying to resolve issues when one or another appears unexpectedly, it feels like there should be a better way to force them into some consistency.
Just sayin’…