topic Re: Sharepoint Data Extraction Issue in QlikView https://community.qlik.com/t5/QlikView/Sharepoint-Data-Extraction-Issue/m-p/481993#M180118 <HTML><HEAD></HEAD><BODY><P>Thanks for this</P></BODY></HTML> Wed, 04 Dec 2013 09:31:01 GMT Qlik__Vinodh 2013-12-04T09:31:01Z Sharepoint Data Extraction Issue https://community.qlik.com/t5/QlikView/Sharepoint-Data-Extraction-Issue/m-p/481991#M180116 <HTML><HEAD></HEAD><BODY><P>Dear Friends,</P><P></P><P>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....</P><P></P><P></P><P>Thanks,</P><P>vinodh c</P></BODY></HTML> Sat, 23 Nov 2013 05:59:49 GMT https://community.qlik.com/t5/QlikView/Sharepoint-Data-Extraction-Issue/m-p/481991#M180116 Qlik__Vinodh 2013-11-23T05:59:49Z Re: Sharepoint Data Extraction Issue https://community.qlik.com/t5/QlikView/Sharepoint-Data-Extraction-Issue/m-p/481992#M180117 <HTML><HEAD></HEAD><BODY><P>Try in your script:</P><P></P><P></P><P></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #0000ff; font-size: 8pt;">replace</SPAN>(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">SubField</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">your_fieldName</SPAN><SPAN style="font-size: 8pt;">,';',2),'#','') </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">as</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">newfield </SPAN></P><P></P></BODY></HTML> Sat, 23 Nov 2013 18:04:42 GMT https://community.qlik.com/t5/QlikView/Sharepoint-Data-Extraction-Issue/m-p/481992#M180117 omyahamburg 2013-11-23T18:04:42Z Re: Sharepoint Data Extraction Issue https://community.qlik.com/t5/QlikView/Sharepoint-Data-Extraction-Issue/m-p/481993#M180118 <HTML><HEAD></HEAD><BODY><P>Thanks for this</P></BODY></HTML> Wed, 04 Dec 2013 09:31:01 GMT https://community.qlik.com/t5/QlikView/Sharepoint-Data-Extraction-Issue/m-p/481993#M180118 Qlik__Vinodh 2013-12-04T09:31:01Z