Splitting csv into 3 tables in html file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Splitting csv into 3 tables in html file
# 8  
Old 07-31-2017
Quote:
Originally Posted by archana25
the above is not working. also i have around 60 columns. cant define for each
So you can't define the size for each field you want (with no explanation of why not), and the code you have isn't working, and you won't give us representative sample input and corresponding desired output. Under these conditions, how do you expect us to help you write software that will produce the output you want?

Please:
  1. explain how you would decide by looking at an input file what width=value should be assigned for a given column of data,
  2. provide a small, representative sample input CSV file (in CODE tags),
  3. provide a corresponding sample output HTML file (in CODE tags) that you want to produce from that sample input CSV file, and
  4. more clearly define how tables in your input CSV files are separated (Do you mean that any line containing a <space> character separates tables? Or, that a line containing only characters in the current locale's space character class separates tables? Or, that an empty line separates tables?)

Last edited by Don Cragun; 07-31-2017 at 12:15 AM..
This User Gave Thanks to Don Cragun For This Post:
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Extract the tables from html

Hi I have a script which extracts the table from HTML and convert it into .csv. But the problem in the script is if we have 2 tables in HTMl . it takes only the first table. Please help me what changes i need to do in the script to make it read the complete HTML page. Script is as below: ... (10 Replies)
Discussion started by: deepti01
10 Replies

2. Shell Programming and Scripting

Read CSV file and delete hdfs, hive and hbase tables

I have a CSV file with hdfs directories, hive tables and hbase tables. 1. first column - hdfs directories 2. second column - hive tables 3. third column - hbase tables I have to check the csv file and look for the first column and delete the hdfs directory from the hdfs path, now... (2 Replies)
Discussion started by: shivamayam
2 Replies

3. Shell Programming and Scripting

Splitting CSV into variables then to XML file

I have a text file that looks like this: FIELD1, FIELD2, THIS IS FIELD3, FIELD4 FIELD1, FIELD2, THIS IS FIELD3, FIELD4 FIELD1, FIELD2, THIS IS FIELD3, FIELD4 I need it to turn it into an XML file to run against a custom application. My ultimate goal is for it to look like... (15 Replies)
Discussion started by: jeffs42885
15 Replies

4. Shell Programming and Scripting

Splitting input CSV file into 3 files

Hi , I am receiving a CSV file that can vary in number of rows each time. I am supposed to split this file into 3 separate files like this: 1. create a file named 'File1.csv' that will contain first 3 rows of the input file 2. create file named 'File2.csv' that will contain last 3 rows of the... (7 Replies)
Discussion started by: kedrick
7 Replies

5. Shell Programming and Scripting

Script to convert CSV file to HTML

Hi, I have made a a script which creates a csv file as daily database report However i want to covert that csv file to html because csv file does not have a good visibilty. So it is possible to have such csv to html coversion script. Your prompt help much appreciated. Thanks in advance (4 Replies)
Discussion started by: sv0081493
4 Replies

6. UNIX for Advanced & Expert Users

Splitting the single csv file

Hi, I have a requiement where in i will get a single file but there will be mutiple headers. Suppose say for eg: Header1 Data... Data... Header2 Data.. Data.. Header3 Data.. Data.. I want to split each with the corresponding data into a single file. Please let me know how... (1 Reply)
Discussion started by: weknowd
1 Replies

7. UNIX and Linux Applications

Does anybody know how to store my tables to a csv file?

Hi I'm using an oracle database... Lets call it databasename My username and password are the same .... lets all that andrea/andrea So I want to write a script to copy all the data from my table called tablename and store that data to a csv file called filename. I cant seem to get... (2 Replies)
Discussion started by: ladyAnne
2 Replies

8. UNIX for Dummies Questions & Answers

convert csv to html file

Hi All, I am new to this forum,not sure where to post this query...so posted here Kindly need any of your help on the below ------------ I am using shell scripting and trying to convert a csv file to html file... example.csv --------------- Name Country Age Sex Andy India 25 ... (4 Replies)
Discussion started by: sumithra
4 Replies

9. Shell Programming and Scripting

help with splitting a html file up

hi i have a file called t.txt <p>The mayor is <a href="javascript:popupPerso('FichePersonnage.php?login=Yvaine')">Yvaine</a></p><p>The mentor is <a href="javascript:popupPerso(' FichePersonnage.php?login=Chaselambourne')">Chaselambourne</a></p>List of the villagers :<br><div id="Layer1"... (3 Replies)
Discussion started by: jeroen234
3 Replies
Login or Register to Ask a Question