Filemaker Pro 9 and Cubecart3 / mysql field issue
I have connected to my Mysql database via ODBC. It was created in Cubcart3 which is for my cubcart store. I can pull all the fields in fine. The issue is that the description field is coming into Filemaker with lots of Div tags etc.
In cubecart the descriptions were just placed in via the paste from Microsoft word.
How do I get Filemaker to strip out all the div's etc so the description field is readable.
Use the substitute function.
For example, if you have this text:
<div>This is some text</div>
you would use:
substititute(textfield ; '<div>' ; '')
which replaces the <div> tag with nothing, or an empty string.
You would have to do this for each tag you want to remove.
An easier solution would be to use the web viewer to show your data as HTML.