csv to table one-liner Post: 302317385

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

merging CSV data using a one liner from shell?

I'm trying to merge multiple CSV (comma separated value) files into one large master file. All files have a field that is unique to act as the key for entry/merging into the master file & and all files have the same number of fields that are in the master file. I'll give an example here: ...

2. Shell Programming and Scripting

HTML table to CSV

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

3. Shell Programming and Scripting

Store table contents in csv file

I need to write a script to store the contents of a table in a csv file I'm using Toad, it's a Oracle database.

4. UNIX for Dummies Questions & Answers

Storing data from a table into a csv file

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

5. Shell Programming and Scripting

creating a csv file from this 1 liner?

I'm trying to create a csv file by running awk and sed on a number of xml files in a directory; I'm using this below: hostname; grep "BuildDate" /dir/ABCD/configuration/*/*.xml | awk -F"/" '{ print $5 }' > /tmp/tempfile.txt; grep "BuildDate" /dir/ABCD/configuration/*/*.xml | awk -F\" '{ print $2...

6. Shell Programming and Scripting

Search & Replace regex Perl one liner to AWK one liner

Thanks for giving your time and effort to answer questions and helping newbies like me understand awk. I have a huge file, millions of lines, so perl takes quite a bit of time, I'd like to convert these perl one liners to awk. Basically I'd like all lines with ISA sandwiched between...

7. Shell Programming and Scripting

Convert file in csv or table

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...

8. Shell Programming and Scripting

Find and replace variables using a csv table

I have a flat file (template) where I want to replace variables based upon a value in another file (csv). The variables in the template are named %VAR_X_z% The values are in the csv file and X is field 0 of each line and y field 1 and up. Example of the csv: Badidas, 13.00, 12.00, 11.00,...

9. Shell Programming and Scripting

Update the table using values from a csv file

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...

10. UNIX for Beginners Questions & Answers

Plain text table to csv problems

I´m trying to input a plain text table and I want to output a csv file with semicolon field separator. I have some problems with the \r and the fields with more of one line.. Some gnu util to do this without problems or awk solution? I´m attaching the original plain table file and the needed...

LEARN ABOUT HPUX

icecream

ICECREAM(1)							     icecream							       ICECREAM(1)

NAME

       icecream - download icecast and shoutcast streams, redirecting all fetched content to stdout and/or to disk at the same time

SYNOPSIS

       icecream [OPTIONS] URL [URL..]

DESCRIPTION

       icecream is a lightweight, non-interactive, stream download utility.  It connects to icecast and shoutcast servers or direct stream URLs,
       and redirects all fetched content to stdout and/or to media files on your disk.

       Listen to the stream piping the output to a stdin-capable media player.	Save the stream to a named file or split it into different tracks.
       It is possible to redirect the stream and save it to disk at the same time.

       icecream is able to parse pls and m3u playlists, and to download mp3 and ogg direct stream URLs. If the stream is anonymous it will be
       saved as 'stream-time.mp3', where time is actual timestamp.

OPTIONS

       -h, --help
	       Print a help message describing all options

       -q, --quiet
	       Turn off output

       -v, --verbose
	       Be verbose

       -t, --tracks
	       Split stream into tracks (if possible)

       --name=NAME
	       Save the stream to file specified by NAME. Format codes starting with "%" will be replaced. See the date command for valid format
	       codes.

       --stop=N[units]
	       Stop downloading the stream after N kb/mb/min/songs

       --user-agent=AGENT
	       Set user-agent header to AGENT

       --stdout
	       Output stream to stdout (implies -q)

       --sync  Turn syncing on, required for some mpeg players that read from stdin

       --debug Turn on debugging outputs

EXAMPLES

       Streaming to mpg123
	       icecream --stdout http://radio.com/playlist.pls | mpg123 -

       Split stream into different tracks
	       icecream -t http://metal.org/radio.pls

       Split stream into tracks and play with vlc at the same time
	       icecream -t --stdout http://streaming.com/playlist.pls | vlc file:/dev/stdin

       Prepare a 74 minute CD
	       icecream -t --stop 74min http://trace.net/playlist.m3u

       Use a filename with today's date as output
	       icecream -q --name 'radio_%Y_%m_%d' --stop 60min http://radio.com/playlist.pls

BUGS

       You are welcome to send bug reports about icecream to our mailing list.	Feel free to visit http://icecream.sourceforge.net

AUTHOR

       Written by Gil Megidish <gil at megidish.net>

1.3								    2008-04-28							       ICECREAM(1)