Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlik__Vinodh
Partner
Partner

Sharepoint Data Extraction Issue

Dear Friends,

Please find the attachment.I am fitching the data from sharepoint data using RPC process. But some fields data having Number and , and # symbols in front. please look the screen. if any change in process, please guide me....

Thanks,

vinodh c

2 Replies
omyahamburg
Creator II
Creator II

Try in your script:

replace(SubField(your_fieldName,';',2),'#','') as newfield

Qlik__Vinodh
Partner
Partner
Author

Thanks for this