Hi Hanson44 i think he wants some thing like this from his input, commas separated part i have made red colored ones just to make more visibility
and he wants output like this
Hi Friends,
I'm working on a perl script, which seems to be simpler. But I'm very new to PERL scripting.
I have a comma separated data file, from which I need to extract only the seventh field data out of available twenty fields to an array using perl.
Any help would be much appreciated.
... (17 Replies)
Guys,
Need you help, i have a a file content that look like this.
Nokia 3330 <spaces><spaces><more spaces>+76451883874
Nokia 3610 +87467361615
so on and so forth,
- there are so many spaces in between.
- e.g.... (5 Replies)
Hello Mates,
I have one txt file having commo seperated values. I have to insert string "FALSE" in 2nd field from the end. E.G
SE18 6RN,,,,5439070,1786840,,1000002148671600,123434
Out put should be:
SE18 6RN,,,,5439070,1786840,FALSE,1000002148671600,123434
Can some one help me to... (8 Replies)
Hi all,
I have the following files types:
FileA:
100,
23,
33,
FileB:
22,
45,
78,
and i want to make
File C:
100,22
23,45
33,78
any nice suggestions for making it easy. (3 Replies)
Hello there,
I have a comma separated csv , and all the text field is wrapped by double quote. Issue is some text field contain comma as well inside double quote. so it is difficult to process.
Input in the csv file is ,
1,234,"abc,12,gh","GH234TY",34
I need output like below,... (8 Replies)
Hi,
I have a large number of files which are written as csv (comma-separated values).
Does anyone know of simple sed/awk command do achieve this?
Thanks!
---------- Post updated at 10:59 AM ---------- Previous update was at 10:54 AM ----------
Guess I asked this too soon. Found the... (0 Replies)
Hi,
I am having the file with server names & its corresponding process, i need your help how to convert into comma separated output between server & app
#cat apps.txt
Server1
oracle
was
Server2
http
webadmin
Server3
tsm
db2
My requirement is like below.
Server1,oracle/was... (5 Replies)
Hi Experts,
Please support
I have below data in file in comma seperated, but 4th column is containing comma in between numbers, bcz of which when i tried to parse the file the column 6th value(5049641141) is being removed from the file and value(222.82) in column 5 becoming value of column6.
... (3 Replies)
can anyone help me!!!! How to I parse the CSV file
file name : abc.csv (csv file) The above file containing data like
abv,sfs,,hju,',',jkk wff,fst,,rgr,',',rgr ere,edf,erg,',',rgr,rgr I have a requirement like i have to extract different field and assign them into different... (4 Replies)
Discussion started by: J.Jena
4 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)