Updated May 2023
Original text from ini file topic:
regex pattern applied to col titles to force the column to be treated as text (zip, part #, etc.)
Example: zip|(part *(no|num|#))|phone
matches any title containing "zip", "phone", or "part" followed by optional space and then "no","num", or "#"
Matching is case insensitive, not anchored. Use ^ and $ for start/end anchoring.
ColTitleTextRegex=zip|(part *(no|num|#))|phone|sku
----------------------------------
(recent Dev Note)
CSV2XL.SBX 2.2(305) expands the number of ColTitleTextRegex directives from 1 to 9 to make it easier to edit a long pattern list in the INI file. The maximum combined length remains 500 characters, but you can now break it up, e.g.
ColTitleTextRegex=zip|(part *(no|num|#))|phone|sku|invno|wo|code|po
ColTitleTextRegex2=acct *(no|num|#)|status|icd|
ColTitleTextRegex3=diag|m\d|diag\d
ColTitleTextRegex4=street #|house #
ColTitleTextRegex5=Dept#|^id|^prov|^loc|^pos
...
ColTitleTextRegex9=Numero|Cantidad
Note that it doesn't matter whether each line ends with a pipe (|) or not; they will be concatenated with pipe separators as required.here.
----------------------------------
(recent Dev Note)
CSV2XL.SBX 2.2(307) supports up to 4 additional format directives to associate formats with column titles. Unlike the otherwise similar ColTitleTextRegex# directives, these are each independent, associating a a pattern with a format:
ColTitleFormatRegex1=format,pattern
ColTitleFormatRegex2=format,pattern
ColTitleFormatRegex3=format,pattern
ColTitleFormatRegex4=format,pattern
As with the NumFormat directive, the format may be either a predefined NUMFMT_xxx symbol or a mask; see the //XL,SetCol directive for details. Note that unlike most other directives, these take two arguments, separated by a comma. If either the format or the pattern contains commas, you must enclose it in quotes, e.g.:
ColTitleFormatRegex1="##,###.00[red]##,###.00",Amount|Total|Price|Value
