Junk characters from SharePoint List

prajwala — Sat, 16 Nov 2024 21:41:52 GMT

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.

Re: Junk characters from SharePoint List

Gysbert_Wassenaar — Sat, 22 Dec 2018 14:58:05 GMT

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... ;

topic Junk characters from SharePoint List in QlikView

Junk characters from SharePoint List

Re: Junk characters from SharePoint List