Need to convert datafeed to html using script

Shell Programming and Scripting
1

Hi All,

I am having datafeed content in CSV format like below. Any help to create a script. I need read the CSV file on loop and update it in html format for web publishing

I want to chage the data using my token based template and save the file out to new csv file

2

I see a conspicuous lack of commas in your comma separated values. I'm assuming it's just an ordinary flatfile?

while read KEYWORD DESC IMAGE PRICE BUYURL
do
cat <<EOF
<h2>${KEYWORD}</h2><p>Price:${PRICE}</p><p><a href="http://www.sit-id.com/"><img src="${IMAGE}"></a></p><p><a href="${BUYURL}"><img src="buynow.jpg"></a></p><p><strong>Product Description</strong></p><p>${DESC}</p><a href="${BUYURL}"> read more..
EOF
done > output
3

Thanks for your replay. Just to update I have datafeed in csv format. I will be having around 15k records. I need to do loop for all 15k row and save the output to another csv file

4

You want your HTML in a CSV file? what? :confused:

Again, that doesn't look like CSV. CSV is comma-separated. It looks more like an ordinary flatfile.