Shell Scripting


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Shell Scripting
# 1  
Old 06-15-2011
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.
# 2  
Old 06-15-2011
Code:
bash-3.00$ nawk -F"," '{ for (i=1;i<=NF;i++) {if(i==NF) {printf("%s\n",$NF)} else printf ("%s",$i)}}' /tmp/myfile
1234561234567891234540009/09/09INACTIVE
1234561234567891234540009/09/09INACTIVE
1234561234567891234540009/09/09INACTIVE

bash-3.00$ cat /tmp/myfile
123456,12345678912345,400,09/09/09,INACTIVE
123456,12345678912345,400,09/09/09,INACTIVE
123456,12345678912345,400,09/09/09,INACTIVE

read each word (seperated by comma) and just print it. If it is the last word, then print new line character ("\n")

---------- Post updated at 02:35 PM ---------- Previous update was at 02:33 PM ----------

you dont want / (forward slash) also ?
# 3  
Old 06-15-2011
Hey itkamaraj
Thanks!!

Can u explain me what is F and NF and whats the logic behind this.
# 4  
Old 06-15-2011
or simply use the sed command

Code:
 
bash-3.00$ sed 's/,//g' /tmp/myfile
1234561234567891234540009/09/09INACTIVE
1234561234567891234540009/09/09INACTIVE
1234561234567891234540009/09/09INACTIVE

---------- Post updated at 02:44 PM ---------- Previous update was at 02:41 PM ----------

NF - Number of Fields
Awk - A Tutorial and Introduction - by Bruce Barnett
F - Field Seperator
Awk - A Tutorial and Introduction - by Bruce Barnett
# 5  
Old 06-15-2011
Hey thanks, but both are not working
Below is the code.
In the code I am asking the user to enter the Location Code and Account number and status, then I am using Loaction and Account Number to match into a inputFile.txt and then writing the data to an output file. Also I have to write 400, date and status at the end of the line.
Code:
#!/bin/sh
#Author : Sameer Pandey
#Copyrights: Anybody can modify and make it work better.

echo "Input Location Code"
read locationCode

echo "Input the Account number"
read accountNumber

echo "Input the Status"
read status

>outFile.txt
chmod 777 outFile.txt
>outputFile.txt
chmod 777 outputFile.txt
egrep -i "$locationCode" inputFile.txt > tempFile.txt
grep -i "$accountNumber" tempFile.txt > outFile.txt

rm tempFile.txt

echo "400" >> outFile.txt
date "+%y/%m/%d" >> outFile.txt
echo $status >> outFile.txt

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

sed 's/,//g' outputFile.txt

cat outputFile.txt >> outputFilefinal.txt

echo "Processes Completed successfully"

Kindly look at the code and tell me where is the error.

Last edited by pludi; 06-15-2011 at 07:32 AM..
# 6  
Old 06-15-2011
post the outFile.txt contents

use sed -i

Code:
 
sed -i 's/,//g' outputFile.txt

This User Gave Thanks to itkamaraj For This Post:
# 7  
Old 06-15-2011
Quote:
Originally Posted by itkamaraj
post the outFile.txt contents

use sed -i

Code:
 
sed -i 's/,//g' outputFile.txt


Thank You very very much. It worked. Smilie Smilie

I just wanted to ask one thing more.
If suppose I wanted to read the file until I encounter a comma, then write that data into another file. How will I do that?

Last edited by sampandey31; 06-15-2011 at 07:47 AM.. Reason: Asking extra
 
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

Shell Scripting

Hello , Can any one suggest me that how copy only 3 characters and not more than that starting from "an" As below angio.txt anbel.jpg anheakla.txt when i try to copy anheakla.txt should not get copied . can some one suggest me ? (7 Replies)
Discussion started by: sankar91
7 Replies

3. 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

4. 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

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