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

Re: How to handle data with special characters in Data Source step

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

Re: How to handle data with special characters in Data Source step

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

Re: How to handle data with special characters in Data Source step

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
Compete with community members in the TechCorner Challenge and get into the Leaderboard!

Rank Participant Points Earned
1 msiadak 12
2 nmrao 8
3 HimanshuTayal 3
Top Kudoed Authors