Search Results

Some sample always helps! Try (untested)awk 'NR>5 {sub(/^/, NR-5)} 1' file

Hello IMPe,

Request you to please always do show sample input and expected sample output too. If I understood correctly your requirement, could you please try following and let me know if that...

Downloading with what? Would it be worthwhile to look into your browser's config?

You might want to try this instead:
#!/bin/bash
awk '
FNR == 1 {
close(fn)
seq = substr(FILENAME, 8, 3)
fn = "test" FILENAME ".txt"
printf("%-13s\n", seq) > fn
}
FNR == 8 || FNR == 10 ||...

There are enough strange constructs in your sample shell script that I am not at all sure what you are trying to do, what your input files look like, nor what your output file is supposed to look...

What have you tried?
awk 'FNR==8 || FNR==10 || (FNR>=13 && FNR<=250)' sample.txt
should work.

Maybe?

awk '{$1=$4=":"; gsub(/:,/, "")};1' OFS=, FS=, file.csv

awk '{for(i = 1; i<=NF; i++);if(i != 1 && i != 4) print($i)}' file.csv

Hi, try:
date --date="$(date +%Y%m15) 1 month ago" +%Y%m

This behavior occurs, because februari 30 does not exist. So it is best to use the middle of the month to calculate the previous month..
...

Try sth likeawk -F, '{for (i=4;i<=26;i++) SUM[i]+=$i} END {for (i=4;i<=26;i++) print i, SUM[i]}' OFS="\t" file

How about you tell us exactly what you are trying to do? I don't think your original solution was the most efficient, running awk once per line.

What are the contents of file.tmp?

You can then go for :

sed 's!\(...\)\(...\)..!\2\1!' yourfileor (a little more "secure")
sed 's!\(../\)\(../\)..!\2\1!' yourfileNote that when you go from YYYY to YY you loose information and may...

Could be done with simple sed statements like:
sed 's!\(..\)/\(..\)!\2/\1!' yourfile
orsed 's!\(...\)\(...\)!\2\1!' yourfile

I suspect d[3] may actually be the rest of the line. Try setting FS & OFS separately.
awk '{split($1,d,"/"); $1=d[2]"/"d[1]"/"(substr(d[3],3,2)); print}' FS=, OFS=, file

"%2d/%02d/%02d,%s,%s,%s\n" is expecting 6 arguments, and you only have 4 (and 11 or 12 fields on the lines).

One way might be to use split rather than having multiple field separators:
awk...

To keep the same formatting:
sed 's;[:/];,;g' yourfile | sort -t, -k 4,4 -k 2,3 -k 5,6 | sed 's/,/:/5;s:,:/:3;s:,:/:2'or move the YY at the beginning of the date so that the format will change into...

A best practice is to use the YYYYMMDD format (date '+%Y%m%d') for the date, so that further sorting are made easy.

Not that YYYY is better than YY because retaining only the 2 last digit suppose...

Yes... and then showed an example that matched 1-5. Does he want to round down to ten minutes for low numbers, and up to ten minutes for high ones?

Being unsure, I showed him how backreferences...

He said:
allways to full ten-minutes :)

Because that's what he had. I suspect we don't completely know his requirements, maybe he wants to do rounding...

Hi, try:
sed -e 's/\(:[0-9]\)[1-9]:/\10:/' file.txt
Regards.

Edit: Too late :)

In Fact, no, @Corona688: [0-5] it's right but [1-5] ?

The feature you are looking for is called a backreference, you can quote parts of text inside \( \) and refer to them later with \1 \2 \3 ...

sed 's/:\([0-5]\)[1-5]:/:\10:/g' file.txt

As you are using awk anyhow, why don't you do the maths and formatting all in one single awk script? Might be clearer, cleaner and easier to maintain.

it was supposed to be
$((T20-T120))OR
$(echo "$T20-$T120" | bc)