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.

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

Maybe?

awk '{$1=$4=":"; gsub(/:,/, "")};1' OFS=, FS=, 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..
...

What are the contents of file.tmp?

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.

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.

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...

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

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] ?

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

He said:
allways to full ten-minutes :)

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...

Instead of "$T20-$T120", the proper syntax would be "$(( T20 - T120 ))"
--edit--
That should be $(echo "$T20 - $T120" | bc) since it is bash, not ksh93