Solution to get data for listview that contain comma

[Asri_Rusdi]

My colleague create application (web application) for PC that access MySQL database.
The application display temperature of each incubator plus also display notes about the baby including mother name of baby, baby height, baby weight, baby birthday and baby gender.

I create mobile app by MIT app Inventor to access data in the MySQL database to display temperature of each incubator plus notes of baby in Listview, but I got issue when data for notes of baby is input with comma then I got extra new record which I expected data with comma could be accepted as a single record.
So I need advice how to solve this issue.

To more understand about this issue I will give simulation of the issue with small app as follow:
This is table test that have fields: field1 and field2.

This is the php script to send data to web component for the app inventor app.

This is the issue to display data correctly in Listview.

This is the block of code for the app.

How to resolve this issue so my app could display any data including data with comma.
As information I created app as the following display as your reference.

Thanks
Asri

[ABG]

Instead of setting ElementsFromString, set Elements to Split responseContent at \n

That will ignore the commas

[Asri_Rusdi]

Is this the block of code as the changes that you expected?

But still not work.

Please help.
I attach the aia file of the app as your reference.
test01.aia (2.5 KB)

Thanks
Asri

[ABG]

I said Elements

[Asri_Rusdi]

Thanks.
Already work after change from ElementString to Element.
And also change php script from :
print "field1 : " . "$field1" . "\n";
print "field2 : " . "$field2" . ",";

To be
print "field1 : " . "$field1" . "\n";
print "field2 : " . "$field2" . "\n";
print "\n";

The result to be :

Is the fixing of app already correct?
Just make sure.

[ABG]

(draggable)

[Asri_Rusdi]

Thank you very much for your help and support.

[Asri_Rusdi]

I am sorry I change the app to be able to display 1 record in database table as 1 element.
But there is issue on the last record that display blank row as the following screenshot.

The php script I change as the following:

And the block of code I change as the following:

I attach aia file of app as reference.
test01 (1).aia (2.4 KB)

Please help how to remove the blank row on the second element.

Thanks
Asri

[ABG]

Remove the last \n character of the response content before splitting it.

[Asri_Rusdi]

Thanks.
I will try it.