in

InaPlex Forums

Forums and downloads for InaPlex customers and partners.
InaPlex Forums » Product Forums » Inaport » GoldMine History Note

GoldMine History Note

Last post 11-03-2009 14:48 by admin. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next

  • 11-03-2009 12:15

    • Sukh
    • Top 10 Contributor
    • Joined on 11-07-2008
    • Posts 17

    GoldMine History Note

    Reply Contact

    Hi Guys

     I want to import a history note from GoldMine to my website notes field however the notes field in GoldMine is stored in HTML format as "<DIV>Withdrawal of Project</DIV></FONT></BODY></HTML>

    How can I get Inaport to only pick out "Withdrawal of Project" and strip out the HTML formatting?

    Cheers

  • 11-03-2009 14:48 In reply to

    Re: GoldMine History Note

    Reply Contact

    Hi Sukh

    There are a couple of regular expressions that can help with this.

    replace(#NOTES, "(?si).+<BODY[^>]*>(.+)</BODY>.*")  -  will extract all the text between the <BODY> and </BODY> tags, to remove all the header stuff

    Then feed the result of that into a second expression:

    snip(#NOTES, "(?i:<[a-z]+[^>]*>)|(?i:</[a-z\d]+[^>]*>)|&nbsp;")  -  will remove all the <> tag elements, and hte "&nbsp;" non-breaking space symbols.

    Should be pretty clean text after that.

    Regards

    Admin
    Filed under:
Page 1 of 1 (2 items)
InaPlex Limited 2011