how to validate excel csv data which coming in GET Response

[dev16]

Hi 

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
]]></data>

plz request you tell me all validations method

Regards

Dev

[nmrao]

What do you mean by " all validations method"?

[dev16]

all validations means ..based on response csv data need to add assertions

Thanks

Dev

[nmrao]

How would someone else know what assertion to be made, it is you to tell what to assert.

[dev16]

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

Thanks

Dev

[nmrao]

I feel that the question lacks the clarity. Tell how you need help?

Here in the case, you need to first extract the text inside the "cdata" and use that as csv data.

[dev16]

Thanks okay.

Just i need validate response excel csv data through Assertions Options only

if i want to extract data then plz guide me 

Best regards,

Dev

[nmrao]

You can use below sample to extract data.

https://ideone.com/W3VR6A