1 Reply Latest reply on Mar 4, 2009 8:07 AM by deltatango

    Filemaker Pro 9 and Cubecart3 / mysql field issue

    agharvey

      Title

      Filemaker Pro 9 and Cubecart3 / mysql field issue

      Post

      Hi,

       

      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.

       

      Thank you 

        • 1. Re: Filemaker Pro 9 and Cubecart3 / mysql field issue
          deltatango
            

          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.