Select the record with 0x0 inside the field by using Filter
Moderators: chulett, rschirm, roy
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?
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
DSguru2B,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 ...
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: