Re^3: uninitialized value in join or string

[EvanCarroll]

You could always map over the array and set the undef values to '', I would personally suggest keeping the database pristine. I would use nulls if it increases data clarity for a more ugly solution in the perl base. '' would violate a unique constraint where as multiple nulls woulden't for instance. Nulls are also open to the database implimentation, and can be optimized away very easily, an empty string however is kept as just as that, rather than a small pointer to null.

Update:
or a simple join ",", grep defined, @row;

[Win]

How could I substitute all the NULL values in an array and replace them with ' ' characters?

[Roy Johnson]

@values = map { defined $_ ? $_ : '' } @values;

Update: don't use map for transforming something into itself. If you're getting from a different source, though, this would be an appropriate technique.

[Win]

This looks great. However, I would be very pleased if somebody could describe it in English. ;>