Posted by jim_geissman on 03/14/06 17:21

Some columns in transaction tables are "mandatory fields" on the data
entry screens, and as a result tend to accumulate junk entries, where
the user puts something, anything, in the window in order to get the
GUI to accept the screen. This filler isn't as elaborate as Lorem
Ipsum, but more likely characters from adjacent keys on the second row
of the keyboard, like "lkjkljl". This non-data gets in the way of
applications that use the data. I wonder if there is a way to
recognize and ignore this stuff -- I would assume it's a well-known
problem, but I haven't found any literature on it. Any pointers
welcome. And sorry if this is off-topic for a DB group.

Thanks,
Jim Geissman

[Back to original message]