Trimming empty spaces in assertions.

Question

Hello Ole,I have a assertion of type content where the expected value is specified in a database datasource filed. The problem is that the database is the return a value but has some whitespaces. For example the resonse returns 'abcd' whereas in the database it is 'abcd&nbsp;  '. How can i create an content assertion such that it will ignore the whitespaces.i guess something like ${DataSource#Name}.ignorewhitespaceTHanksALi

omatzura · Answer

Hi Ali,hmm.. can you show the entire XPath expression for the assertion?regards!/Oleeviware.com

alibaba82 · Answer

declare namespace ns1='http://services.tvguide.com/v2.5/common/types';
declare namespace ns2='http://services.tvguide.com/v2.5/listings';
//ns2:GetServicesResponse/ns2:GetServicesResult/ns2:Service/ns1:Name/text()

Expected Result
${DataSource#Name}

If I can specify in the assertion to ignore leading and trailing whitespaces or if you can tell you to do that in the SQL query which is specified in the datasource. I think both will achieve the same purpose.

Ali

omatzura · Answer

Hi Ali,I'm not sure on the SQL syntax but it should be possible, something like TRIM( columnName) in the select clause.What if you changed the assertion to be as follows:declare namespace ns1='http://services.tvguide.com/v2.5/common/types';declare namespace ns2='http://services.tvguide.com/v2.5/listings';//ns2:GetServicesResponse/ns2:GetServicesResult/ns2:Service/ns1:Name/text() = normalize-space( '${DataSource#Name}' )Expected Resulttrue?regards!/Oleeviware.com

alibaba82 · Answer

works nicely.THanks Ole

omatzura · Answer

Good!This does have some drawbacks though.. we'll add a trim option to the expected value field in a coming version..regards!/Oleeviware.com

Forum Discussion

Trimming empty spaces in assertions.

7 Replies

Related Content

How to trim white space after XMLParser

Trim the node value

assert in groovy fails because of spaces in response and no spaces in database value .Is there any s

Groovy operations trim() and replace() seems to doesn't work in Soapui

Resource Path contains spaces

Recent Discussions

Parameterising JDBC Connection Settings..Can you do it?

Test Runner - Report All in One File

GroovyScript Help - Repeating JSON Attributes Have Specific Value.....some of the time?

JDBC results are stored in the ReadyAPI project

MyFirstPlugin - button Project menu in Ready Api