Shell Programming and Scripting

Hi All,

I am having csv datafeed file. I need to update the information in html template which has token.

For eg

Datafeed File

Code:

column1,   column2, column3,column4,column5
data1        data2       data3      data4      data5

Html File

Code:

<h2>column1</h2>
<h2>column2</h2>
<h2>column3</h2>
<h2>column4</h2>
<h2>column5</h2>

Out_put Needed

Code:

<h2>data1</h2>
<h2>data2</h2>
<h2>data3</h2>
<h2>data4</h2>
<h2>data5</h2>

Moderator's Comments:

edit by bakunin: Please view this code tag video for how to use code tags when posting code and data - as you have been told when you opened this thread.

I don't understand what you want. Are you saying that if fields are separated by a combination of spaces and commas that line is to be written to a file named Html File, but input lines that have fields that are separated by one or more spaces are to be written to a file named Out_put Needed?

I need the use sed and replace the html file where token is there with datafeed content in csv.

ranjancom2000,
Please look at the 1st posting in this thread again. There is one input file named Datafeed File and two output files named Html file and Out_put Needed. What are the rules for determining the name of the output file to be produced based on looking at a line from your input file?

Unless this is a homework item, why is sed the only available tool?

Why are you saying that your input file is a CSV file when you are using any combination of one or more spaces and commas as field separators? (Especially note that there are no commas in your second input line.) IfDatafeed File was really a CSV file, the output would be something more like:

Code:

<h2>column1</h2>
<h2>   column2</h2>
<h2> column3</h2>
<h2>column4</h2>
<h2>column5</h2>
<h2>data1        data2       data3      data4      data5</h2>

No i have one source file I need the create multiple html file replace the token with sed command

Out_put Needed

I have datafeed with 30K products. So it need to create 30k html.pages

ranjancom2000,
We seem to have a language barrier. Since I can't figure out what you want to be considered field separators and I can't figure out how you want to name the 30,000 files that you want produced, I won't be able to help you.

I hope someone else in this forum will be able to help you find a solution to your problem.

- Don

PS Note that using QUOTE tags instead of CODE tags only serves to hide information from people trying to help you.

Also note that creating 30,000 files in a single directory is likely to produce very long lookups on many types of filesystems.