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

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)}'...

#! /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...

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

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

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"

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

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