New reply on DataCleaner's online discussion forum (https://datacleaner.org/forum):
Beverly replied to subject 'Data Types and Data Length' ------------------- So if Name, address, city, state, zip on a table all defined as VARCHAR 255 from CLOUD...I need to find out that name's max is 35, and address is 40, and city is 25, and state is 2 and zip is 9, DOB is 16. So on the output table there would be 6 rows. TABLE_NAME = PERSONAL, COLUMN_NAME = NAME, DATA_TYPE = CHAR, DATA_LENGTH is 35 TABLE_NAME = PERSONAL, COLUMN_NAME = ADDRESS, DATA_TYPE = CHAR, DATA_LENGTH is 40 TABLE_NAME = PERSONAL, COLUMN_NAME = CITY, DATA_TYPE = CHAR, DATA_LENGTH is 25 ... TABLE_NAME = PERSONAL, COLUMN_NAME = DOB, DATA_TYPE = TIMESTAMP, DATA_LENGTH IS 16 ------------------- View the topic online to reply - go to https://datacleaner.org/topic/1193/Data-Types-and-Data-Length -- You received this message because you are subscribed to the Google Groups "DataCleaner-notify" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/datacleaner-notify. For more options, visit https://groups.google.com/d/optout.
