Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlik__Vinodh
Partner - Creator II
Partner - Creator II

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

Labels (1)
2 Replies
omyahamburg
Creator II
Creator II

Try in your script:

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

Qlik__Vinodh
Partner - Creator II
Partner - Creator II
Author

Thanks for this