How can I query blocks of number such as in Social Security or Phone numbers? RRS feed

  • Question

  • I am trying to form a query in FAST/SP2010 without writing a powershell script to search for blocks of numbers that are typically  found in social security numbers or phone numbers or credit card number.

    e.g. if x = any number from 0-9, query "xxx" or "xx" or "xxxx".

    Furthermore, given that social security numbers have known prefixes, expand the query to search only on those prefixes.
    SSN Prefix List at:

    Tuesday, September 2, 2014 1:28 PM

All replies

  • Hello,

    One option may be to construct an FQL wildcard query, which allows one to query item on single terms, supporting ‘*’ and ‘?’ according to regular expression syntax.
    Example: *ak?sp*r* will find documents containing the word ‘Shakespeare’.

    An OR query could do this as well, though I am not sure how many blocks of numbers you plan to use in your query:

     query=OR(????, ??, ???)

    Would either of those options accomplish  your goal?


    Rob Vazzana | Sr Support Escalation Engineer | US Customer Service & Support

    Customer Service   & Support                            Microsoft| Services

    Monday, September 8, 2014 8:35 PM