shell – remove numbers from a string column [closed]

by

[I] have tried everything

… except, say:

awk -F- 'BEGIN { OFS="-" } { sub(/[0-9]/,"",$3); print }' yourdata

More Related Contents:

  1. How to print lines between two patterns, inclusive or exclusive (in sed, AWK or Perl)?
  2. How to select lines between two marker patterns which may occur multiple times with awk/sed
  3. Do a tail -F until matching a pattern
  4. Awk replace a column with its hash value
  5. Enhancement of unix script [closed]
  6. Get lines between two patterns
  7. How to delete from a text file, all lines that contain a specific string?
  8. Bash tool to get nth line from a file
  9. Find and replace in file and overwrite file doesn’t work, it empties the file
  10. How to delete duplicate lines in a file without sorting it in Unix
  11. How to use multiple arguments for awk with a shebang (i.e. #!)?
  12. Insert line after match using sed
  13. How can I shuffle the lines of a text file on the Unix command line or in a shell script?
  14. sed whole word search and replace
  15. How can I delete a newline if it is the last character in a file?
  16. Using awk with variables
  17. How to insert a newline in front of a pattern?
  18. Alternative to `sed -i` on Solaris
  19. How to get the second column from command output?
  20. How can I check the version of sed in OS X?
  21. Sed to extract text between two strings
  22. Insert multiple lines into a file after specified pattern using shell script
  23. Trim leading and trailing spaces from a string in awk
  24. Remove part of path on Unix
  25. How can I pass variables from awk to a shell command?
  26. Replace whitespace with a comma in a text file in Linux
  27. How to add text at the end of each line in unix
  28. How to print 5 consecutive lines after a pattern in file using awk [duplicate]
  29. How to grep for case insensitive string in a file?
  30. Removing Windows newlines on Linux (sed vs. awk)

Leave a Comment