Getting Extra Line Feed in generated Files

[Former Member]

Hi Experts,

I have been used Variable substitution for file name.In actual output content of the file does not have the field value which i required as a file name.For this i have added a node & field as "FileName" in my Data Type and did the mapping.I am getting value successfully.Actually this field is not require in output of the file.To suppress this field i have done in file content conversion like below.

FileName.fieldNames:FileName

File.fieldFixedLengths:0

StoreNum.fixedLengthTooShortHandling:Cut

Its generating the file succeesfully.However i am getting an empty line before my actual fields data.Now how to avoid that empty line.

Any ideas on this.

Needful answers will be awarded.

Cheers

Tiger Woods

[Former Member · Accepted solution]

Hi, Tiger,

I did the same thing, but my case is OK.

Have you put the file name as teh last field in your data type?

--Wenning

[Former Member]

Hi..,

Thanx for your time guys..,

I have done the same change as suggested, that one is working..,

Cheers

TigerWoods

[Former Member]

Hi Wenning

I put the FileName field as first field in DataType.I have tried by putting that as Last field but it was given error like "Variable subtitution value "FileName" not found".

Could you give that payload refrence how to place the value from last field.

In my case Variable substitution like ..

payload:MT_Sample,1,<b>FileName</b>,1,<i>FileName</i>,1

FileName in BOLD is Node,FileName in ITALIC is field under that node.

Cheers

Tiger Woods

[prabhu_s2]

have file name as the last field in the strucutre and check it out. this change shud work

[Former Member]

payload:MT_Sample,1,FileName,1,FileName,1

FileName in BOLD is Node,FileName in ITALIC is field under that node.

--I do exactly the same thing. Please check out the palyload in XI monitor see if tha field name actually exist.

Wenning