Hey all,
So, I'm trying to do something like this. I'm exporting to a CSV to do a mail merge. I want one of the fields to appear as follows:
Title
Subtitle
They are two separate fields. It is not practical to keep them as separate columns for the mail merge. However, if I have something like:
Title = "My test"
Subtitle = "My subtitle
has a line break"
I cannot figure out a way to get that to print as:
My test
My subtitle
has a line break
If I try something like "select title || '<br />' || subtitle" the html tag is ignored (no surprise) and I end up with
My testMy subtitle
has a line break
If I try something like "select title || '\r\n' || subtitle" or "select title || '
' || subtitle," the line breaks are printed as literals.
e.g.
My test\r\nMy subtitle
has a line break
Does anyone have an idea of how to do this?
Thanks,
Jonathan
Excuse the preformatting -- line breaks weren't working. >_<***