07-17-2007
working with files---rowcount issue
Hi All,
Can u plz tell me how to ensure row count.
input file /app/PNYCOINF01/opera/operaprd/Data/SENTRY_BSL2_COLLRECEIVEPOS_AM_20070716.dat
checkFile: The input file exists
checkFile: Checking for existing copy of output file /app/PNYCOINF01/opera/operaprd/SrcFiles/AMS/SENTRY_BSL2_COLLRECEIVEPOS_AM_20070716.dat
checkFile: There are no existing copies of the output file
checkFile: Checking the first 1 lines of the file for "20070716"
checkFile: Passed the header check
checkFile: Checking the line count appears in the footer
checkFile: The total number of rows of data in the file is 631
checkFile: Checking 631 appears in the 1 lines of the footer
checkFile: Failed to find the correct row count in the file.
checkFile: EXITING DUE TO ERRORS Mon Jul 16 23:37:02 EDT 2007
What i checked is
wc -l SENTRY_BSL2_COLLRECEIVEPOS_AM_20070716.dat
632
opened the file checked the last line which was footer it is currently showing 630 as count. It may be, after some change taken place in file by our manager, i just wanted to understand what was the change took place.
i am thinking that either deletion or addition of one emptyline into file may be done. if it is true, where did he add or delete it if not can u plz advise me for further.
thanks in advance..
-bali
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have one file stat.
Stat file contents are as follows: for example.
H50768020040913,00260100,507680,13,0000000643,0000000643,00000,0000
H50769520040808,00260100,507695,13,0000000000,0000000000,00000,0000 H50770620040611,00260100,507706,13,0000000000,0000000000,00000,0000
Now i... (1 Reply)
Discussion started by: davidpreml
1 Replies
2. UNIX for Dummies Questions & Answers
Hi
I am trying to redirect all webpages within a directory on my site to another website. I can only get this to work for directories only, not actual files. The following scenarios work:
http://www.mysite.com/folder1/folder3 redirects to http://www.newsite.com/redirectpage.jsp
... (0 Replies)
Discussion started by: geoscience
0 Replies
3. AIX
HI,
I have upgraded nim master and client to TL8,SP6. Now when the mksysb backup ran from master,it is not excluding directories specified in /etc/exclude.rootvg in the client.Instead,mksysb is getting created for all the file systems in the rootvg. This problem only appeared after the TL... (3 Replies)
Discussion started by: to_bsr
3 Replies
4. Shell Programming and Scripting
I wrote a bash script to extract a few Items like the IP addresses that makes the most number of connection attempts, now I want to limit all of this within a time range , lets say the last X days/hours.
Example of what I wrote :
-G: Which IP address makes the most number of connection... (2 Replies)
Discussion started by: melisa.zand
2 Replies
5. Shell Programming and Scripting
Hi,
One of the program creating a file with the following information.
$cat a.txt
1, AAA, 234
$
and I wrote a script whenever any of the the file exists with data then it will send a email to me.
If I start the job second time, then the as per the logic it is sending the same data, I... (3 Replies)
Discussion started by: Alex_Smith
3 Replies
6. Shell Programming and Scripting
Dear friends,
I am working with two files named g1.txt and g2.txt....g1.txt is my main file in which it contains following data
#per_no permissionname permission command
1|HideCDrive, | : REG ADD "HKCU\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer" /v... (1 Reply)
Discussion started by: jalpasoni
1 Replies
7. Shell Programming and Scripting
Hello guys,
I have little to no experience working with two files in awk and hope you can help me with a problem that may be easy for you to solve...
awk -v cut1="$var1" -v cut2="$var2" '{split($0, arr1); for(i=1;i<=NF;i++) if (arr1 < cut1) print arr1, NR, i}' file1 file2
The above code is... (4 Replies)
Discussion started by: origamisven
4 Replies
8. Shell Programming and Scripting
So I have a script that runs an ls on a given directory and looks for files with a timestamp that has the current hour in it and then does work with the files that it discovers
DATE=`date +'%y%m%d%H'`
HOSTIS=`hostname`
#EMAIL NOTIFICATION ALS
EMAIL=address@server.com
#
if ; then
... (5 Replies)
Discussion started by: os2mac
5 Replies
9. Shell Programming and Scripting
I cannot figure out what is wrong.... I have 3 files with IP addresses:
file1 134.123.3.236
file2 134.123.3.235
file3 134.123.5.237
I type "prob1 Oops x2x3x4". Then my code creates file with name Oops and first line x2x3x4. Moreover, my code generate IP and it gives to file Oops as a second... (8 Replies)
Discussion started by: Manu1234567
8 Replies
10. Red Hat
Hello,
My apache user generate one file :
# ls -lsa /tmp/reference_file.csv
76 -rwxrwxrwx 1 apache apache 69921 Aug 16 14:14 tmp/reference_file.csv
the user and the group belong to apache, but when i am trying to change it :
su -l apache -s /bin/bash
-bash-3.00$ whoami
apache... (7 Replies)
Discussion started by: cterra
7 Replies
is a text formatter. Its input consists of the text to be out-
put, intermixed with formatting commands. A formatting command
is a line containing the control character followed by a two
character command name, and possibly one or more arguments. The
control character is initially . (dot). The formatted output is
produced on standard output. The formatting commands are listed
below, with being a number, being a character, and being a title.
A + before n means it may be signed, indicating a positive or
negative change from the current value. Initial values for where
relevant, are given in parentheses.
.ad Adjust right margin.
.ar Arabic page numbers.
.br Line break. Subsequent text will begin on a new line.
.bl n Insert n blank lines.
.bp +n Begin new page and number it n. No n means +1.
.cc c Control character is set to c.
.ce n Center the next n input lines.
.de zz Define a macro called zz. A line with .. ends definition.
.ds Double space the output. Same as .ls 2.
.ef t Even page footer title is set to t.
.eh t Even page header title is set to t.
.fi Begin filling output lines as full as possible.
.fo t Footer titles (even and odd) are set to t.
.hc c The character c (e.g., %) tells roff where hyphens are permitted.
.he t Header titles (even and odd) are set to t.
.hx Header titles are suppressed.
.hy n Hyphenation is done if n is 1, suppressed if it is 0. Default is 1.
.ig Ignore input lines until a line beginning with .. is found.
.in n Indent n spaces from the left margin; force line break.
.ix n Same as .in but continue filling output on current line.
.li n Literal text on next n lines. Copy to output unmodified.
.ll +n Line length (including indent) is set to n (65).
.ls +n Line spacing: n (1) is 1 for single spacing, 2 for double, etc.
.m1 n Insert n (2) blank lines between top of page and header.
.m2 n Insert n (2) blank lines between header and start of text.
.m3 n Insert n (1) blank lines between end of text and footer.
.m4 n Insert n (3) blank lines between footer and end of page.
.na No adjustment of the right margin.
.ne n Need n lines. If fewer are left, go to next page.
.nn +n The next n output lines are not numbered.
.n1 Number output lines in left margin starting at 1.
.n2 n Number output lines starting at n. If 0, stop numbering.
.ni +n Indent line numbers by n (0) spaces.
.nf No more filling of lines.
.nx f Switch input to file f.
.of t Odd page footer title is set to t.
.oh t Odd page header title is set to t.
.pa +n Page adjust by n (1). Same as .bp
.pl +n Paper length is n (66) lines.
.po +n Page offset. Each line is started with n (0) spaces.
.ro Page numbers are printed in Roman numerals.
.sk n Skip n pages (i.e., make them blank), starting with next one.
.sp n Insert n blank lines, except at top of page.
.ss Single spacing. Equivalent to .ls 1.
.ta Set tab stops, e.g., .ta 9 17 25 33 41 49 57 65 73 (default).
.tc c Tabs are expanded into c. Default is space.
.ti n Indent next line n spaces; then go back to previous indent.
.tr ab Translate a into b on output.
.ul n Underline the letters and numbers in the next n lines.