Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Is there any way to remove characters like hard-returns and quotation marks from the exported data?

0
Posted

Is there any way to remove characters like hard-returns and quotation marks from the exported data?

0

There is a field for each template (above the template name field near the top) labelled “Character conversion”. With this field you can have the module convert certain characters in the data before exporting it. The format to use is: from>to|from>to|etc. So to replace double quotes with single quotes you would enter: “>’| To replace double quotes with single quotes and replace all Ls with Ms you would use: “>’|L>M| Some “special” characters cannot be well represented in the form field and so special tokens exist for them: &cr; carriage return &lf; line feed &pipe; pipe characters (necessary to use the pipe becuase of the use of the pipe as a delimiter) < less than, > greater than, > To remove hard returns from the data, enter: &lf;&cr;> | This will replace the hard return with a single space. To remove a character totally (without replacing it with anything) simply enter nothing after the >: “>| will remove the double quotes entirely and replace it with nothing.

Related Questions

What is your question?

*Sadly, we had to bring back ads too. Hopefully more targeted.

Experts123