Search Results

Thanks everyone for your valuable suggestions...apprecaite that.

Ahmad - can you please tell me:

1. Whats the bolded piece doing ..i mean how is it getting rid of .txt?

for x in `ls...

Hi,
I have a file name in the folder as payments.txt, After processing the data in this file it needs to be archived with date and timestamp in the end as:

payments_01142010_120023.txt

This...

Hi,
I currently have a shell script where it captures in the value in to 'TOTAL' and outputs to a file, i want to capture another value of a query in to another variable and output it.

Current...

Thanks guys...

I just stuck to the solution i mentioned....outputting it to a new temporary file...its easier that way.


thanks,
R

Hi,
I want to replace a field in a text delimited file with the actual number of records in the same file.


HDR|ABCD|10-13-2008 to 10-19-2008.txt|10-19-2008|XYZ...

PERFECT SOLUTIONS :b:

nawk -F'|' 'NR==1; $2==0 {s=$0; f=0; p=1}
$8=="" && $2 ~ /^[1-9][0-9]?+$/ && p {print s; f=1; p=0}
f && !/^TRL/; /^TRL/{end=$0} END{print...

Hi rubin,

Your code perfectly works. Other solutions i figured out which works are:


code-1
nawk -F'|' 'NR==1; $8=="" && $2!="0" && $1=="DTL" && NR==n+1 {print s} $2=="0" {s=$0; n=NR}
...

Thanks Rubin ...really appreciate that.

I used this code as i dont know how far the Numbers further go(instead of ^[1-9]+ i said != "0" ):

nawk -F'|' 'NR==1; $8=="" && $2!="0" && NR==n+1...

Thanks rubin really appreciate that...the command you sent worked for one set of files, I just noticed that there is another text file with similar data just a small difference i was trying to play...

Hello Rubin:

thanks..it worked partially....with the code you gave the following is the output:

HDR|ABCD|10-13-2008 to 10-19-2008.txt|10-19-2008|XYZ...

Hello all:
I have a following textfile data with name inst1.txt

HDR|ABCD|10-13-2008 to 10-19-2008.txt|10-19-2008|XYZ
DTL|H|5464-1|0|02-02-2008|02-03-2008||||F|||||||||...

Hi all:
HDR|ABCD|10-13-2008 to 10-19-2008.txt|10-19-2008|XYZ
DTL|H|5464-1|0|02-02-2008|02-03-2008||||F|||||||||
DTL|D|5464-1|1|02-02-2008|02-03-2008|1||JJJ...

:)

As soon i submitted the 1st message it errored out to - "Page cannot be displayed"...so i had to retype everything and submit again....surprisingly to find the first post was submitted...

Perfect- vgersh99

You were right...it was my mistake i missed the column count.

really appreciate your time...i wish there was some kind of rating here...you deserve more than 10/10...

Perfect - vgersh99
you were right...my column count was wrong

really appreciate your time....wish there was some kind of rating here.... u deserve more than 10/10 though...!!


thanks,
ravi

Hi:

thanks again

If i execute this:

nawk -F'|' '$8 == "" ' inst.txt >null.txt
the null.txt is getting all the records dumped in to it as it is from the original file.

nawk -F'|' '$8...

Thanks VGERSH99.
But could you please tell me how do i test it on the unix command prompt...i mean how do i send in the input file? so that it checks for the null column in all the records?
...

Hi:

I have a text file date(pipe delimited) which is loaded in to the DB using sql loader(&CTL files) after some initial validation by the shell script.
Now i have a situation where the shell...

Hi,
I found the solution, here is what the problem was...i was missing ";" on the the lines 235 & 236

+234 sqlplus $user <<EOF1
+235 set heading off;
+236 set feedback off;
+237 spool...

thanks for the reply Franklin52 but i did close it....see line numbers 234 and 240......the one you are mentioning is commented out.


thanks,
ravi

Hi,
I am new to shell scripts may be the error is very very small and i am unable to catch hold of it, any suggestion would be appreciated....error is at the bottom:

+210 # get file type
+211...