cancel
Showing results for 
Search instead for 
Did you mean: 

How to handle data with special characters in Data Source step

SOLVED
Highlighted
Contributor

How to handle data with special characters in Data Source step

Hi All,

Have a excel sheet with data where we have special chars(&,<,>..), when loading data to data source it's not loading as it is from excel, it's adding some other junk data like below.Would like to get as it is from excel.

EX1:

In Excel: Test1 & Test2

In data source: Test1 &amp; Test2( adding amp;)

EX2:

In Excel: <Positive Test>

In data source: &lt;Positive Test&gt  (loading &lt;&gt  instead of <, >)

 

Please let me know, if any one have any idea to handle this.

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Contributor

Find a solution, unchecked Entitize Data Values option in Data Source Settings Tab. It's loading data as it is from Excel. 

https://support.smartbear.com/readyapi/docs/soapui/steps/data-source.html

 

Redde_0-1596035414405.png

 

View solution in original post

2 REPLIES 2
Highlighted
Community Hero

Can you use CSV as data source instead of excel? You may want to give it a try if that helps.


Regards,
Rao.
Highlighted
Contributor

Find a solution, unchecked Entitize Data Values option in Data Source Settings Tab. It's loading data as it is from Excel. 

https://support.smartbear.com/readyapi/docs/soapui/steps/data-source.html

 

Redde_0-1596035414405.png

 

View solution in original post

New Here?
Join us and watch the welcome video:
Announcements
TechCorner Leaderboard
Want a fun and easy way to learn ReadyAPI and show off your skills? Try solving weekly TechCorner challenges and get into the Leaderboard!


Challenge Status

Get a full Raw JMS request

Participate!

Compare an expected JSON value and actual response in Events

Participate!

Fetch value/data from JSON response using Groovy Script

See replies!

Get data from Petstore and add it to Excel sheets

Participate!
Top Kudoed Authors