@bhagan I just changed the replacement value to : "${id:replaceEmpty('')}"||"${social_id:replaceEmpty('')}"||"${name:replaceEmpty('')}"||"${screenName:replaceEmpty('')}"||"${location:replaceEmpty('')}" An event payload would be (JSON format) : {"id":"1759930","social_id":"116161419","name":"Lucy Lloyd","screenName":"lucy_lloyd1","location":"Tunbridge Wells, England ","bio":"","lang":"en","created_date":"2010-02-21 11:35:07.0","image_url":"http://pbs.twimg.com/profile_images/787703929786232833/FRoV7x0L_normal.jpg","backgroud_image":"http://pbs.twimg.com/profile_background_images/600155425/xgqomh222q1tiq387bch.jpeg","followers":1011,"friends":862,"status":11429,"timezone":"London","url":null,"poids_social":23.98221972589741,"age":null,"gender":null,"smile":null,"glasses":null,"moustache":null,"beard":null,"sideburns":null,"country":null,"source":"LOCATION"} I am trying to convert a json to csv format. I guess that the fact to add double quotes "" in the replacement valued helped to solve the problem. I think there was special characters in group 5 (like the character $). Using double quotes happens to solve my problem but is there another solution to handle special characters like $ and carriage return? cause some of my fields have some of them.
... View more
