Excel DataSource fails when empty cells are transformed as Blank Values

Hi,

My Excel dataSource contains empty cells for the listed optional columns below:

DatePurchased
NewBuild
AddressChanged
ResidencyType
ConstructionStartDate
ConstructionEndDate

The SOAP request message fails schema validation during execution as the request message reads each empty cell as Nill.


           
               
                     
               
           
           
           
           
           
           


I've followed the advice provided on: http://www.eviware.com/blogs/oleblog/?p=768

and created an Event handler for : RequestFilter.filterRequest with the
script set to:

context.requestContent = context.requestContent.replaceAll( "","" )
context.requestContent = context.requestContent.replaceAll( "","" )
context.requestContent = context.requestContent.replaceAll( "","" )
context.requestContent = context.requestContent.replaceAll( "","")
context.requestContent = context.requestContent.replaceAll( "","")
context.requestContent = context.requestContent.replaceAll("","")

This failed to replace the elements specified.

I've executed the same test manually and this passed schema validation with the request message formatted as the optional elements are stripped off during
formatting



Can you help ?