DSXchange

Please verify that you are actually getting the desired result out of the source before jumping to the statement " It does'nt work".

DSguru2B wrote:Please verify that you are actually getting the desired result out of the source before jumping to the statement " It does'nt work".

I actually can NOT get the desired result, otherwise, I won't seek for assistance here.

No, I meant before feeding into the filter stage, make sure the data has '0X0' in it.

As mentioned, pls mention what are you looking for? Iam sure the output of filter will have data like "dd" for Char10. And the rest of the 8 char will be filled with Null char. You cannot eliminate it if you want to maintain as Char. And What is the issue if it got in that data? Were you facing any issue during loading into any tables?

kumar_s wrote:As mentioned, pls mention what are you looking for? Iam sure the output of filter will have data like "dd" for Char10. And the rest of the 8 char will be filled with Null char. You cannot eliminate it ...

DSguru2B,
I have check the output before "filter", it actually contain "0x0" (I use Transformer with Index function to test it).

kumar_s,
Yes, the rest of the char will be filled with Null char. So it can not be selected without Transformer stage ?

I want to develop a checking script to check if Null char has been padded to the char fields. (because our project not allow the PADString to be set to space and some developer is new to this tools. They are sometimes careless, so the Null char will be padded). And I want to generate a generic OSH script to check all the char fields, so it is better if filter stage (Transformer need to be compiled) can achieve the requirement.

Set APT_STRING_PADCHAR to space in /etc/profile. Then it will be set for everyone, and can only revert to 0x00 through deliberate intervention.