how to validate excel csv data which coming in GET Response
I m usuing soapui 5.2.1 free version
where in my GET request i am getting excel report in csv data format
so how i will assert or validated the same.
E.g. below data is coming in respone in xml section.
<data contentType="text/csv" contentLength="318284"><![CDATA[participant_id,first_name,middle_name,last_name,date_of_birth,age,gender,address,city,state,pincode,address_l
1,xyzfirst name ,1983-08-10,34,MALE,"","","","",,,,,,,,"","","",,/data/pdfs/1216_ConsentAssent.pdf,7,f,f,,NaN,NaN,2017-08-10,1529,1216,,,,,,,,,,,12341,2017-08-08,7,V. J. Gupta hospital,1,,,1,Nagaroad€“Vadgaon,1
plz request you tell me all validations method
correct....but just get to know whatever csv data i am getting in response that data i need to validate through assertion.
your guidance is really very helpful for me
Here in the case, you need to first extract the text inside the "cdata" and use that as csv data.
Just i need validate response excel csv data through Assertions Options only
if i want to extract data then plz guide me