inspector text 2.0

inspector text 2.0  offers you a great tool which can allow you to add powerful worksheet formula functions for working with text in worksheet cells, including search & replace, and fuzzy matching.

inspector texts search & replace functions are vastly more powerful and useful than the search & replace functions built into Excel (FIND, SEARCH, REPLACE, SUBSTITUTE, LEFT, RIGHT, & MID), yet are easy to use and do not require any special knowledge.

Major Features:

1. itSEARCH allows extremely versatile and flexible text searching:
   
   • Can use several powerful wildcards and substitutions.
   • Can search from left to right or from right to left.
   • Can be case sensitive or not.
   • Can restrict the search to text that appears before (or does not appear before) other text you specify.
   • Can offset both the position and the length of the text found by any amount.
   • Can return any of 22 kinds of information about the text found, such as position, position from right, text string found, count of all text strings found, array of all text strings found, etc.
   • Can return a friendly, custom message if no match is found, instead of returning a standard error.
2. itREPLACE allows extremely versatile and flexible text replacement:
   
   • Can use several powerful wildcards and substitutions.
   • Can search from left to right or from right to left.
   • Can be case sensitive or not.
   • Can restrict the search to text that appears before (or does not appear before) other text you specify.
   • Can replace only the first matching string found, or all matching strings found.
   • Can rearrange text, instead of (or in addition to) replacing it.
   • Can return a friendly, custom message if no match is found, instead of returning a standard error.
3. itCOUNTINCELL counts the occurrences of a given string in a worksheet cell, or within in any text string:
   
   • Allows versatile and flexible criteria.
   • Can be case sensitive or not.
4. itGETWORD finds the nth word in a string:
   
   • Allows replacing word separators (spaces and tabs by default) with a versatile and flexible search string.
   • Can search from left to right or from right to left.
   • Can be case sensitive or not.
   • Can return a friendly, custom message if nth word is not found, instead of returning a standard error.
5. itEXCLUDE excludes undesired characters and strings from text.
   
6. itEXCLUDENOTNUM excludes non-numeric and other undesired characters and/or digits from text:
   
   • Preserves only the first decimal symbol.
   • Recognizes the local decimal symbol (a period in the USA, a comma in Germany and France, etc).
   • Recognizes negative numbers in either hyphenated format or in parentheses:
   • • "-1" is recognized as "negative one".
     • "(1)" is also recognized as "negative one".
   • Detects numbers in exponential notation and preserves them.
7. itEXTRACT retrieves desired characters from text.
8. itEXTRACTNUM retrieves numeric and other desired characters from text.
   
   • Preserves only the first decimal symbol.
   • Recognizes the local decimal symbol (a period in the USA, a comma in Germany and France, etc).
   • Recognizes negative numbers in either hyphenated format or in parentheses:
   • • "-1" is recognized as "negative one".
     • "(1)" is also recognized as "negative one".
   • Detects numbers in exponential notation and preserves them.
9. itREVERSE reverses the characters in text right to left.
   
10. itFINDR is the same as Excel's built-in FIND function, but searches from right to left.
    
11. itSEARCHR is the same as Excel's built-in SEARCH function, but searches from right to left.
    
12. itREPLACER is the same as Excel's built-in REPLACE function, but counts from right to left.
    
13. itSUBSTITUTER is the same as Excel's built-in SUBSTITUTE function, but searches from right to left.
    
14. itMIDR is the same as Excel's built-in MID function, but searches from right to left.
    
15. itREGEX performs a Regular Expressions search:
    
    • Can replace text.
    • Can return any of the following:
    • The value of the first match
    • The position of the first match
    • The length of the first match
    • An array of all matched values
    • An array of all matched positions
    • An array of all matched lengths
    • A count of all matches
    • Can be case sensitive or not.
    • Can return a friendly, custom message if nth word is not found, instead of returning a standard error.
      

Enhancements: Version 2.0

• inspector text 2.0 adds two fuzzy matching functions -- the easy to use itISFUZZYMATCH and the very powerful and versatile itFUZZYCOMPARE.