Recent content by aigles

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