Select the record with 0x0 inside the field by using Filter
Posted: Thu Mar 15, 2007 4:03 am
I have a simple testing job as below
Row Generator --> Transformer --> Filter --> Peek
APT_STRING_PADCHAR = 0x0
Row Generator
A: String[1]
B: String[10]
Transformer
C: String[10] = A
D: String[10] = B
Filter
Peek1 <-- C like '%0x0%'
Peek2 <-- D like '%0x0%'
From above design, field C should contain '0x0' inside, however, the filter can not select them out.
Anyone know how to select the record with '0x0' inside the field by using Filter ?
Row Generator --> Transformer --> Filter --> Peek
APT_STRING_PADCHAR = 0x0
Row Generator
A: String[1]
B: String[10]
Transformer
C: String[10] = A
D: String[10] = B
Filter
Peek1 <-- C like '%0x0%'
Peek2 <-- D like '%0x0%'
From above design, field C should contain '0x0' inside, however, the filter can not select them out.
Anyone know how to select the record with '0x0' inside the field by using Filter ?