Remove non-ASCII characters from CSV

by

A perl oneliner would do: perl -i.bak -pe 's/[^[:ascii:]]//g' <your file>

-i says that the file is going to be edited inplace, and the backup is going to be saved with extension .bak.

More Related Contents:

  1. Remove multi-line comments
  2. Insert a line at specific line number with sed or awk
  3. Remove line if field is duplicate
  4. delete a column with awk or sed
  5. remove ^M characters from file using sed
  6. How to use awk to print lines where a field matches a specific string?
  7. What is the difference between sed and awk? [closed]
  8. How do you delete all lines that contain no letters from the alphabet using either grep, sed, or awk? [closed]
  9. Is it possible to replace a newline AND another character with a single tab using sed?
  10. How can I manipulate text in bash? [closed]
  11. substitute words on a line only before first delimeter using sed or awk
  12. How can I replace each newline (\n) with a space using sed?
  13. Using different delimiters in sed commands and range addresses
  14. How to merge every two lines into one from the command line?
  15. How to delete duplicate lines in a file without sorting it in Unix
  16. Extraction of data from a simple XML file
  17. Using different delimiters in sed commands and range addresses
  18. Remove all text before colon
  19. How to remove trailing whitespaces with sed?
  20. Do a tail -F until matching a pattern
  21. What are the differences between Perl, Python, AWK and sed? [closed]
  22. Removing Windows newlines on Linux (sed vs. awk)
  23. Uppercasing First Letter of Words Using SED
  24. Add text at the end of each line
  25. sed: Replace part of a line
  26. Print lines in file from the match line until end of file
  27. Extract lines between two patterns from a file [duplicate]
  28. Have sed ignore non-matching lines
  29. Awk replace a column with its hash value
  30. How to delete rows from a csv file based on a list values from another file?

Leave a Comment