Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Read data from one file and putting in new file ??

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Read data from one file and putting in new file ??
# 8  
Old 12-04-2008
Have you tried my solution?

Regards
# 9  
Old 12-05-2008
Use Franklin's solution, it is much better.

I suppose you shell doesn't support $(...). So you have to
replace it with `...` (backticks.)
# 10  
Old 12-05-2008
To elaborate on Chis's code:

Command Substitution

Command substitution allows the output of a command to replace the command name. There are two forms:

$(command)

or

`command`


EXAMPLE:

Code:
#!/bin/bash
MYFILES=$(ls -d ~/*)
MYFILES2=`ls ~`

echo "$MYFILES"
echo "------------------------------------"
echo "$MYFILES2"

will give output like:

dirA dirB
----------------------------------
dirA dirB file1 file2 file3
# 11  
Old 12-05-2008
Can you please explain how to use below code:

Code:
awk -F" |," 'NF{print > tolower($1$2)}' file

where i have to define the input file and what will be the name of output file?

i put the below line in file and make it executable so the following error occurs.

all is input file name:

#!/bin/sh
awk -F" |," 'NF{print > tolower($1$2)}' all

KarachiOMP root> ./code3
awk: syntax error near line 1
awk: bailing out near line 1


Regards,
Waqas Ahmed
# 12  
Old 12-05-2008
Quote:
Originally Posted by wakhan
Can you please explain how to use below code:

Code:
awk -F" |," 'NF{print > tolower($1$2)}' file

where i have to define the input file and what will be the name of output file?

i put the below line in file and make it executable so the following error occurs.

all is input file name:

#!/bin/sh
awk -F" |," 'NF{print > tolower($1$2)}' all

KarachiOMP root> ./code3
awk: syntax error near line 1
awk: bailing out near line 1


Regards,
Waqas Ahmed
As I mentioned, use nawk or /usr/xpg4/bin/awk on Solaris.
If you want the output in a file redirect the ouput of the command to the file.

Regards
# 13  
Old 12-05-2008
Now i am using nawk and its giving below error. all is the name of my input file.

Code:
#!/bin/sh
nawk -F" |," 'NF{print > tolower($1$2)}' all

KarachiOMP root> ./code3
nawk: null file name in print or getline
 input record number 5, file all
 source line number 1


all contain data something like this.
Code:
KarachiOMP root> cat all
OP:ALARM,ALL!
 PF

M 54 OP:ALARM
     CELL 3 PACKET PIPE (PP) 3
     CELL 3, CDM 1 CBR 3 TRANSMIT PORT (TXPORT) 1

     CELL 4 PACKET PIPE (PP) 1

     CELL 5, CDM 1 ANTENNA DIVERSITY IMBALANCE 3
     CELL 5 RECEIVE AMPLIFIER FAILURE 4
     CELL 5 RECEIVE AMPLIFIER FAILURE 6

     CELL 6 RECEIVE AMPLIFIER FAILURE 2

     CELL 7, CDM 1 CBR 2 TRANSMIT PORT (TXPORT) 1

     CELL 10, CDM 1 ANTENNA DIVERSITY IMBALANCE 3
     CELL 10 RECEIVE AMPLIFIER FAILURE 5

# 14  
Old 12-05-2008
The given format of the file is different from the first post, try this:

Code:
nawk '/CELL/{sub(",","",$2);$1=$1;print > tolower($1$2)}' file > newfile
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

In PErl script: need to read the data one file and generate multiple files based on the data

We have the data looks like below in a log file. I want to generat files based on the string between two hash(#) symbol like below Source: #ext1#test1.tale2 drop #ext1#test11.tale21 drop #ext1#test123.tale21 drop #ext2#test1.tale21 drop #ext2#test12.tale21 drop #ext3#test11.tale21 drop... (5 Replies)
Discussion started by: Sanjeev G
5 Replies

2. Shell Programming and Scripting

Read csv file, convert the data and make one text file in UNIX shell scripting

I have input data looks like this which is a part of a csv file 7,1265,76548,"0102:04" 8,1266,76545,"0112:04" I need to make the output data should look like this and the output data will be part of text file: 7|1265000 |7654899 |A| 8|12660000 |76545999 |B| The logic behind the... (6 Replies)
Discussion started by: RJG
6 Replies

3. UNIX for Dummies Questions & Answers

How to read data from zip file?

Hi All, could you please answer the below question. 1)How to read the data from zip file without unzip? Regards Priyanka (2 Replies)
Discussion started by: pspriyanka
2 Replies

4. Shell Programming and Scripting

Read file data and send to different file

junk.txt has a single numerical value in it, let's say 50421.44. over.namelist has lots of expressions in it, but somewhere random it says value = x.x I need to go into junk.txt, pull out the number, and amend over.namelist to say value = 50421.44. :(:( I'm trying to use sed, but... (5 Replies)
Discussion started by: jammyjames
5 Replies

5. Shell Programming and Scripting

Want to read data from a file name.txt and search it in another file and then matching...

Hi Frnds... I have an input file name.txt and another file named as source.. name.txt is having only one column and source is having around 25 columns...i need to read from name.txt line by line and search it in source file and then save the result in results file.. I have a rough idea about the... (15 Replies)
Discussion started by: ektubbe
15 Replies

6. Shell Programming and Scripting

Read the apecific data from one file and write into another file

Hi, I would like to read the specific data from file and write the data in the new file. My data input is something like this.. <EXROP:R=TJ0311T; ROUTE DATA R ROUTE PARAMETERS TJ0311T DETY=UPDR TTRANS=1 FNC=3 MA=628160955000 R=TJ0311D ... (3 Replies)
Discussion started by: bha148
3 Replies

7. Shell Programming and Scripting

Read data in XML file

Hello Everybody, I have a question on reading the data from XML file through KSH shell script. In the below file I need to collect the patient control no and its respective insured id. I need to have pair of these values in single line separated by some special character, so that I could use... (2 Replies)
Discussion started by: swame_sp
2 Replies

8. Shell Programming and Scripting

Post Shell programming: Question about source a file and read data from the file

This is shell programming assignment. It needs to create a file called .std_dbrc contains STD_DBROOT=${HOME}/class/2031/Assgn3/STD_DB (which includes all my simple database files) and I am gonna use this .std_dbrc in my script file (read the data from the database files) like this: .... (3 Replies)
Discussion started by: ccwq
3 Replies

9. Shell Programming and Scripting

Read from data file

Hi, I have a data file formatted like this: Ex: Mike 3434 Jack 481 Peter 12 Alan 926 I want to get this data into 2 variables: "Names" and "Numbers" that I can using one "for" loop to get the value as Names and Numbers Like this: for i in 0 1 2 3 do echo $Names echo... (12 Replies)
Discussion started by: fongthai
12 Replies

10. Shell Programming and Scripting

Read data from a file into a variable

I am a FORTRAN guy and not a UNIX expert by any means so sorry if this sounds dumb, but all I want to do is have a UNIX script which reads data from a file (say 1000 lines worth, each row is a file name) and store it in an array to perform an operation on later. As maddeningly simple as this... (2 Replies)
Discussion started by: yorkdg
2 Replies
Login or Register to Ask a Question