Search results for query: *

Remove the -s option. You can play with the SET ECHO {ON|OFF} in you sql script. Jean-Pierre. Jean-Pierre.

sed 's/\./:/;s/\./:/;s/-/:/;s/-/:/' inputfile Jean-Pierre.

A more cryptic solution using sed : sed -n 'H;${x;s/\n//g;s/,$//;p;}'dftmp2 For a production script, prefer the PHV'solution that is more simple to understand and to maintain. Jean-Pierre.

GNU sed The following address types are supported: number Match only the specified line number. first~step Match every step'th line starting with line first. For example, ``sed -n 1~2p'' will print all the odd-numbered lines in the input stream, and the address 2~5...

Another syntax : integer CurrentBackup PreviousBackup CurrentNumber if ((CurrentBackup==0)); then (( PreviousBackup=10-(CurrentNumber-1) )) else (( PreviousBackup=CurrentNumber-1 )) fi Jean-Pierre.

Try : fgrep -f strings.txt pipe_delim.txt Jean-Pierre.

gawk -F"|" 'NR==FNR {a[$1]=$2;next} { if ($1 in a) { print $0 a[$1]"|" > "good" } else { print $0 > "bad" } }' rangefile myfile Jean-Pierre.

A small variation : - Use any non alpha-numeric character as field separator. - Strings are displayed only once. awk -F '[^[:alnum:]]' ' { for (f=1; f<=NF; f++) { if ($f ~ /GN0[0-9][0-9][0-9][0-9]/) ++strings[substr($f, 1, 7)]; } } END { for (s in...

Another solution with awk #/usr/bin/awk -f #Awk Program : city.awk NR == FNR { city[++cities_count] = $0; pattern[cities_count] = "(^|[^a-z-])" tolower($0) "([^a-z-]|$)"; count[cities_count] = 0; next; } { $0 = tolower($0); for (c=1; c<=cities_count; c++) if ($0 ~...

An awk solution : #!/usr/bin/awk -f # Awk program : join.awk /^[0-9][0-9]\// { if (line) print line; line=""} { gsub(/[[:space:]]+/, " "); line = line $0 } END { if (line) print line } Output: $ join.awk table1.txt 06/15/2007 02:28:47 TABLE "nmmp_" - 18,015,000...

Another way with awk awk ' /^TAG/ {if (tag) print tag; tag = "" } { tag = tag $0 } END {if (tag) print tag } ' inputfile Jean-Pierre.

You can include the awk program in a ksh script in the following ways : 1) Create the awk program file fmt.awk and include the following statement in your KSH script file : awk -f fmt.awk tmp.txt 2) If you don't want to use an external file, you can include all the awk program in your KSH...

You can do something like that : #!/usr/bin/awk -f # Awk program : fmt.awk /ARCHIVING DATABASE/ { db_prefix = "ARCHIVING DATABASE " $5; print db_prefix; next; } $3 ~ /TABLE/ { out = db_prefix; for (f=3; f<= NF && f<=9; f++) out = out " " $f; print out; } $3 ~...

You can try something like that: # # Proceed all records # { records[NR] = $0; # Memorize record keys[NR] = $1; # Memorize record key ++counts[$1]; # Count records with this key sums[$1] += $2; # Summurize values for this key } # # End of datas # END { # #...

\B Matches everywhere but on a word boundary; that is it matches if the character to the left and the character to the right are either both "word" characters or both "non-word" characters. \> Constrains a RE to match the end of a string or to precede a character that is not a digit...

# add commas to numeric strings, changing "1234567" to "1,234,567" sed ':a;s/\B[0-9]\{3\}\>/,&/;ta' # GNU sed sed -e :a -e 's/\(.*[0-9]\)\([0-9]\{3\}\)/\1,\2/;ta' # other seds Jean-Pierre.

#usage: matchBool "less_filx22dat.txt" "dat" b matchBool(){ x=$3; eval $x=\\$(awk -v name=$1 -v patern=$2 'BEGIN{print match(name,patern)}'); if eval [ \$$x -eq 0 ] then eval $x=0 else eval $x=1 fi }Can be simplified: #usage: matchBool "less_filx22dat.txt"...

You don't need to use eval ; for fl in `find -name "*.jpg"`;do x=$(awk -v name=$fl 'BEGIN{print match(name,/less/)}') if [ $x -eq 0 ] then echo "No match for file $fl" else echo "Match at position $x for file $fl" fi doneExample: $ ls *.jpg file_less.jpg file_more.jpg $ krava.sh...

With awk : putHeader(){ for fl in `find -name "$1"`; do echo $fl tmpNm=$(basename $fl).tmp awk -v hd="$2" 'BEGIN{print hd}' $fl > $fl.tmp mv $fl.tmp $fl done } putHeader "tau*" "energy errors" Jean-Pierre.

The usage of printf without format may be dangerous $ cat infile xyz %s %s%s%s ccc $ awk '{printf $1 " "}' infile xyz awk: There are not enough parameters in printf statement %s . The input line number is 2. The file is infile. The source line number is 1. $The better way is : $ awk...