08-23-2006
that is not giving me a result
can this be a solutions
sed 's/[ ]"//g' filename > newfile
since i am directly dealing with file, so all string which is with in " should be replace by null
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
I'm trying to write a ksh script to parse a file. When the "\" character is encountered, it should be removed and the next line should be concatenated with the current line. For example...
this is a test
line #1\
should be concatenated with line #2\
and line number 3
when this... (3 Replies)
Discussion started by: newbie_coder
3 Replies
2. Solaris
Hi all,
I have created a volume for the root device as d0 and the sub mirror for same is d10.
the output from metastat d0 is as below
I want to clear these volume , as i cant unmount the "/ " file system , please suggest as how can i clear this. Also the required entries are there... (2 Replies)
Discussion started by: kumarmani
2 Replies
3. Shell Programming and Scripting
I have the Unix XML file as below:
<?xml version="1.0" encoding="UTF-8"?>
<ReportData version="1.0"><DisplayName>Non-Agency CMO Daily Trade Recap - Hybrids</DisplayName><ReportType>MgmtTradingReport</ReportType><Description>Management Trading... (7 Replies)
Discussion started by: mohsin.quazi
7 Replies
4. Shell Programming and Scripting
Hi,
I have line in input file as below:
3G_CENTRAL;INDONESIA_(M)_TELKOMSEL;SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL
My expected output for line in the file must be :
"1-Radon1-cMOC_deg"|"LDIndex"|"3G_CENTRAL|INDONESIA_(M)_TELKOMSEL"|LAST|"SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL"
Can someone... (7 Replies)
Discussion started by: shis100
7 Replies
5. Shell Programming and Scripting
Hi -
I'm having a problem with hidden characters on Linux. When I produced an output from Oracle database, there is a an extra "Hidden Character" included on the output. How can I remove that character? See below:
The extra dollar sign is creating a new line on my .csv output file. I... (16 Replies)
Discussion started by: Jin_
16 Replies
6. Shell Programming and Scripting
Hi,
I have csv file with records as below. Now i have remove any comma in the filed value because that creates problem when i feed this file to an application.
for example below are two sample records, the second record have a comma in "Salesforce.com, Inc." field, now i have to remove this... (13 Replies)
Discussion started by: anaga
13 Replies
7. Shell Programming and Scripting
Hello All,
I have an Expect script that ssh's to a remote server and runs some commands before exiting.
One of the commands I run is the "hostname" Command. After I run this command I save the output
using this line in the code below...
Basically it executes the hostname command, then I... (2 Replies)
Discussion started by: mrm5102
2 Replies
8. Shell Programming and Scripting
Hi folks,
I have a log file in the below format and trying to get the output of the unique ones based on mnemonic IN PERL.
Could any one please let me know with the code and the logic ?
Severity Mnemonic Log Message
7 CLI_SCHEDULER Logfile for scheduled CLI... (3 Replies)
Discussion started by: scriptscript
3 Replies
9. UNIX for Dummies Questions & Answers
Hi I have a file in which the last characters are ' and space, i.e
Code
====
abcn'
jkdjf
dkfjd'
Here in the above code, 1st line is having the comma as the last character and in the 2nd line space is the last character, I want to delete these character if it is there.
Please guide me... (5 Replies)
Discussion started by: Pramod_009
5 Replies
10. Shell Programming and Scripting
Hello !
I'm quite new to linux but haven't found a script to do this task, unfortunately my knowledge is quite limited on shellscripts...
Could you guys help me removing the duplicate lines of a file, based only on a single "column"?
For example:
M202034357;01/2008;J30RJ021;Ciclo 01... (4 Replies)
Discussion started by: Rufinofr
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)