Need help in shell scripting


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Need help in shell scripting
# 1  
Old 05-13-2011
Need help in shell scripting

Hi,

I have one file where the records are delimited by |. What i did is i took one field which is delimited by | and i incremented by one. The task is to i need to put it back in the same location.


PLease help me !!!

Regards
Akshay
# 2  
Old 05-13-2011
It will be very helpful if you display the source data and the desired output.
# 3  
Old 05-13-2011
Here is the file format

01|2011-05-13 02:00:00|3|6|2 <--Header
XXXX | XXXX | XXXX XXXXX | <--Detail record
99|2011-05-13 02:00:00|3|6|2|25131 <--Trailer


The requirement is i need to get the value which is highlighted and increment by one and out it back to the orginal file.


Thanks
Akshay


# 4  
Old 05-13-2011
See if this works for you:
Code:
#!/usr/bin/ksh
typeset -i mFirst5
typeset -i mLast5

mFirstLine=$(head -1 inp_file)
mFirst14=$(echo ${mFirstLine} | cut -d'|' -f1-4)
mFirst5=$(echo ${mFirstLine} | cut -d'|' -f5)
mFirst5=${mFirst5}+1
mFirstOut=${mFirst14}'|'${mFirst5}

mLastLine=$(tail -1 inp_file)
mLast14=$(echo ${mLastLine} | cut -d'|' -f1-4)
mLast5=$(echo ${mLastLine} | cut -d'|' -f5)
mLastRest=$(echo ${mLastLine} | cut -d'|' -f6)
mLast5=${mLast5}+1
mLastOut=${mLast14}'|'${mLast5}'|'${mLastRest}

sed -e "1s/.*/${mFirstOut}/" -e "\$s/.*/${mLastOut}/" inp_file

This User Gave Thanks to Shell_Life For This Post:
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Shell script to read lines in a text file and filter user data Shell Programming and Scripting

sxsaaas (3 Replies)
Discussion started by: VikrantD
3 Replies

2. Shell Programming and Scripting

help me in Shell Scripting

Hi there please have a look at the code..i want to create Using a named pipe. Run a find in the background starting in the working directory While this is happening wait for input from the user to ask him which file to find. If the user does not enter any data in 10 seconds ask the user again.... (1 Reply)
Discussion started by: kattak1511
1 Replies

3. Shell Programming and Scripting

Shell scripting

Hi, if in a network there are lots of PCs connected with either windows or linux as operating system.Then what will be the shell script for the same and also if the PC has linux in it then we have to find if it is occupied or unoccupied. If the PC has windows in it then we have to find if it is... (6 Replies)
Discussion started by: akansha singh
6 Replies

4. UNIX for Dummies Questions & Answers

Shell Scripting

Hey I have a data in the file named as outputFile.txt. The data is in the format 123456,12345678912345,400,09/09/09,INACTIVE. I want this output without commas ie 12345612345678912345400090909INACTIVE. Please tell me what to do and clear explain all the terms, as I am new to it. (6 Replies)
Discussion started by: sampandey31
6 Replies

5. Web Development

Perl scripting or shell scripting?

i am going to study any one of the scripting languages mentioned above(shell 0r perl scripting) . Which is having more scope for a fresher? (1 Reply)
Discussion started by: Anna Hussie
1 Replies

6. What is on Your Mind?

Shell Scripting vs Perl scripting

Gents, I have been working in a Solaris/Unix environment for about 9 months. I took some linux classses online before getting the job. But, I am not very good at scripting. I want to learn how to script. Do you think that I should start with Shell scripting or Perl? I wanted to continue with... (2 Replies)
Discussion started by: Pouchie1
2 Replies

7. Android

Android Scripting Environment: Shell Scripting and Android

I just upgraded to Android 2.2 from 2.1. The GPS issue that was troublesome in 2.1 seems to have been fixed. Some of web browsing seems faster, but it could just be my connection is better today ;) Flash works in some browsers but not very good and it is too slow for Flash apps designed for... (0 Replies)
Discussion started by: Neo
0 Replies

8. What is on Your Mind?

Shell scripting vs Perl scripting

Hi all, I would like to start developping some good scripting skills. Do you think it would be best to start with shell scripting or Perl? I already got a fundation, really basics, in perl. but I am wondering what would be best to be good at first. Can you please help me determine which one to... (14 Replies)
Discussion started by: Pouchie1
14 Replies

9. Shell Programming and Scripting

Call Shell scripting from Perl Scripting.

Hi How to call a shell scripting through a Perl scripting? Actually I need some value from Shell scripting and passes in the Perl scripting. So how can i do this? (2 Replies)
Discussion started by: anupdas
2 Replies

10. Shell Programming and Scripting

difference between AIX shell scripting and Unix shell scripting.

please give the difference between AIX shell scripting and Unix shell scripting. (2 Replies)
Discussion started by: haroonec
2 Replies
Login or Register to Ask a Question