Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
prajwala
Contributor II
Contributor II

Junk characters from SharePoint List

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.

Labels (3)
1 Solution

Accepted Solutions
Gysbert_Wassenaar

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



talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar

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



talk is cheap, supply exceeds demand