hello...
i have a requirement to convert a xls file to csv in RHEL 6.5 and ftp it to a windows location.
i am using xls2csv utility to convert the file in linux.
Input xls file attached...
I have used below commands to convert the file to csv:
And,
The issue i am facing is after conversion, an empty line is adding everytime and it contains only "^L"
To remove this control-L i tried below sed command...the output looks fine.
sed 's/^L//g' test.csv
But when I am redirecting this output to another csv file for example test2.csv, ^L appears again.
Hello,
I have many csv file, but I would like to delete lines with some values in a column conditionally.
My example look like this,
ex1e, ex2g, ex39, pasg, ssg, mrlc, pc, kb, coop
-112, -53, -177, 64, 62, 71, 1, 487, 20
-101, -61, -53, 0, 32767, 51, 0, ... (6 Replies)
I am trying to remove the ita from this file:
"1234ita","john","smith"
"56789ita","jim","thomas"
the command i am using is:
sed '/^ita/d' infile.csv > outfile.csv
it is running but doing nothing, very rarely use sed so trying to learn it any help would be appreciated (2 Replies)
Hi,
I need help to remove blank rows at the end of file.
Sample data:
"Oslo, Symra kino",Oslo,130-7,Symra 1,130-7-91
"Tønsberg, Brygga Kino SF",Tønsberg,202-1,Tønsberg SF 4,202-1-4
,,,,
,,,,
,,,,
,,,,
Expected data:
"Oslo, Symra kino",Oslo,130-7,Symra 1,130-7-91
"Tønsberg, Brygga... (6 Replies)
Hi Experts,
My requirement is to read the csv file and need to remove if any line break in it.
sample data:
Row1: "Oslo, Symra kino",Oslo,130-7,Symra 1,130-7-91
Row2:"Tønsberg, Brygga Kino SF",Tønsberg,202-1,
Tønsberg SF 4,202-1-4
Expected data:
Row1: "Oslo, Symra... (6 Replies)
Hi All
A .csv file containing multiple value on it. i need to remove some value from it. Please advise how can i find multiple value from that and remove itself. Please provide solution for this.
Thanks in advance. (4 Replies)
Hi friends,
I am running one SQL though .sh file and in output I am seeing newline whevnever There is a new line in column.
I WANT TO REMOVE NEWLINE IN OUTPUT FILE.
Present out put in Column:
-------------------------
Hi
How
Are
You.
Required output in Column:
-------------
Hi How... (4 Replies)
Dear All,
I have 2 CSV files and want to create a new CSV based on a common value in both of the CSV file.
ColumnA ColumnB ColumnC
Client 1 XXXXX Server A
Client 2 XXXXX Server B
Client 3 XXXXX Server C
2nd CSV file
ColumnA CloumnB
Server A value... (14 Replies)
Hi All ,
I am facing a small challenge i need unix command to remove space as well as replace "|" to "," in a csv file .
original file :
A | B | c | D
E | F | G | H
I | J | K | L
P | M | N | O
Expected o/p:
A,B,c,D
E,F,G,H
I,J,K,L
P,M,N,O (4 Replies)
I found that the following works to remove the first column in my file when my CSV is delimited with a simple comma:
sed -i 's/*,//' file.csv
However, I have a new file where the fields are encapsulated with double quotes - general example of file:
"Internal ID", "External ID", "Name"... (8 Replies)
how to remove unwanted commas from a .csv file
Input file format
"Server1","server-PRI-Windows","PRI-VC01","Microsoft Windows Server 2012, (64-bit)","Powered On","1,696.12","server-GEN-SFCHT2-VMS-R013,server-GEN-SFCHT2-VMS-R031,server-GEN-SFCHT2-VMS-R023"... (5 Replies)
Discussion started by: ranjancom2000
5 Replies
LEARN ABOUT DEBIAN
chartex
CHARTEX(1p) User Contributed Perl Documentation CHARTEX(1p)NAME
chartex - A utility to extract charts from an Excel file for insertion into a Spreadsheet::WriteExcel file.
DESCRIPTION
This program is used for extracting one or more charts from an Excel file in binary format. The charts can then be included in a
"Spreadsheet::WriteExcel" file.
See the "add_chart_ext()" section of the Spreadsheet::WriteExcel documentation for more details.
SYNOPSIS
chartex [--chartname --help --man] file.xls
Options:
--chartname -c The root name for the extracted charts,
defaults to "chart".
OPTIONS --chartname or -c
This sets the root name for the extracted charts, defaults to "chart". For example:
$ chartex file.xls
Extracting "Chart1" to chart01.bin
$ chartex -c mychart file.xls
Extracting "Chart1" to mychart01.bin
--help or -h
Print a brief help message and exits.
--man or -m
Prints the manual page and exits.
AUTHOR
John McNamara jmcnamara@cpan.org
VERSION
Version 0.02.
COPYRIGHT
X MMV, John McNamara.
All Rights Reserved. This program is free software. It may be used, redistributed and/or modified under the same terms as Perl itself.
perl v5.10.1 2009-11-29 CHARTEX(1p)