cancel
Showing results for 
Search instead for 
Did you mean: 

How to create a TAB Delimited file with blank columns

Former Member
0 Kudos

Hi,

In my requirement i want to generate a tab delimated file. So i used FCC in Reciever CC and am able to create a tab delimated file. But the file content is not in the format i am expecting. File created as shown below.

Eid First Name Middle Name Last name

7 raj reddy petter

8 ram johnson

Here 'Johnson' is last name of 'ram', But it displayed under the 'Middle name' column, as the employee does not have the middle name.

But i want file in the format shown below.

Eid First Name Middle Name Last name

7 raj reddy petter

8 ram johnson

Please suggest me what i need to do to generate the file in the required format.

Thanks in Advance..

Regards

Sreeni

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

You have to use 1..1 cardinality while creating your target data type and see to that in the mapping if the source side element is not present, even then you should create the target element. use Mapwithdefault for this function.

As long as your target message has the empty element, the file will generate properly.

Answers (1)

Answers (1)

SudhirT
Active Contributor
0 Kudos

Hi,

You can handle this in mapping. just pur a condition for all the fields(middle name, last name) if missing like

field---
          equalS-----If then----Constant(Space)-----Target field ---else----Field-----Target Field.
Constant(blank)

Thanks!