Substituting html code for end of paragraph or carriage return character
I need to export text from FileMaker for import into a website database, and the paragraphs have to be marked with <p> and </p> tags rather than the invisible character that FM uses as its paragraph delimiter. (I believe within FM this is the CR character, decimal 13, although when you export data FM converts these to the VT character, decimal 11.) I can easily stick <p> and </p> tags on the start and finish of the whole field, but I also need to use the substitute function to replace the CR character with "</p><p>".
The question is: how do I tell the substitute function to find the CR character?
Hoping someone can help!