Strange Character Issue in CSV file
My scenario is Proxy to File. Receiver file Should be CSV file with Pipe delimited. Sending customer information from ECC to PI to File. they have to send different countries customer details(Ex: they were sending russian, turkish etc..). to handle the special characters initially we have used UTF-8 but its failed to convert russian and turkish characters after that we used UTF-16, this encoding format handled all the special characters.but problem is added some special character to first field value(þÿ1200101) in CSV file. actually receiver application accept only UTF-8 and UTF-16 formats only. i tried use UTF-16LE but application does not support. could you please help me how to remove the special character.is there any way to handle it by wrriting UDF to handle this with out Java mapping. Kindly do the needful.