AutoTrim for Input/Output objects

ArndW · Post by **ArndW** » Tue Jun 21, 2005 3:12 am

I would like to see a built-in switch, either at a stage level or even at a column level, that would perform a TRIM() of all leading and trailing spaces plus 0x000 characters for VarChar columns in both Server and Px plus the same for CHAR columns in Server. I invariably end up doing this when my data sources are dubious and having an (efficient) automated way to do this would be a great help.

ray.wurlod · Post by **ray.wurlod** » Tue Jun 21, 2005 4:39 pm

Presumably by "spaces" you mean "white space" (which includes tab characters) for non-NLS or characters designated as TRIMMABLE in the CTYPE locale category where NLS is enabled?

ArndW · Post by **ArndW** » Wed Jun 22, 2005 12:09 am

Ray - Yes, I do

I can't think of a non-trivial job in either Server or Px where I didn't at least once have to do some sort of a TRIM - even if it was just a prophylactic measure.