buildRowsetFromString.html

%%[
set @subscriberKey = AttributeValue(_subscriberKey)
set @subscriberrows = retrievesalesforceobjects(
   "contact",
   "firstname,lastname,email,preferences__c",
   "id", "=", @subscriberKey)

if rowcount(@subscriberrows) == 1 then

  set @subscriberrow = row(@subscriberrows, 1)
  set @firstname = field(@subscriberrow, "firstname")
  set @lastname = field(@subscriberrow, "lastname")
  set @email = field(@subscriberrow, "email")
  set @preferences__c = field(@subscriberrow, "preferences__c")

endif

if not empty(@Preferences__c) then
  set @rs = buildrowsetfromstring(@preferences__c,';')
  Output(rowcount(@rs))
endif    
]%%