Is it possible to do the following?
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