in

InaPlex Forums

Forums and downloads for InaPlex customers and partners.

Matching against Numbers

Last post 03-19-2008 14:46 by admin. 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next
  • 03-19-2008 14:46

    • admin
    • Top 10 Contributor
    • Joined on 06-10-2007
    • Posts 63

    Matching against Numbers

    When using Standard or Fuzzy matching, Inaport will convert all target matching fields to strings BEFORE matching the incoming field against it.

    This is because Inaport needs to be able to match across many different database types, including products such as ACT! or SageCRM.com which do not support SQL.

    This can present problems when matching against numbers, because how a number is converted to a string can be dependent on locale. For example, the number 1234.567 may be "1,234.567" or "1.234,567". Starting with build 7.0.7303, Inaport standardised the way numbers are converted to strings when reading from the target database to use a CULTURE INVARIANT format.

    This means that the number 1234.567 will always be represented as "1234.567", whatever the local culture.

    To match against a number field, therefore, you need to convert your source number to a string in the same format.

    The recommended way to do this is to use the n2s() function, with the invariant culture specifier:

    n2s(#mySourceNumber, "G")

    then use this value to match against the target field.

    For more information, see the topic "Matching Numbers and Dates" in the Help.

    Filed under:
Page 1 of 1 (1 items)
InaPlex Limited 2008