automatic scan a table, report on data formats in columns

automatically scan a table of all text columns

produce a report on data formats in columns as indicated in the following:

Column A                               Column B                   Column C 

alphabetic words/phrases     digits like xxxxx.xx      alphanumeric identifiers

City of London                       5 digits followed by a    iso12345

                                               decimal point and 2

                                               digits indicating precision

It is a bit like detecting regular expression patterns automatically.

Is automatically detecting something like regular expression patterns possible?

Regards,

David