Search Results

Hi ,

I am writing a simple excel file and want to create the file under say 'D:\Documents and Settings'. The problem with my code is it is writing in the same directory instead of the specified....

did you try if it matches /\t+$/

sort -n -t" " -k1,3 *.csv


Video tutorial on how to use code tags in The UNIX and Linux Forums....

You get the additional rows when you skip the '/^\s*$/' line.

The line /^\s*$/ means any line that just contains white spaces or empty

If you notice your input file the format is as follows...

Using Perl :

cat old_file | perl -e '
while(<>){
my ($chr,$gene,$count,$start) = split ;
print "$chr\t$gene\t$count\t$_\n" foreach (split(/,/,$start));
}
' > new_file

Using awk :
awk...

awk -F';' '{sub("-","",$4);sum+=$4; }END {print sum}' file


HTH,
PL

perl -e '$hash{`head -c 9 $_`} = 1 foreach (`ls file*`);
> ((keys %hash) ==1) ? print "all three files are same\n" : print "all three files are not same\n";'



HTH,
PL

echo $mask_text
SERVER/USERNAME,PASSWORD

cat abc.txt
Value1
Value2
server1/mylogin,mypasswd
Value3
Value4


sed "s#server1/mylogin,mypasswd#$mask_text#" abc.txt
Value1
Value2...

awk '{if ($0 ~ /^http:\/\/www*/) { print $0 ,"valid" } else { print $0 ,"invalid" }}' abc.txt


http://www.abc.com valid
http://abc.com invalid
http://123/a.html invalid...

#!/usr/bin/perl

my %hash;
while(<>){
chomp;
my ($var,@arr) = split(",");
push @{$hash{$var}} , @arr;
}

my %prop_hash;
my $header = 1;

foreach my $var1(sort keys...

If you want to use perl
here is the sol



cat test1 test2 test3 |
perl -e '
while (<>){
chomp;
my ($id, $num) =split("\ ");
push @{$hash{$id}}, $num;
}
foreach (sort keys %hash){ ...

can u specify an example of the output you want

If you want to use perl


cat filename | perl -e 'while (<>){
chomp;
my ($name,@numbers) = split("\ ");
my ($max,$min,$max_pos,$min_pos) = (0,0,0,0);
for (my $i=0;$i<=$#numbers;$i++){
if...

use a backslash for '+'


$2 ~ /\+/{



Another solution in perl



cat filename | perl -e 'while (<>){
chomp;
($word,$sign) = split("\ ");
if ($prev_sign && $prev_sign ne $sign){...

ssh -q atukuri@remotehostname 'find /home/atkuri -name abc.txt -exec ls -l {} \;'
-rw-r--r-- 1 xxx users 49 2010-04-19 16:03 ./abc.txt

alternatively ls in find does a long listing by default
...

sed -ie 's/^[1-7,9] /1 /' filename




or


sed -e 's/^[^8] /1 /' filename



HTH,
PL

grep 'Cheque' MainFile.csv > TEMP.CSV ; sed -ie /Cheque/d MainFile.csv

sed -e 's/\s*//g' filename


HTH,
PL

awk -F '|' '{for(i=2;i<=NF;i++){ print $1.$i}}' filename


HTH,
PL

Try specifying the full path of sed in your shell script

first check the manual of find to see if you want to use atime, ctime , mtime .


find . -ctime 14 -exec rm {} \;


Note before using rm do some check with ls to see if the output is what you...

print Dumper(@{$extractColumns{'2'}{'D'}})

and
print Dumper(@{$extractColumns{'2'}{'M'}}

and see the values

Alternatively if you can paste the data or output it would be helpful

alternatively u can use

rm ./-r

from the directory it is present

HTH,
PL

What is the error you are getting?

Try using the full path for the password file if you are not executing from that directory.


Also not sure why you are using this


grep ^$/....



If...

LC_ALL=C ls -l | perl -e 'my %hash = ( "Jan"=> "01" , "Feb" => "02" , "Mar" => "03" , "Apr" => "04"); # add other months
while (<>){
chomp; s/\s+/ /g;
my @arr=split(" ");
print "$arr[-1]\t";
my...