Help in developing an awk code


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Help in developing an awk code
# 1  
Old 07-08-2011
Help in developing an awk code

Code:
#!/bin/ksh
set -x

FILENAME=$1
#To calculate debit and credit 
DEBIT=`awk -F, '{value=$28 ;if(value<0) {debit+=value}} END {print debit}' $FILENAME`
CREDIT=`awk -F, '{value=$28 ;if(value>0) {credit+=value}} END {print credit}' $FILENAME`
#This part is not working since the debit value is negative ( am trying to figure out a for this too :()
#if [[ "$DEBIT" -ne "$CREDIT" ]]; then
#echo "Debit and Credit does not match"
#exit 9
#fi
#To Move the leading negative side and to make it trailing negative sign
nawk 'BEGIN {FS=","} { if(index($28,"-") > 0){print substr($28,2,length($0))"-"} else {print $28}}' $FILENAME >> NEW_FILE 

#MM=`date +%m`
#YY=`date +%Y`
#To read file and create new file with hardcodings and column reformatting 
also reading only file starting with 3 
cat $FILENAME |grep ^3 | while read line
do
echo "$line" | nawk ' BEGIN {FS=","} {print("5","date"$1,$13,"$14",$2,$5)}' >> New_file
done
exit 0

The above code is just bits and pieces

Let me state the requirement
1. I have input file with comma separated values
2. The input file contains leading negative values which I should make it as trailing
3. The first column I will have to hard code with 5 and second column should be system date (YY and MM) then around 10 columns which I can directly pick from input file and just reorder the positions and at last hard code X

I am attaching both inputs as well as out put file. Please help me to solve this...
Thank you

Last edited by pludi; 07-08-2011 at 09:26 AM..
# 2  
Old 07-08-2011
The output you provide doesn't correspond to the input you provided (or if it does, i don't get the way it is built from it ...)
# 3  
Old 07-08-2011
Hi

Yes the output file is very diff from input basically a lot of reformatting has to be done ...
like first column in the out put will have hard coding then second column will have sysdate and other columns are a rearraggement of the order of columns from input file .Also there is a column in input file with amount having negtavive sign(-567.00) i would want this also to be changed and printed as (567.00-) and (78.98+) (in case of positive files)
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. What is on Your Mind?

Developing Applications for UNIX.COM

A number of people have asked me about the best way to develop some cool new web app for UNIX.COM. In today's "very easy web dev" world, developers do not need to be burdened (like I am) to the "back end" of the site. The best way to develop web apps is to build the application on your desktop... (2 Replies)
Discussion started by: Neo
2 Replies

2. Shell Programming and Scripting

Help with approach and developing script

Hi- I need to develop a script for following scenario in AIX and K shell environment.I am from windows server background for most my career ,so please bear with me and advise suitable approach and technical assistance.Having said that I am aware of unix shell commands but never pput together at... (1 Reply)
Discussion started by: nirasm
1 Replies

3. UNIX for Dummies Questions & Answers

Help for developing script

I want to develop a unix script. Scenario:A folder is containing many text files and there is one text file eg. test.csv which is having 2 words at line 1 & line 2.The script should search for word at line 1 in test.csv file in all other text file present in folder & replace it with word at line 2... (5 Replies)
Discussion started by: Anna Cardoz
5 Replies

4. AIX

Developing application software on the AIX

I am a programmer who works on an IBM i (including AS/400, iSeries, System i and Power). In developing application software on the IBMi we use languages such as RPG/ILE and CLLE. There is a need also to use PF, LF, DSPF & PRTF to represent the physical/logical database and screen/print objects.... (0 Replies)
Discussion started by: Elias
0 Replies

5. UNIX for Dummies Questions & Answers

developing a Kernel for old old Unix?

Hello all , My father has been running the last version of unix before all the liscensing began 20 or so years ago. In his particular field his programmer has written a great deal of software to work with this version. Emulating so newer computers could speak to the unix server as well. Im sure... (6 Replies)
Discussion started by: Bill78
6 Replies

6. Shell Programming and Scripting

Developing own shell

Hi everyone.I am trying ti create my own shell in C.So far i have managed to create a parser to separate args from cmd line of my shell.(i have done nothing different for tokens is that wrong?).so i can run commands like "ls -l" "cp" "cat" etc.now i want to add redirection.can anyone guide me... (1 Reply)
Discussion started by: bashuser2
1 Replies

7. Programming

Help required in developing an Editor.

Hi, I wish to develop a editor of my own. My idea is using 100% C programming Linked list as the Data structure GNU/Linux as the compiling environment ncurses utility for screen Many of might have wrote a editor in your college itself as a project. But I am from non IT background.... (3 Replies)
Discussion started by: ramkrix
3 Replies

8. Shell Programming and Scripting

Can you help me regarding developing script?

Hi All, I want to develope this script. any help will be appreciated. It is possible to use two pipes and create two-way communication between two processes. (In practice, this is not done because sockets are available.) Create a program where the parent process reads the name of a language... (2 Replies)
Discussion started by: vishalpatel03
2 Replies

9. Programming

Developing Open Source tools

Hi Gurus, I am very much interested in developing and publishing a small piece of open source code which would be the best place to start off. I am just a beginner in unix ,c. Please provide me some suggestions. Thanks. (3 Replies)
Discussion started by: ennstate
3 Replies

10. UNIX for Advanced & Expert Users

Developing a new command line interface

Hi, Is there any good/easy tool or library which assists in developing a command line interface for an application. The CLI should be able to provide custom commands, allow programming/scripting as well. For the latter case it could wrap a shell command and send it to BASH for processing. (2 Replies)
Discussion started by: redirect
2 Replies
Login or Register to Ask a Question