Let’s say your dataset is big in both dimensions – rows and columns. Then you want to use join. To use join, you have to sort your data first. Something along those lines: <File1.txt sort -k2,2 > File1-sorted.txt <File2.txt sort -k3,3 -S1G > File2-sorted.txt join -1 2 -2 3 File1-sorted.txt File2-sorted.txt > matches.txt The sort … Read more
You could try this for a input-file called input: csplit -f tempfile input ‘/-/+1’ ‘{*}’; paste tempfile* With csplit we generate one file for each “column” in the desired output (tempfile01, tempfile02, …). Next, we merge these temporary files. With the given sample input, the output of the above command is: jim sally bill jerry … Read more
$ awk -F'[{,}]’ ‘{print $1, $4, $NF}’ file 2016-03-01 06:08:26 “msid”:”199033″ batch is running solved how to edit following line in sed, awk or anything else
Use something simple like sed: sed -r ‘s/^([0-9]*)$/update “table1” set event_type = \’NEW\’ where id=\1/’ file | write back using \1 as placeholder catch digits in the file Previous answer I used an approach based on bash loops, whereas it is a bit overkilling. See a related question: Why is using a shell loop to … Read more
First of all, * in regex is a quantifier that means “zero or more occurrences”. Since it is a regex metacharacter, it should be escaped, \*: k config get-contexts | awk ‘/\*/{print $5}’ However, since you are looking for a fixed string rather than a pattern you can use index: k config get-contexts | awk … Read more
Use printf() instead of print, as it doesn’t automatically add a newline. Then you can put a literal \n in the output. I’ve put this in a variable so I don’t put it before the first line, only all subsequent lines. Use BEGIN and END blocks to print quotes around it. ssh udcl804 aggr show … Read more
something like this? kent$ awk ‘/^key.:/{p=1}/^name:/{p=0} {if(p)printf “%s”,$0;else printf “%s%s\n”, (NR==1?””:RS),$0}’ file name: charles key1: howareyou? name: erika key2: I’mfine,thanks name: … handle the spaces: awk ‘/^key.:/{p=1}/^name:/{p=0} {if(p)printf “%s%s”,(/^key.:/?””:” “),$0; else printf “%s%s\n”, (NR==1?””:RS),$0}’ file output: name: charles key1: how are you? name: erika key2: I’m fine, thanks name: … 2 solved Remove newlines between … Read more
Following awk could help you in same. awk ‘{print > NF”column.txt”}’ Input_file Output it will create 3 files named 5column.txt, 4column.txt and 3column.txt. solved awk or sed extract each number of column alone
The problem of duplicate outputs is due to a single line matching both its own number and the $1 != 26 condition in the end. A simple solution is to add ; next after each prt(…) call. The problem with zero outputs is likewise due to the $1 != 26 matching too much. You could, … Read more
If you run multiple awk commands, the variables used are not shared. If you want them to be shared, you could combine the commands into a single program: awk -F ‘,’ ‘ $12 ~ /<WORD>/ {count++} ‘$12 ~ /<WORD>/ && $13 ~ /<DATE>/ {count2++} END {print $count-$count2} ‘ file.csv However, your three specifications seem to … Read more
cut removes sections from each line of files. From man cut: -c specifies a range of characters –complement complement the set of selected bytes, characters or fields this can be help to print from first to 11th character, from 18th to 32th and from 45th to the end: cut -c -11,18-32,45- yourFile or cut -c … Read more
Use GNU awk for multi-char RS: $ awk -v RS='</record>\n’ ‘{ORS=RT} /<keyword>SEARCH<\/keyword>/’ file <record category=”xyz”> <person ssn=”” e-i=”E”> <title xsi:nil=”true”/> <position xsi:nil=”true”/> <names> <first_name/> <last_name></last_name> <aliases> <alias>CDP</alias> </aliases> <keywords> <keyword xsi:nil=”true”/> <keyword>SEARCH</keyword> </keywords> <external_sources> <uri>http://www.google.com</uri> <detail>SEARCH is present in abc for xyz reason</detail> </external_sources> </details> </record> If you need to search for any of multiple … Read more
Your perl backreferences are incorrect: perl -lne ‘$a{$1}++ if (/^(Unexpected exception) : (.*?)\s*$/) ^^^^^^^^^^^^^^^^^^^^^-$1 ^^^^^-$2 You want $a{$2}++ instead. Or convert that first () to a non-capturing group: (?:Un….) 1 solved A perl script to list all the exceptions and their number of occurrence
If you want to increment only the (33*n)th rows, you can do this. awk ‘!(NR%33){$6+=++p} 1’ line 33 will be incremented by 1, line 66 by 2, etc. solved Increment every 33 line of 6 column by 1 [closed]
I already told you how to approach problems like this. See https://stackoverflow.com/a/42753485/1745001 and just add a line to that answer that says: f[“fechaName”]==5{for (i=1;i<=3;i++) print} Look: $ cat tst.awk BEGIN { FPAT = “([^,]*)|(\”[^\”]+\”)” OFS = “,” } { delete f for (i=1; i<=NF; i++) { split($i,t,/[[:space:]”:]+/) f[t[2]] = t[3] } } f[“fechaName”]==5 { for … Read more