This is an odd (and somewhat obscure) question but I want to export a table to XML without any newlines and some of the fields have newlines to separate data (a checkbox set writes in to this field) but I want the field to be exported as one long line.

Is there a way to do this when you're exporting to xml or a way to create another field which holds a calculated value that is just the same as this other field but strung together as one long line.

you could use a substitute function and replace the ¶ with a pipe | for your export?

Substitute (field; "¶" ; "|")

I'm not exporting with a script so I don't know how I would do that but do you think if I made a new field that just contained a calculated value with that substitution that my new field would contain the correct formatting.

ie if the first field contains:

01

03

17

14

the second field would contain:

01031714