Hi,
I want to generate a report for count mismatching.
Steps followed for creating a script
for file in
1). I have to fetch the file name from the checksum.out #customer_information_
2). Added Detail #customer_information_Detail
3). Check the file exist or not.
3.1.1)if the the file is present then sum of the first field from Trailer_Data.csv and store the value in to Acutal variable
3.1.2)count the customer_information_Detail.csv and stores into Generated
3.1.3) echo $Actual $Genrated Diff ($Actual-$Generated) "present"
3.2.1)If the file is not present then first field from Trailer_Data.csv and store the value in to Acutal variable
3.2.2)echo $Actual 0 0 "Not present"
For second loop
for file in
1). I have to fetch the file name from the checksum.out #product_information_
2). Added Detail #customer_information_Detail
3). Check the file exist or not.
3.1.1)if the the file is present then sum of the second field from Trailer_Data.csv and store the value in to Acutal variable
3.1.2)count the customer_information_Detail.csv and stores into Generated
3.1.3) echo $Actual $Genrated Diff ($Actual-$Generated) "present"
3.2.1)If the file is not present then first field from Trailer_Data.csv and store the value in to Acutal variable
3.2.2)echo $Actual 0 0 "Not present"
and so on...
I am unable to get the proper output when i run the below script.I feel that,unix is not that much user friendly for generating a report.
---------- Post updated 07-23-10 at 02:14 AM ---------- Previous update was 07-22-10 at 06:46 AM ----------
I am unable to find reporting command other then echo in unix.
Last edited by pludi; 07-23-2010 at 04:54 AM..
Reason: No need for code tags on regular text
Hi,
I have a file with a list of bunch of IP addresses from different VLAN's . I am trying to find the list the number of each vlan occurence in the output
Here is how my file looks like
1.1.1.1
1.1.1.2
1.1.1.3
1.1.2.1
1.1.2.2
1.1.3.1
1.1.3.2
1.1.3.3
1.1.3.4
So what I am trying... (2 Replies)
What I'm trying to accomplish. I receive a Header and Detail file for daily processing. The detail file comes first which holds data, the header is a receipt of the detail file and has the detail files record count. Before processing the detail file I would like to put a wrapper around another... (4 Replies)
Hi All,
What am trying to do is generate the report by compating two files.
File A
-----------
111 22222 3333
222 55555 7777
File B
-----------
11A 22222 3333
333 55555 7778
Now the report should be as follows
Added:
333 55555 7778
Removed: (6 Replies)
Hi I recently joined a project where I have been asked to generate a report using shell script accessing UNIX box.
I have no idea on how to do it as I am a beginner and learning shell scripts.
Suppose I have a XML:
<XYZRequest>
<effectiveDate>someDate</effectiveDate>... (2 Replies)
Hello All,
I need to execute around 15 queries after which all data should come in Excel format.
Executing 15 queries is not a problem.
Problem is how to present/put data in excel.
kindly suggest me how to start, what to study or what should i do.
thanks, (1 Reply)
I have a sorted file like:
Apple 3
Apple 5
Apple 8
Banana 2
Banana 3
Grape 31
Orange 7
Orange 13
I'd like to search $1 and if $1 is not the same as $1 in the previous row print that row and print the number of times $1 was found.
so the output would look like:
Apple 8 3
Banana... (2 Replies)
Hi all,
I have a log file of the below format.
20081016:000042 asdflasjdf asljfljs asdflasjf safjl
20081016:000229 /lask/ajlsdf/askdfjsa
20081016:000229 /lashflas /askdfaslj hsfhsahf
20081016:000304 lasflasj ashfashd
20081016:000304 lajfasdf ashfashdfhs
I need to generate a... (3 Replies)
Hi,
My aim is to generate a report using shell script. There are various formats fields coloumns etc.
I want to print in a single line (row) but in different coloumn as given below:
field1 field2 field3 field4
....... ....... ...... .......
The spacing... (1 Reply)