Hi all,
I want to replace not equal to "0" to "1" and if any value missing replace to "0"
Original
Attribute1Attribute2Attribute3Attribute4Attribute5Attribute6Attribute7Attribute8231212301235650231230231000031240000370232102312234340000320001220023232123120127700
Expected result
Attribute1Attribute2Attribute3Attribute4Attribute5Attribute6Attribute7Attribute8110110010100001000011010111000010001001110110000
Please advise
Best answer by takashi
View original