Does Aperture have the "treat leading zeros as alphanumeric" option that Pandora had
One a a global setting that instructed Pandora to treat any input field with leading zeros as alphanumeric so that the leading zeros were preserved. While I can see that one can set a field which has can have leading zeros as alphanumeric, this seems to require an analysis of the data to know that it has leading zeros - one knows about bank sort codes, bank account numbers, telephone numbers but there are often others lurking and an the global function was most useful.
Best Answer
-
There is no global setting for treating any column of data with a leading 0 as alphanumeric, you can set a file loaded to treat every column as alphanumeric on load. This avoids losing leading zeros if they're significant.
You will have to convert dates to a date type before using and date comparison functions however. This can be done within a transformation if required.
0
Answers
-
Thanks, it was as I expected. A pity, that was a useful feature in Pandora!
0