Archives: June 22, 2015

TCC – Nested Replace

Took a while to figure this out so figured I’d better put it here for safe keeping…

<quer:projection alias="SSN2" xmlns:quer="http://www.taleo.com/ws/integration/query">
	<quer:replace>
		<quer:replace>
			<quer:field path="Title"/>
			<quer:string>,</quer:string>
			<quer:string/>
		</quer:replace>
		<quer:string>|</quer:string>
		<quer:string/>
	</quer:replace>
</quer:projection>

TCC – Last 4 of National ID

Needed this for a project and seemed to work pretty well for nesting operations.

<quer:projection alias="SSN2" xmlns:quer="http://www.taleo.com/ws/integration/query">
<quer:substring>
<quer:toChar>
<quer:customFunction name="REGEXP_REPLACE">
<quer:field path="Candidate,SocialSecurityNumber"/>
<quer:string>[^[:digit:]]</quer:string>
<quer:string/>
</quer:customFunction>
</quer:toChar>
<quer:integer>6</quer:integer>
<quer:integer>4</quer:integer>
</quer:substring>
</quer:projection>