Removing blank rows in File Content Conversion

[Former Member]

The following is the snippet of XML in a file produced by the File Receiver Adapter using FCC. The mapping is fairly complex and results in blanks rows being outputed. I need to remove this but I don't want to change my mapping. I've tried using .fieldContentFormatting "trim" to no avail.

Once again, can anyone help me?

 
<Prices  COLUMNS="IndexName, Date, IndexPrice">
Price_OU_gas,2007-05-01,23
Price_OU_gas,2007-05-01,65
Price_OU_gas,2007-05-01,66


Price_OU_gas,2007-05-01,12


Price_OU_gas,2007-05-01,56
</ GasPrices>

[Former Member · Accepted solution]

Crowe,

In the mapping only specify for the root node a Boolean funciton like:

If --> Source not equals to space then (put your mapping logic) ---> createif --> Target.

---Satish

[Former Member · Accepted solution]

Satish,

Thats what I originally had. It didn't work so I tried using FCC which wouldn't work hence this posting. However, I went back to the original mapping and on the node which the main logic is based on, I right-clicked and changed the Context of the node from row to MT_mymessage type. That was the solution!!

[henrique_pinto · Accepted solution]

Seems you have a flaw in your mapping, and in the end, FCC is converting the Context Changes... By removing the context changes, you were able to get it right.

Regards,

Henrique.

[Former Member]

Does anyone know how to remove blank lines?!