Aron's Tech Blog

Sometimes you get to export a field where someone could have placed CR/LF’s, which is an enter in a text area sending carriage return line feed. This is the replace statement that will removed it and replace it with a blank:

<quer:projection alias="OfferNotes" projectedValueType="string" xmlns:quer="http://www.taleo.com/ws/integration/query">
  <quer:replace>
    <quer:replace>
      <quer:field path="CurrentOffer,Notes"/>
      <quer:customFunction name="CHR">
        <quer:integer>10</quer:integer>
      </quer:customFunction>
      <quer:string/>
    </quer:replace>
    <quer:customFunction name="CHR">
      <quer:integer>13</quer:integer>
    </quer:customFunction>
    <quer:string/>
  </quer:replace>
</quer:projection>