Viking Coders Miva Merchant Module Support and FAQ - Is there any way to remove characters like hard-returns and quotation marks from the exported data?

Miva Merchant 4 Module FAQs » Generic Order Export (BROK_GENEXPORT)

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

Q (2004/01/15): Is there any way to remove characters like hard-returns and quotation marks from the exported data?

A: 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.