12-06-2012
Wow, that's cool
I guess I can pipe to sed and do the magic now
Many thanks for your help !
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi !!
I have HTML Tables through which i want to generate graphs, but for creating graphs i need the file in CSV format so can anyone can please help me in how can i convert my HTML table file to CSV format.
Thanks in Advance (2 Replies)
Discussion started by: i_priyank
2 Replies
2. UNIX for Dummies Questions & Answers
hello.
I'm somewhat a novice here so please be patient. My stumbling block when loading csvs into ORACLE tables is this:
I need to read a csv datafile, check several fields in each line, and if any of stated fields contain A ZERO only then replace it with a null/blank character.
I had a... (9 Replies)
Discussion started by: MrCarter
9 Replies
3. Shell Programming and Scripting
I've googled a lot on this, but could not fine a simple one-liner to do this.
I have a .csv file that looks like this:
Header one
Header two
Header three
col1,col2,col3
short data, very long data, dataIf I use sed and change the comma to tab, being the colums of variable length I don't get a... (6 Replies)
Discussion started by: ahsog
6 Replies
4. Shell Programming and Scripting
HI,
Please find the text below. I receive a .csv file on server. I need the comma(,) in the second column to be replaced by a semi-colon( ; ).
How to do it. Please help.
Sample text:
"1","lastname1,firstname1","xxxxxx","19/10/2009","23/10/2009","0","N","Leave"... (2 Replies)
Discussion started by: libin4u2000
2 Replies
5. Shell Programming and Scripting
Hi All,
Please give me the solution to the following ASAP.
1) Converting the .xls into .csv
Script i tried,
mv hello.xls hello.csv
The above given script converting the .xls file into .csv successfully. But after i run the below unix command I am no able to open the .csv file, its giving... (4 Replies)
Discussion started by: velava
4 Replies
6. UNIX for Dummies Questions & Answers
Hi
I need to write a bash script to take the data stored in 3 oracle tables .. and filter them and store the results in a csv file.
It is an Oracle database
Thank you (1 Reply)
Discussion started by: ladyAnne
1 Replies
7. Shell Programming and Scripting
Hi there,
i have a file like that in attachment (PLEVA3_280711_SAP.txt), i would extract some basic information from it and report in a new file or table like this:
i try to use bash and i extract the single object in this way (see attach scriptino.sh), but i receive a strange... (5 Replies)
Discussion started by: alen192
5 Replies
8. UNIX for Dummies Questions & Answers
Hi !
I have input.tab with one column containing Item IDs under a number format (the second column is the Location of this item):
Location Item ID
rack1 12; 35; 43
rack35 23; 894; 5478; 98
etc...
(The number of Items per row is variable. Item IDs in a same field are... (17 Replies)
Discussion started by: lucasvs
17 Replies
9. Shell Programming and Scripting
i want to run update query for oracle which is in up.sql taking values from a.csv.
I have implemented shell script to do it.
extn="perl"
ls -1 | while read file
do
echo "$file,$extn" > a.csv
done
up.sql contains
update file_list set filename=$1 where extn=$2;
The code to update is... (2 Replies)
Discussion started by: millan
2 Replies
10. UNIX for Beginners Questions & Answers
I have a source csv file consists of first field as variable name, and the rest are site-specific information (converted from excel file, where site -specific values in columns). I am trying to create a file for every site using a template and replace the multiple variables with values from the... (3 Replies)
Discussion started by: apalex
3 Replies
LEARN ABOUT DEBIAN
cfront
fileutil::magic::cfront(3tcl) file utilities fileutil::magic::cfront(3tcl)
__________________________________________________________________________________________________________________________________________________
NAME
fileutil::magic::cfront - Generator core for compiler of magic(5) files
SYNOPSIS
package require Tcl 8.4
package require fileutil::magic::cfront ?1.0?
package require fileutil::magic::cgen ?1.0?
package require fileutil::magic::rt ?1.0?
package require struct::list
package require fileutil
::fileutil::magic::cfront::compile path...
::fileutil::magic::cfront::procdef procname path...
::fileutil::magic::cfront::install path...
_________________________________________________________________
DESCRIPTION
This package provides the frontend of a compiler of magic(5) files into recognizers based on the fileutil::magic::rt recognizer runtime
package. For the generator backed used by this compiler see the package fileutil::magic::cgen.
COMMANDS
::fileutil::magic::cfront::compile path...
This command takes the paths of one or more files and directories and compiles all the files, and the files in all the directories
into a single recognizer for all the file types specified in these files.
All the files have to be in the format specified by magic(5).
The result of the command is a Tcl script containing the generated recognizer.
::fileutil::magic::cfront::procdef procname path...
This command behaves like ::fileutil::magic::cfront::compile with regard to the specified path arguments, then wraps the resulting
recognizer script into a procedure named procname, puts code setting up the namespace of procname in front, and returns the result-
ing script.
::fileutil::magic::cfront::install path...
This command uses ::fileutil::magic::cfront::procdef to compile each of the paths into a recognizer procedure and installs the
result in the current interpreter.
The name of each new procedure is derived from the name of the file/directory used in its creation, with file/directory "FOO" caus-
ing the creation of procedure ::fileutil::magic::/FOO::run.
BUGS, IDEAS, FEEDBACK
This document, and the package it describes, will undoubtedly contain bugs and other problems. Please report such in the category fileutil
:: magic of the Tcllib SF Trackers [http://sourceforge.net/tracker/?group_id=12883]. Please also report any ideas for enhancements you may
have for either package and/or documentation.
SEE ALSO
file(1), fileutil, magic(5)
KEYWORDS
file recognition, file type, file utilities, mime, type
CATEGORY
Programming tools
fumagic 1.0 fileutil::magic::cfront(3tcl)