All zeros

Nagac · Post by **Nagac** » Sat Apr 30, 2011 6:07 pm

Hi

Can we find whether the field is having all zeros/spaces?. I need to write default value if the field is with zeros/spaces.

ray.wurlod · Post by **ray.wurlod** » Sat Apr 30, 2011 11:11 pm

Code: Select all

InLink.TheString = Convert("0", "", InLink.TheString)

zulfi123786 · Post by **zulfi123786** » Sun May 01, 2011 3:40 am

If Len(Convert(" ","",(Convert("0", "", InLink.TheString))))=0 then <default> else InLink.TheString

Same thing as mentioned by Ray with little more garnishing

Recheck to make sure the '+' ve sign is not prefixed for positive numbers, which usually is not the case.

Nagac · Post by **Nagac** » Sun May 01, 2011 4:04 am

Thanks Ray & zulfi. I will check this

ray.wurlod · Post by **ray.wurlod** » Sun May 01, 2011 1:04 pm

A signed zero is a very unusual thing.

FranklinE · Post by **FranklinE** » Mon May 02, 2011 8:06 am

ray.wurlod wrote:A signed zero is a very unusual thing.

EBCDIC '0C' is packed decimal +0, a rather common thing in many mainframe data repositories. Data attributes that include an explicit sign often require +0 as the default value. This is true in Cobol standards (when they are followed).

Of course, unsigned zeroes are often just undiscovered. The NBA is always looking for them. ("0" or "00" being a common number for centers.)