tab delimition for the blank values

[Former Member]

Hi experts,

I need to generate the tab delimited file.

I m using FCC for the same.

if there are 3 fields in my structure and values are coming for all, then its working fine, but if any of the blank value is coming as blank, the its giving prb.

I am facing the below problem.

if Input is - Jack Michael Richard

output file is generated prorperly

if input is- Jack Richard

then output is coming as - Jack Richard

But I want result as - Jack Richard

Please advise.

Thanks in advance.

[Former Member]

Thanks Supriya.

I checked with Excel sheet and can see the tabs over there. in wordpad or notepad the file will never be seen in proper format because of the varying length of the input field values.

[Former Member]

Hi,

Try this mapping:

InputField----

---

>

InputField --->

equalS -

---

>ifThenElse

Constant[] ---> Constant(with blank -

---

>

spaces equal to length)

-Supriya.

[Former Member]

Hi Mohan,

ok,,
so if the field value length is 4 , the I need to give space of length 4 character ..rt ...pls advise.

Yes, you are correct.

-Supriya.

[Former Member]

Hi,

Its nt working

[Former Member]

Hi Mohan,

I think you can control this in mapping.

In mapping, use function mapWithDefault, the default value should be the length of that field.

-Supriya.

[Former Member]

ok,,

so if the field value is 4 , the I need to give space of length 4 character ..rt ...pls advise.

thanks.

[Former Member]

ok,,

so if the field value length is 4 , the I need to give space of length 4 character ..rt ...pls advise.

thanks.

[Former Member]

Hi Mohan,

if input is- Jack Richard
then output is coming as - Jack Richard 
But I want result as - Jack Richard

Didn't get your requirement, can you be please be more clear with the output needed.

-Supriya.

Edited by: Supriya Sawant on Aug 24, 2010 12:21 PM

[Former Member]

I suggest you to check your message mapping ....

On test tab of message mapping ...

try executing it with all valid values and with only 2 input values ...then on target side , please check , wheather the genrated xml output is ok or not ......

if it is not ...first it shoulb be OK then u will only get the desired result in flat file .............

[Former Member]

Hi Supriya,

Thanks for the reply

I want Richard value at the last postion as of now its coming on 2nd position because the 2nd value is coming as blank.

Thanks.