Creating file contents using contents of another file - Page 2 - Shell Programming and Scripting

ReV · #8 02-24-2006

Hi,

I cannot install it because I am not the system admin. And I am using a server from the company. I guess I can't use Ruby.

ReV · #9 02-24-2006

Hi,

I couldn't get the 2nd field into the output file. Can you please advise on how to add the 2nd field and so on?

Quote:

Originally Posted by vino

See the solution in Want to show files on web page

You need to do something similiar.

Something like this

Code:

HEADER='<?xml version="1.0"?>
<!DOCTYPE ALR [
        <!ENTITY gt "&amp;gt;">
        <!ENTITY lt "&amp;lt;">
        <!ENTITY quot "&amp;quot;">
]>
<datafile>
        <info ID="'

function header {

echo "$HEADER" > output.xml
echo "$1" >> output.xml
echo "\">" >> output.xml

}

Parse the country specific details as

Code:

while read line
do
CONTINENT=$(echo "$line" | awk -F, '{ print $1 }')
COUNTRY=$(echo "$line" | awk -F, '{ print $2 }')
.
.

header $ID
done < input.file

where header is the method given above.

vino · #10 02-24-2006

Show us what you have done so far.

vino · #11 02-24-2006

Quote:

Originally Posted by vino

Parse the country specific details as

Code:

while read line
do
CONTINENT=$(echo "$line" | awk -F, '{ print $1 }')
COUNTRY=$(echo "$line" | awk -F, '{ print $2 }')
.
.

header $ID
done < input.file

where header is the method given above.

Would be much better of as

Code:

IFS=","
while read conti country city id
do
CONT=$conti
COUNTRY=$country
CITY=$city
ID=$id
header $ID
done < input.file

ReV · #12 02-24-2006

There are some changes in the requirements of the output file. One more fields needed.
There are also 2 more fields in the input file and the 2nd line is not needed.

This is what I have done:

Code:

#!/bin/ksh

HEADER='<?xml version="1.0"?>
<!DOCTYPE ALR [
        <!ENTITY gt "&amp;gt;">
        <!ENTITY lt "&amp;lt;">
        <!ENTITY quot "&amp;quot;">
]>
<datafile>
        <info ID="'

BODY1='                <info1>'
BODY2='                <info2> </info2>
                <info3>'
BODY3='                <info4>'
BODY4='                <info5>0</info5>
                <info6> </info6>
                <info7> </info7>
                <info8>'
BODY5='                <info9>some fixed data</info9>
                <info10>some fixed data</info10>
                <info11>some fixed data</info11>
        </info>
        <action>
                <attributes>
                        <attributkey id="011" >N</attributkey>
                        <attributkey id="106" >N</attributkey>
                        <attributkey id="114" >N</attributkey>
                        <attributkey id="119" >N</attributkey>
                </attributes>
                <comment> </comment>
        </action>
</datafile>'

INPUTFILE=/home/dir/input.csv
OUTPUTFILE=/home/dir/output.xml

function header {
	echo "$HEADER" > $OUTPUTFILE
	echo "$id" >> $OUTPUTFILE
	echo "\">" >> $OUTPUTFILE
}

function body1 {
	echo "$BODY1" >>$OUTPUTFILE
	echo "$continent" >>$OUTPUTFILE
	echo "</info1>" >>$OUTPUTFILE
}

function body2 {
	echo "$BODY2" >>$OUTPUTFILE
	echo "$country" >>$OUTPUTFILE
	echo "</info3>" >>$OUTPUTFILE
}

function body3 {
	echo "$BODY3" >>$OUTPUTFILE
	echo "$city" >>$OUTPUTFILE
	echo "</info4>" >>$OUTPUTFILE
}

function body4 {
	echo "$BODY4" >>$OUTPUTFILE
	echo "$date" >>$OUTPUTFILE
	echo "</info8>" >>$OUTPUTFILE
}

function body5 {
	echo "$BODY5" >>$OUTPUTFILE
}


IFS=;
while read continent country city id address date
do
	ID=$id
	CONTINENT=$continent
	COUNTRY=$country
	CITY=$city
             DATE=$date
	header $ID
	body1 $CONTINENT
	body2 $COUNTRY
	body3 $CITY
	body4 $DATE
	body5
done < $INPUTFILE

The input file contents:

Code:

continent;country;city,id;address;date
---------;-----------;----------------;----------;---------;--------
asia;japan;tokyo;123;apple road;12012000
europe;germany;munich;456;orange street;13072001
africa;eygpt;cairo;789;banana lane;06121999

vino · #13 02-24-2006

In

Code:

while read continent country city id address date
do
	ID=$id
	CONTINENT=$continent
	COUNTRY=$country
	CITY=$city
             DATE=$date
	header $ID
done < $INPUTFILE

do you know what header $ID means ?

You are invoking the function header with $ID as a parameter.

So inside the header function, this parameter $ID is accessible using the construct $@ or $1 ( anyway you like...)

So in your case, the header function has no idea what $id is. Hence it should be

Code:

function header {
	echo "$HEADER" > $OUTPUTFILE
	echo "$@" >> $OUTPUTFILE
	echo "\">" >> $OUTPUTFILE
}

Likewise, for all the other functions, you should follow suit.

ReV · #14 02-24-2006

Hi,

I have tried with

Code:

function header {
	echo "$HEADER" > $OUTPUTFILE
	echo "$@" >> $OUTPUTFILE
	echo "\">" >> $OUTPUTFILE
}

but the parameters are not parsed from the input to the ouput file. I have the format of the output file without all the parameters.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
How to view the contents of .gz file without extracting the file?	amitkhiare	Shell Programming and Scripting	5	10 Hours Ago 11:29 AM
search for the contents in many file and print that file using shell script	cdfd123	Shell Programming and Scripting	3	10-07-2007 07:17 PM
append file name contents to a target file	gopskrish	UNIX for Dummies Questions & Answers	2	10-27-2006 03:18 AM
Reading specific contents from a file and appending it to another file	dnicky	Shell Programming and Scripting	5	10-04-2005 02:45 AM
ls contents of a file	douknownam	Shell Programming and Scripting	7	06-14-2004 06:29 AM

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