Unable to process the special characters such as '%' and '||' and get into CSV format.

Question

Hi Team,

We have observed ,some special characters, such as'%' and '||'  having data processed into CSV is not getting open into the notepad with '|' as a delimeter.

Can you please help us to get it resolved or any idea ..why these specifice special characters are not gettting processed.

appriciate for quick response.

Regards,

Shruthi.V

RJ_1988 · Answer

Try pasting the relevant values in Notepad++, many times special characters or hidden ones are difficult to be identified in the notepad. try looking out for those special characters in 'Character Map' (in-built) tool of your system and handle in Alteryx accordingly.

Hsandness · Answer

Hi @ShruthiVijayaKumar ,

Can you post a sample of your input and the expected output you'd like to see? It will be easier to help with your request.

ShruthiVijayaKumar · Answer

Please can we have any update or ideas please