Arcade Expression to break up field by identifer for pop-up

KevinDurkee

Hi 

I have a field (contactinfo) in a dataset that has a large amount of data in it and I am hoping to Split it via an arcade expression in a pop up. I thought the best way to split them in the expression would be by the comma.

The data in the field is shown below:

Owner ID: 0, CLIENT_TYPE_CODE: C, NAME1: JAMES HAMMERS INC , NAME2: , STREET1: 5783 TURNSTONE DR, STREET2: , CITY: LANGSVILLE, PROV_STATE_CODE: BC, COUNTRY_CODE: CAN, POSTAL_ZIP: V0N3A7, PHONE1: , PHONE2: , FAX: , CLIENT_NET_ADDR: , CONTACT_NAME: , CONTACT_PHONE1: , CONTACT_PHONE2: , CONTACT_FAX: , CONTACT_NET_ADDR:

I've tried something like this Split($feature.contact_info) if ,= true, however I think I'm getting a  syntax error. 

I'm fairly new to arcade, feel like this is probably quite simple and I'm just missing it.

Thanks for any help!

kenbuja

The use can use that in an expression like this to show only the values that aren't blank

 

var data = 'Owner ID: 0, CLIENT_TYPE_CODE: C, NAME1: JAMES HAMMERS INC , NAME2: , STREET1: 5783 TURNSTONE DR, STREET2: , CITY: LANGSVILLE, PROV_STATE_CODE: BC, COUNTRY_CODE: CAN, POSTAL_ZIP: V0N3A7, PHONE1: , PHONE2: , FAX: , CLIENT_NET_ADDR: , CONTACT_NAME: , CONTACT_PHONE1: , CONTACT_PHONE2: , CONTACT_FAX: , CONTACT_NET_ADDR:';

var theArray = Split(data,',');
var output = '';
for (var index in theArray) {
  var theInfo = Split(theArray[index],':');
  if (!IsEmpty(Trim(theInfo[1]))) output += `${Trim(theInfo[0])}: ${theInfo[1]}${TextFormatting.NewLine}`;
}
return output;