Search Results

# Establish DB connection
ret=`db2 connect to $1`
ret=`echo "$ret"`

if [[ -z $ret ]] then
echo "Error connecting to $1 database."
exit 1
else
echo "Successfully...

Example to replace fields 2, 3 and 19 with '*' to field length (subsitute with the field#s you want to replace).

awk 'BEGIN{split("2,3,19", F, ",")} {for(fld in F) gsub(/./, "*", $fld)}1' filename

awk '{ for(i=1;i<=NF;i++) if(length($i)==20) gsub(/./,"*",$i); }1' filename

If you have GNU date, try this:
while IFS='|' read a b c; do echo "$a|`date -d$b +%Y%m%d`|$c"; done < inputfile

It's not working because you put that thing in an awk statement. Just put it as is on command line (ofcourse by substituting the filename to whatever contains your input)

Also, check if you have...

#! /usr/bin/perl -w
use strict;

open I, "< inputfile";
for (<I>) {
chomp;
my @x = split /\|/;
$x[1] = parse_date ($x[1]);
print join ('|', @x), "\n";
}
close I;

sub...

I know its dirty but worth to post.

$ mth=JANFEBMARAPRMAYJUNJULAUGSEPOCTNOVDEC
$ awk -F\| -v mlist=$mth '{split($2,A,"-") ;printf("%s|20%d%02d%d|%s\n", $1,A[3],(index(mlist,A[2])+2)/3,A[1],$3)}'...

Thanks Guru,

Could you please explain this pattern sed 's/\(.*_\)\(....\)\(..\)\(..\)/\1\4\3\2/'` , It will be very helpful.

$ x="abc_test_20120213.dat"

$ y=`echo $x | sed 's/\(.*_\)\(....\)\(..\)\(..\)/\1\4\3\2/'`

$ echo $y
abc_test_13022012.dat


Guru.

x='abc_test_20120213.dat'
y=${x%_*}
z=$(date -d `echo ${x%.dat} | cut -d_ -f3` +%d%m%Y)
echo "${y}_$z.dat"

Try: awk -F\" -vOFS="\"" '{for (i=2;i<=NF;i+=2) sub(",","",$i)}1' file

Alternatively:
awk 'NR%2-1{gsub(/,/,x)}1' RS=\" ORS=\" infile