|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Parsing txt, xml files and preparing csv file
Post 302500630 by ctsgnb on Tuesday 1st of March 2011 06:00:10 AM
03-01-2011
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
HI guys,
I have created a script to read 1 column in a csv file and then place it in text file.
However, when i checked out the text file, it is not in a column format...
Example:
CSV file contains
name,age
aa,11
bb,22
cc,33
After using awk to get first column
TXT file... (1 Reply)
Discussion started by: mdap
1 Replies
2. Shell Programming and Scripting
I have been trying to find a good solution for this seemingly simple task for 2 days, and I'm giving up and posting a thread. I hope someone can help me out!
I'm on HPUX, using sqlplus, mailx, awk, have some other tools available, but can't install stuff that isn't already in place (without a... (6 Replies)
Discussion started by: soldstatic
6 Replies
3. Shell Programming and Scripting
hi everyone,
i am a newbie in shell programming. and i want to simply go through a text file that contains 3 "columns", split by ';'
customerID ; link-to-contract ; save-as-filename
so an example would simply look like this
now i want to loop through every line, and save the file from... (3 Replies)
Discussion started by: Confidence
3 Replies
4. Shell Programming and Scripting
EDIT: My problems have been solved thanks to the help of bartus11 and pravin27
This code is just to help me learn. It serves no purpose other than that.
Here's a sample csv that I'm working with -
#listofpeeps.csv
Jackie Chan,1954,M
Chuck Norris,1930,M
Bruce Lee,1940,M
This code is... (13 Replies)
Discussion started by: chickeneaterguy
13 Replies
5. Shell Programming and Scripting
Hi there,
I have files (tsv) like this:
CTLPort IO Rate(IOPS) Read Hit(%) Write Hit(%) Timestamp
0A 136 97 100 09:36:48
0B 3 100 100 09:36:48
0C 88 35 100 09:36:48
0A 87 100 100 09:37:49
0B 3 97 100 09:37:49
0C 83 45 100 09:37:49
0A 108 83 100 09:38:48
0B 3 100 100 09:38:48... (1 Reply)
Discussion started by: gray380
1 Replies
6. UNIX for Dummies Questions & Answers
Hi all,
I am new to unix and even newer to XML :wall:
I have a dataset which I need to work on and extract data from but I cant even see things. its a XML file which i need to analyse and return the results in xml as well but need to filter some of them like i would do with excel file so not... (7 Replies)
Discussion started by: A-V
7 Replies
7. Shell Programming and Scripting
I am trying to parse the XML Google contact file using tools like xmllint and I even dived into the XSL Style Sheets using xsltproc but I get nowhere.
I can not supply any sample file as it contains private data but you can download your own contacts using this script:
#!/bin/sh
# imports... (9 Replies)
Discussion started by: ripat
9 Replies
8. UNIX for Dummies Questions & Answers
Hi,
I need to create a .csv file from information that i have in two different tab delimited .txt file. I just want to select some of the columns of each .txt file and paste them into a .cvs file.
My files look like:
File 1
transcript_id Seq. Description Seq. Length ... (2 Replies)
Discussion started by: alisrpp
2 Replies
9. Shell Programming and Scripting
I want to search for all the xml files on the server that have "Status" in them. Is this the correct code that I should use? Can anyone explain exactually what this code does?
xmlFileNames=$(find . -name "*.xml" -exec grep -l ".*Status" {} \; 2>/dev/null) (9 Replies)
Discussion started by: emc^24sho
9 Replies
10. Windows & DOS: Issues & Discussions
I have a requirement to parse a dataflex .txt file and break it into separate files within the Windows server env. Is there any special characters I should pay particular attention on the unix side? Any ideas?
Thanks in advance (2 Replies)
Discussion started by: kicklinr
2 Replies
LEARN ABOUT DEBIAN
xlhtml
xlhtml(1) General Commands Manual xlhtml(1) NAME
xlhtml - A program for converting Microsoft Excel Files .xls SYNOPSIS
xlhtml [-a] [-asc] [-csv] [-xml] [-bcNNNNNN] [-bi/path] [-c] [-dp] [-v] [-fw] [-m] [-nc] [-nh] [-tcNNNNNN] [-te] [-xc:N-N] [-xp:N] [-xr:N- N] FILE DESCRIPTION
This manual page explains the xlhtml program. The program xlhtml is used to convert Microsoft Excel Spreadsheet files into either html or tab delimitted ASCII. The program can be interfaced with helper scripts for viewing email attachments. Most use of this program is through the helper scripts and one would probably rarely resort to using the commandline interface. OPTIONS
-a aggressively optimize html by removing </TR> </TD> or VALIGN="bottom". Some older browsers may not display properly in this mode. -asc Ascii out of -dp and extraction data (-xc, -xp, -xr) -csv Output in Comma Separated Values of -dp and extraction data (-xc, -xp, -xr) -xml Output in XML of -dp and extraction data (-xc, -xp, -xr) -bc Override the background color. e.g. -bc808080 for gray -bi Use background image. e.g. -bi/home/httpd/icon/tar.gif -c Centers the tables horizontally -dp Dump page count and max columns and rows per page -v Prints program version -fw suppress formula warnings about accuracy -m No encoding for multibyte -nc tells it not to colorize the output. -nh Suppress header and body tags in html output -tc Override the text color. e.g. -tcFF0000 for red -te Trims empty rows & columns at the edges of a worksheet -xc Columns (separated by a dash) for extraction (zero based) -xp Page for extraction (zero based), one page only -xr Rows (separated by a dash) to be extracted (zero based) An example of the extraction command line is: xlhtml -fw -asc -xp:0 -xr:2-6 -xc:0-1 Test.xls The extraction output is: Formatted output of cells by column left to right, columns separated by a tab, end of row is: 0x0A, end of file: AUTHOR
Steve Grubb, Charles N Wyble xlhtml May 15, 2002 xlhtml(1)