If you want to trim all spaces, only in lines that have a comma, and use awk, then the following will work for you: awk -F, ‘/,/{gsub(/ /, “”, $0); print} ‘ input.txt If you only want to remove spaces in the second column, change the expression to awk -F, ‘/,/{gsub(/ /, “”, $2); print$1″,”$2} … Read more
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.
Note: Coprocess is GNU awk specific. Anyway another alternative is using getline cmd = “strip “$1 while ( ( cmd | getline result ) > 0 ) { print result } close(cmd) Calling close(cmd) will prevent awk to throw this error after a number of calls : fatal: cannot open pipe `…’ (Too many open files)
From the AWK man page: system(cmd) executes cmd and returns its exit status The GNU AWK manual also has a section that, in part, describes the system function and provides an example: system(“date | mail -s ‘awk run done’ root”)
column(1) is your friend. $ column -t <<< ‘”option-y” yank-pop > “option-z” execute-last-named-cmd > “option-|” vi-goto-column > “option-~” _bash_complete-word > “option-control-?” backward-kill-word > “control-_” undo > “control-?” backward-delete-char > ‘ “option-y” yank-pop “option-z” execute-last-named-cmd “option-|” vi-goto-column “option-~” _bash_complete-word “option-control-?” backward-kill-word “control-_” undo “control-?” backward-delete-char
Here are two ways of doing it in R: foo <- “TF_list_to_test10004/Nus_k0.345_t0.1_e0.1.adj:PKMYT1” # Remove all before and up to “:”: gsub(“.*:”,””,foo) # Extract everything behind “:”: regmatches(foo,gregexpr(“(?<=:).*”,foo,perl=TRUE))
NR starts at 1, so use awk ‘{print NR-1 “,” $0}’
#since this was yesterday date -dyesterday +%Y%m%d #more precise, and more recommended date -d’27 JUN 2011′ +%Y%m%d #assuming this is similar to yesterdays `date` question from you #http://stackoverflow.com/q/6497525/638649 date -d’last-monday’ +%Y%m%d #going on @seth’s comment you could do this DATE=”27 jun 2011″; date -d”$DATE” +%Y%m%d #or a method to read it from stdin read -p … Read more
Yes, you can use the shell variables inside awk. There are a bunch of ways of doing it, but my favorite is to define a variable with the -v flag: $ echo | awk -v my_var=4 ‘{print “My var is ” my_var}’ My var is 4 Just pass the environment variable as a parameter to … Read more
When you split an array, the number of elements is returned, so you can say: echo “hello world” | awk ‘{n=split($0, array, ” “)} END{print n }’ # ————————^^^——————————–^^ Output is: 2