Taleo extract process add blank field in output CSV file

Question

I am using Taleo Connect Client to export data from Taleo. I encountered two questions:

1. How can I add blank columns to an output CSV file?

   For example, try to add ColumnBlank1 between Column_FirstName and Column_LastName.

   Column_FirstName|ColumnBlank1|Column_LastName
   John||Lee
   Adam||Jackson
   

2. How can I set default value like "N" for one field?

Answer 1

DBaluke Huang's answer was correct, but he left out some details. Adding the full solution for others who might need this too.

To export a blank or fixed string value in a column using TCC (Taleo Connect client) do the following:

1. Open your Export
2. Click the projections tab
3. Click the add button
4. Click Projection Function
5. Choose the Replace Function
6. Click ok

7. In the First Parameter Section: In the Value box, add any string field from your list on the entity tab. The Data Type should be Field.

8. In the Second Parameter Section, In the Value box, add the same field from Parameter 1 value box. The Data Type should be Field.

9. In the Third Parameter section, In the value box, enter no value for blank or enter the fixed string you want in all records.

10. Then change the data type to string in this section.

For those unfamiliar with the replace function you are looking for the string Parameter1.Value in Parameter2.value and then replacing all instances where the string is found with parameter3.value