Shell Scripting


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Shell Scripting
# 1  
Old 06-20-2011
Shell Scripting

Hi All,
I have a file in which data is as follows
Code:
ABCDE,FGHIJ
KLMNO,PQRST
UVWXY,ZABCD

Ok Now I want to append 400,CurrentDate,Status to each of the line.
Status will be inputted by the user.

Output should look like this
Code:
ABCDE,FGHIJ400200611active
KLMNO,PQRST400200611active
UVWXY,ZABCD400200611active

Kindly help me fast.

Last edited by Franklin52; 06-20-2011 at 06:32 AM.. Reason: Please use code tags for code and data samples
# 2  
Old 06-20-2011
what you tried so far ?

refer sed or awk commands
# 3  
Old 06-20-2011
I have tried Sed/Awk commands but unable to do it.
Code:
awk 'ORS=NR%1?RS:","' RS="\n" outFile.txt >> outputFile.txt

But not working. I am totally new to UNIX.
Kindly show me the way please.

Last edited by Franklin52; 06-20-2011 at 08:13 AM.. Reason: Please use code tags
# 4  
Old 06-20-2011
can you tell me, what it is exactly doing and why you tried in this way ?

Code:
 
awk 'ORS=NR%1?RS:","' RS="\n" outFile.txt >> outputFile.txt

1) read the input (status) from user
2) Find out in which line you need to append the "400,CurrentDate,status"
3) once you found the line, append it (using sed or use awk to print in the end of the line and redirct the output to another file)
# 5  
Old 06-20-2011
Actually I wrote the data in another temporary file and then clubbed all rows into one. Now I am writing the data present in this file to append the lines in another file.

---------- Post updated at 04:04 AM ---------- Previous update was at 03:57 AM ----------

Quote:
Originally Posted by itkamaraj
can you tell me, what it is exactly doing and why you tried in this way ?

Code:
 
awk 'ORS=NR%1?RS:","' RS="\n" outFile.txt >> outputFile.txt

1) read the input (status) from user
2) Find out in which line you need to append the "400,CurrentDate,status"
3) once you found the line, append it (using sed or use awk to print in the end of the line and redirct the output to another file)

Hey I have tried this
Can u tell me whats wrong in this??

#
# sed command file
# append the line 'containing 101010'
# in this input file
#
/101010/a\
400Active
save this script as 400txn.cmd

#This is write in the original script.
sed -f 400txn.cmd customer.txt
# 6  
Old 06-20-2011
To append the value at last
Code:
 
bash-3.00$ echo "test" | sed 's/$/abc/'
testabc

pattern match and append
Code:
 
 
bash-3.00$ echo "test
> abc
> edf"
test
abc
edf

bash-3.00$ echo "test
abc
edf" | sed ' /abc/ s/$/xyz/'
test
abcxyz
edf

This User Gave Thanks to itkamaraj For This Post:
# 7  
Old 06-20-2011
Quote:
Originally Posted by itkamaraj
To append the value at last
Code:
 
bash-3.00$ echo "test" | sed 's/$/abc/'
testabc

pattern match and append
Code:
 
 
bash-3.00$ echo "test
> abc
> edf"
test
abc
edf

bash-3.00$ echo "test
abc
edf" | sed ' /abc/ s/$/xyz/'
test
abcxyz
edf

Thank you!!
 
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