I'm exporting the content of one plugin to another much more robust plugin. In the data I export, there are fields that come with keys. There is a way to export each one independently (in a column each):
example:
Address | Latitude | Longitude | Email | ....
UPDATE
Thanks to the suggestion to use "serialized", now to export the data I am using the plugin "All Export" which allows me to embed functions for custom fields.
I have a question about what the name of the data is, in the custom field option it is _ait-dir-item, but with that name it does not work.
If I do it manually taking the data as $mydata, if it works:
function aaa() {
$mydata = 'a:52:{s:7:"address";s:59:"San José Costa Rica 100mts al Sur de Walmart en Guadalupe.";s:11:"gpsLatitude";s:9:"9.9393783";s:12:"gpsLongitude";s:18:"-84.05499370000001";s:14:"showStreetview";a:1:{s:6:"enable";s:6:"enable";}s:18:"streetViewLatitude";s:17:"9.942617316557271";s:19:"streetViewLongitude";s:18:"-84.06036884686585";s:17:"streetViewHeading";s:1:"0";s:15:"streetViewPitch";s:1:"0";s:14:"streetViewZoom";s:1:"0";s:9:"telephone";s:9:"2253-6563";s:5:"email";s:0:"";s:3:"web";s:0:"";s:11:"hoursMonday";s:15:"8:00am - 6:00pm";s:12:"hoursTuesday";s:15:"8:00am - 5:00pm";s:14:"hoursWednesday";s:7:"Cerrado";s:18:"alternativeContent";s:0:"";s:10:"socialImg1";s:0:"";s:11:"socialLink1";s:23:"http://www.facebook.com";s:10:"socialImg2";s:0:"";s:11:"socialLink2";s:22:"http://www.twitter.com";s:10:"socialImg3";s:0:"";s:11:"socialLink3";s:22:"http://plus.google.com";s:10:"socialImg4";s:0:"";s:11:"socialLink4";s:24:"http://www.instagram.com";s:10:"socialImg5";s:0:"";s:11:"socialLink5";s:24:"http://www.pinterest.com";s:10:"socialImg6";s:0:"";s:11:"socialLink6";s:0:"";s:12:"specialTitle";s:0:"";s:14:"specialContent";s:0:"";s:12:"specialImage";s:0:"";s:12:"specialPrice";s:0:"";s:8:"gallery1";s:0:"";s:8:"gallery2";s:0:"";s:8:"gallery3";s:0:"";s:8:"gallery4";s:0:"";s:8:"gallery5";s:0:"";s:8:"gallery6";s:0:"";s:8:"gallery7";s:0:"";s:8:"gallery8";s:0:"";s:8:"gallery9";s:0:"";s:9:"gallery10";s:0:"";s:9:"gallery11";s:0:"";s:9:"gallery12";s:0:"";s:9:"gallery13";s:0:"";s:9:"gallery14";s:0:"";s:9:"gallery15";s:0:"";s:9:"gallery16";s:0:"";s:9:"gallery17";s:0:"";s:9:"gallery18";s:0:"";s:9:"gallery19";s:0:"";s:9:"gallery20";s:0:"";}';
$mydata = unserialize($mydata);
echo $mydata['gpsLongitude'];