I am calling a REST API and loading the data into Blob container CSV file. One column has some values in Japanese and another column has values with escape characters. I have been suggested below approaches
1) Set the column value to NULL or BLANK wherever we get the Japanese characters - How to do this?
2) Remove the entire record which has Japanese value for any column - How to do this also?
3) How to treat the columns which has escape characters before storing the data into CSV?
Kindly suggest some ideas on this issue.