Reading text from a file

LiquidChild · #1 (**permalink**) 05-09-2007

Guys,

I am trying to read text from a file, into arrays.

The format of the file is:

@DATABASE
femotest
@PACKAGE_SPECS
/usr/home/oracle92/sosa/scripts/test.pks
/usr/home/oracle92/sosa/scripts/rep.pks
@PACKAGE_BODIES
/usr/home/oracle92/sosa/scripts/rep.pkb
@PROCEDURES
@FUNCTIONS
@TRIGGERS
@VIEWS
@SQL_SCRIPTS

Where there can be any number of lines between each entry, I want to read these all into seperate arrays and a single variable for the database sid. I know how to grep for particular parts in the file, but its more getting the lines between them, could anyone give me some suggestions on how this can be done?

Again thanks.

aigles · #2 (**permalink**) 05-09-2007

The following script read all data into arrays (array name is entry name minus @) :

Code:

# Read alle ntries into arrays

entry=GARBAGE
while read record
do
   case "$record" in
      @*) entry=`expr substr "$record" 2 9999` ;;
      *) eval ${entry}[\${#${entry}[*]}]='$record' ;;
   esac
done < input_file

# Display arrays content

for array in DATABASE PACKAGE_SPECS PACKAGE_BODIES PROCEDURES FUNCTIONS TRIGGERS VIEWS SQL_SCRIPTS
do
   eval count=\${#${array}[*]}
   if [ $count -eq 0 ]
   then
      echo "${array} -> Empty"    
   else
      i=0
      while [ $i -lt $count ]
      do
         eval echo \"${array}[${i}]=\${${array}[${i}]}\"
         i=`expr $i + 1`
      done
   fi
done

Inputfile :

Code:

@DATABASE
femotest
@PACKAGE_SPECS
/usr/home/oracle92/sosa/scripts/test.pks
/usr/home/oracle92/sosa/scripts/rep.pks
@PACKAGE_BODIES
/usr/home/oracle92/sosa/scripts/rep.pkb
@PROCEDURES
procedure 1
procedure 2
@FUNCTIONS
function 1
function 2
@TRIGGERS
trigger 1
@VIEWS
view 1
view 2
@SQL_SCRIPTS
sql 1
sql 2
sql 3

Output:

Code:

DATABASE[0]=femotest
PACKAGE_SPECS[0]=/usr/home/oracle92/sosa/scripts/test.pks
PACKAGE_SPECS[1]=/usr/home/oracle92/sosa/scripts/rep.pks
PACKAGE_BODIES[0]=/usr/home/oracle92/sosa/scripts/rep.pkb
PROCEDURES[0]=procedure 1
PROCEDURES[1]=procedure 2
FUNCTIONS[0]=function 1
FUNCTIONS[1]=function 2
TRIGGERS[0]=trigger 1
VIEWS[0]=view 1
VIEWS[1]=view 2
SQL_SCRIPTS[0]=sql 1
SQL_SCRIPTS[1]=sql 2
SQL_SCRIPTS[2]=sql 3

Note: Leading and trailing spaces are not preserved.
If you want to keep them, try :

Code:

while IFS='' read record

Jean-Pierre.

LiquidChild · #3 (**permalink**) 05-09-2007

Thanks very much aigles I didn't expect the full solution posted.

LiquidChild · #4 (**permalink**) 05-09-2007

Aigles

Could you explain this section a little further?

*) eval ${entry}[\${#${entry}[*]}]='$record' ;;

and tbh the second line i am kinda lost with.

-- Edit, figured the first line out, i think!

Actually think i have figured them both out, thanks!

aigles · #5 (**permalink**) 05-09-2007

*) ... ;;
Default case -> line doesn't start with @ -> Entry data
*) eval ${entry}[\${#${entry}[*]}]='$record' ;;
Generate and execute array assigment.
For example : FUNCTIONS[${#FUNCTIONS[*]}='input line'
${#FUNCTIONS[*]} is the actual number of elements of the array. Since the index of array start with 0, it's also the value of the next array element.

Jean-Pierre.

LiquidChild · #6 (**permalink**) 05-10-2007

I have put the following:

readReleaseFile()
{
#Reads the contents of the release file

#Populate the arrays as required
init

entry=

while read record
do
case $record in
@*) entry=`expr substr $record 2 999`;;
*) eval ${entry}[\${#${entry}[*]}]=$record;;
esac
done < $releaseFile
}

But when I run it I get an error:

expr: syntax error
./release.sh[16]: [${#[*]}]=femotest: bad substitution

I know why the second line is giving the error, but the expr: syntax error I am not sure about.

I have also tried:

@*) entry=`expr substr "$record" 2 999`;;

Anyone know what syntax is wrong here?

Thanks

aigles · #7 (**permalink**) 05-10-2007

Quote:

expr: syntax error
./release.sh[16]: [${#[*]}]=femotest: bad substitution

This portion of code is generated by the eval command :

Code:

*) eval ${entry}[\${#${entry}[*]}]='$record' ;;

Looks like variable entry not assigned.

Initialize entry with a GARBAGE value to catch lines found before an @ entry.
Code:
```
entry=GARBAGE
while read record
do
```
the syntax of the expr command seems valid.
Add a trace option in the readReleaseFile function, that will permit to see the expr command that is executed.
Code:
```
readReleaseFile()
{
   set -x
```

Jean-Pierre.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Reading a binary file in text or ASCII format	Nagendra	High Level Programming	3	12-03-2008 06:11 PM
Reading a mailbox and sending new messages to a text file	rsw626	Shell Programming and Scripting	1	04-17-2008 01:35 PM
Help with reading text file	bilal05	UNIX for Dummies Questions & Answers	1	04-12-2008 03:46 PM
Reading from Text file.....	user__user3110	Shell Programming and Scripting	0	04-11-2008 05:18 AM
reading text file	jaan	Shell Programming and Scripting	1	02-16-2004 08:43 AM

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