Read from data file

fongthai · #1 (**permalink**) 02-26-2007

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 ?

sb008 · #2 (**permalink**) 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

fongthai · #3 (**permalink**) 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?

dennis.jacob · #4 (**permalink**) 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

dennis.jacob · #5 (**permalink**) 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

fongthai · #6 (**permalink**) 02-27-2007

It works!
Thank jacoden and sb008!

fongthai · #7 (**permalink**) 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.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Help required with a Csh script to read data from a file	fizzme	Shell Programming and Scripting	1	05-29-2008 07:30 PM
Need to read data from a file (cut/awk)	rejirajraghav	Shell Programming and Scripting	1	04-29-2008 03:13 PM
Post Shell programming: Question about source a file and read data from the file	ccwq	Shell Programming and Scripting	3	08-04-2007 10:28 PM
read/writte/input data in file.	dorek	Shell Programming and Scripting	0	06-22-2006 07:31 AM
Read data from a file into a variable	yorkdg	Shell Programming and Scripting	2	12-09-2004 05:29 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread: