Allow users to parse data from a comma-separated list before loading into ICA


Article ID: 171380


Updated On:


Information Centric Analytics Data Loss Prevention Core Package


When working with data from systems external to ICA, there are cases where the data being served to ICA is provided in a comma separated list.  ICA provides a function that can be leveraged to parse the data into prior to loading it into ICA.  The target function that can be used is dbo.fnParseDelimitedList. 


SQL Server

CAUTION: These commands assume a basic understanding of SQL. Any changes to the Database pose the potential to affect the operation of the product. ALWAYS ENSURE YOU HAVE A BACKUP OF YOUR DATABASE BEFORE MAKING CHANGES.

In order for Symantec to provide full support of the schema and the DB environment, you have to be running the DB in the version specific to the used version as outlined in the System Requirements Guide. Please see the limitations section at


Use the ICA function dbo.fnparseDelimitedList when bringing data into ICA.  The fnParseDelimitedList will take a comma separated list in this case we are passing a string that contains the days of the week in a comma separated format.  For format for the string is listed as fnParseDelimitedList(StringName,delimeter)