Replace null values in Taleo-Connect-Client extract

Question

I am extracting some values from Taleo via TCC export script and few rows in a column are blank, I want to replace the blank values with 'NULL' written.

For example

SignonBonus

1.20000

2.

3.30000

4.250000

How is this possible ?

I have tried the below code, I am writing Bonus amount in words so have used concatenate function. but this replaceNull logic is not working, can someone suggest ?

---

<quer:projection alias="BonusinWords">
  <quer:concatenate>
    <quer:switchByCriterion>
      <quer:cases>
        <quer:case>
          <quer:replaceNull>
            <quer:field path="CurrentOffer,SignOnBonus"/>
            <quer:string>Null</quer:string>
          </quer:replaceNull>
        </quer:case>
        <quer:case>

        </quer:case>
      </quer:cases>
    </quer:switchByCriterion>
  </quer:concatenate>
</quer:projection>

Thanks alot in advance

Shivam

Answer 1

I solved it on my own

I used a notnull equation in the starting, then wrote the below logic of query.

<quer:projection alias="BonusinWords">
  <quer:switchByCriterion>
    <quer:cases>
      <quer:case>
        <quer:notEqual>
          <quer:field path="CurrentOffer,SignOnBonus"/>
          <quer:string>1000000000000000000000</quer:string>
        </quer:notEqual>
        <quer:concatenate>
         <!--Between this I wrote the logic for words!>
        </quer:concatenate>
      </quer:case>
    </quer:cases>
  </quer:switchByCriterion>
</quer:projection>

It is not exactly not null condition, but it is serving me since the bonus amount can never be this huge(or I can add more zero's in this), if you know how not null can be put in this I will try that also.

Thanks,

Shivam