Junk characters from SharePoint List

[prajwala]

Hello all,

I am using RPC call to load data from a SharePoint List and I get junk characters for few fields when loaded into QlikView.

For Example, Department column has values always prefixed by ';#' like ";#Sales;#"

I tried PurgeChar(Department,';#') and this works fine when the column has only one value.

Sometimes there are multiple values separated with a comma. Example: Department having a value as "Sales,HR,Management" in this case my data looks as below

;#Sales;#HR;#Management;#

In this if I use PurgeChar am ending up with no space or commas in the field like "SalesHRManagement".

Can anybody help me with this? I am not sure about why the junk characters appear and I think these are not constant always.

[Gysbert_Wassenaar · Accepted solution]

You could remove the first ;# and replace the other ;# with comma's:
Replace(Mid(Department,3),';#',',') as Departments

Or you could try using the SubField function with ;# as separator

EmployeeDepartments:
LOAD
EmployeeID,
SubField(Department, ';#') as Department
FROM
...source table... ;