Read from data file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Read from data file
# 8  
Old 02-27-2007
What abt this...? I thnk this shuold remove the '#'es and blank lines... I hvn't tested this nyway....!!
sed 's/^#//g' data_file -->will remove #es and grep -v '^$' will remove the blank lines...



for i in $(sed 's/^#//g' data_file |grep -v '^$'| awk -F" " '{print NR}')
do
nam_arr[$i]=$(awk -F" " -v cnter=$i '{ if (cnter == NR) {print $1;} }' data_file)
num_arr[$i]=$(awk -F" " -v cnter=$i '{ if (cnter == NR) {print $2;} }' data_file)
done
# 9  
Old 02-27-2007
Quote:
Originally Posted by jacoden
What abt this...? I thnk this shuold remove the '#'es and blank lines... I hvn't tested this nyway....!!
sed 's/^#//g' data_file -->will remove #es and grep -v '^$' will remove the blank lines...



for i in $(sed 's/^#//g' data_file |grep -v '^$'| awk -F" " '{print NR}')
do
nam_arr[$i]=$(awk -F" " -v cnter=$i '{ if (cnter == NR) {print $1;} }' data_file)
num_arr[$i]=$(awk -F" " -v cnter=$i '{ if (cnter == NR) {print $2;} }' data_file)
done
If the blank lines contain spaces then use this
Code:
grep -v '^ *$'

# 10  
Old 02-27-2007
Jacoden,

The sed and grep command does not work in that script.
Still have blank lines and comment_out lines
# 11  
Old 02-27-2007
try this
Code:
for i in $(sed '/^#/d;/^ *$/d' file| awk -F" " '{print NR}')

# 12  
Old 02-27-2007
Data

Oops..Just tested and corrected my mistake..Sorry abt that!!!

Here is my tested data file:
-----------------------------------------------
Mike 3434


Jack 481

Peter 12
Alan 926
#
Jacob 3423

Dennis 123


------------------------------------------------------------------------
Try for this script....


for i in $(cat data_file | sed -e 's/^#//g' -e '/^ *$/d' | awk -F" " '{print NR}')
do
nam_arr[$i]=$(cat data_file | sed -e 's/^#//g' -e '/^ *$/d' | awk -F" " -v cnter=$i '{ if (cnter == NR) {print $1;} }' )
num_arr[$i]=$(cat data_file | sed -e 's/^#//g' -e '/^ *$/d' |awk -F" " -v cnter=$i '{ if (cnter == NR) {print $2;} }' )
done

echo Array details

for i in $(cat data_file | sed -e 's/^#//g' -e '/^ *$/d' | awk -F" " '{print NR}')
do
echo nam_arr[$i]=${nam_arr[i]}
echo num_arr[$i]=${num_arr[i]}
done

-------------------------------------------------------------------
Result is shown below:

Array details
nam_arr[1]=Mike
num_arr[1]=3434
nam_arr[2]=Jack
num_arr[2]=481
nam_arr[3]=Peter
num_arr[3]=12
nam_arr[4]=Alan
num_arr[4]=926
nam_arr[5]=Jacob
num_arr[5]=3423
nam_arr[6]=Dennis
num_arr[6]=123
-----------------------------------------------------------------------
I hope there won't b "MORE" mistakes in this
# 13  
Old 02-27-2007
Yeah, great!
Thank you all!
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. UNIX for Dummies Questions & Answers

Except Script to read data from file

Guys, I ma beginner to shell scripting.I am looking for a script, "read data from file & pass it on bash script output." Looking forward for help on this. (9 Replies)
Discussion started by: Geekris
9 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

read in variable data from another file - grep

Hello! I think this should be an easy solution. I have a large file with many fields of data. The first field has a unique identifier (a subject number) for every record for a chunk of data. Something like this: There were ten experimental conditions (ec), but the ec is identified by only... (11 Replies)
Discussion started by: ccox85
11 Replies

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

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