in

InaPlex Forums

Forums and downloads for InaPlex customers and partners.
All Tags » RegEx (RSS)

Browse by Tags

  • Re: Parse Address Data

    Hi Richard If you are confident that the fields do not contain commans, then the following regualr expression can be used to find the Nth part: find(#myField, "[^,]+", N) Replace N with 1 or 2 or 3 etc. So in tab 3, add new fields called adrs1, adrs2 etc and initialise them with find(#myField...
    Posted to Inaport (Forum) by admin on 02-22-2012

  • Re: GoldMine History Note

    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...
    Posted to Inaport (Forum) by admin on 11-03-2009

  • Re: Removing NULLs and other illegal characters from text

    Hi Doug Thank you for the comments and the feedback - nice to get! I am sorry that I was not clear that hexadecimal and binary are equivalent. Your example is a good one. As is often the case, there are also other ways of achieving this. Using regular expressions, "\d" stands for any digit...
    Posted to Knowledge Base (Forum) by admin on 03-13-2009

  • Removing NULLs and other illegal characters from text

    A frequent problem with data migrations is text data with illegal characters in it. For example, the GoldMine notes fields sometimes contains NULL characters (binary 0), which can be problematic when inserting the data into SQL Server. Inaport and Sage Migrator provide the snip() function, which can...
    Posted to Knowledge Base (Forum) by admin on 11-08-2008
Page 1 of 1 (4 items)
InaPlex Limited 2011