Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Read from data file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Read from data file
# 1  
Old 02-26-2007
Read from data file
Hi,
I have a data file formatted like this:
[Name] [Number]

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[i] and Numbers[i]
Like this:
Code:
for i in 0 1 2 3 
do
   echo $Names[$i]
   echo $Numbers[$i]
done

Can anyone help ?
# 2  
Old 02-26-2007
Code:
#!/usr/bin/ksh

# reading content of file into arrays
INDEX=0
while read NAMES[${INDEX}] NUMBERS[${INDEX}]
do
  ((INDEX=$INDEX+1))
done < <inputfile>

#displaying values in each array
for NAME in ${NAMES[@]}
do
  echo ${NAME}
done

for NUMBER in ${NUMBERS[@]}
do
  echo ${NUMBER}
done

This User Gave Thanks to sb008 For This Post:
dude_me5
# 3  
Old 02-27-2007
Hi,
How about read the content into arrays, I can use awk to read it content by column
But the challenge is how to declare array NAMES and NUMBERS,
Can you show me the way?
# 4  
Old 02-27-2007
Give a try on this...

#!/bin/bash
for i in $(awk -F" " '{print NR}' new)
do
nam_arr[$i]=$(awk -F" " -v cnter=$i '{ if (cnter == NR) {print $1;} }' new)
num_arr[$i]=$(awk -F" " -v cnter=$i '{ if (cnter == NR) {print $2;} }' new)
done
# 5  
Old 02-27-2007
In my perv post, nam_arr[<index>] and num_arr[<index>] are Arrays!!!Hope this is what you need...
And 'new' is the file which contain the data
# 6  
Old 02-27-2007
It works!
Thank jacoden and sb008!
# 7  
Old 02-27-2007
Hi jacoden,

I have one questions:
Data file may contain empty lines or un-used lines (start with "#" character). Can we exclude them from the arrays.
Last edited by fongthai; 02-27-2007 at 03:09 AM..
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