We cant say exactly which function can work to achieve this. we can use below.
compact white space strip white space trim convert
if above won't work then we have to write a spacerim c++ code to remove the spaces. This kind of requirement when you get the data from data base and data type is CHAR.
You DataStage convert function to remove space from string. This way white space can be trimmed.
ReplyDeleteWe cant say exactly which function can work to achieve this.
ReplyDeletewe can use below.
compact white space
strip white space
trim
convert
if above won't work then we have to write a spacerim c++ code to remove the spaces. This kind of requirement when you get the data from data base and data type is CHAR.