08-24-2011
Best place to start/learn
www.grymoire.com/Unix/Awk.html
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have a text file say file1 having data like
ABC c:/hm/new1 Dir
DEF d:/ner/d sd
......
So i want to make a table from this text file, is it possible to do it using perl.
Thanks in advance
Sarbjit (1 Reply)
Discussion started by: sarbjit
1 Replies
2. Shell Programming and Scripting
Hi ,
i want to change this question, i will post soon.. (6 Replies)
Discussion started by: srikanth2567
6 Replies
3. Shell Programming and Scripting
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. (5 Replies)
Discussion started by: ladyAnne
5 Replies
4. 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
5. 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
6. Shell Programming and Scripting
Hello,
I need some help to reformat this table-by-row to matrix?
infile:
site1 A:o,p,q,r,s,t
site1 C:y,u
site1 T:v,w
site1 -:x,z
site2 A:p,r,t,v,w,z
site2 C:u,y
site2 G:q,s
site2 -:o,x
site3 A:o,q,s,t,u,z
site3 C:y
site3 T:v,w,x
site3 -:p,routfile:
SITE o p q r s t v u w x y... (7 Replies)
Discussion started by: yifangt
7 Replies
7. Shell Programming and Scripting
Gents,
Can you please help me to create a pivot table from a csv file. ( I have zip the csv file)
Using the file attached, columns 1,28 and 21 i would like to get something like this output
JD Val 1 2 3 4 5 6 7 8 9 10 11 12 Total... (4 Replies)
Discussion started by: jiam912
4 Replies
8. UNIX for Dummies Questions & Answers
Hi all
I need help converting a text file into a html table in bash and I need to email this table. The text file looks like the below. Two columns with multiple rows. Top row being header.
Application Name Application Status
Application 1 Open
Application 2 ... (2 Replies)
Discussion started by: hitmanjd
2 Replies
9. UNIX for Beginners Questions & Answers
I have this code with me but the condition is If any of the mandatory columns are null then entire file will be rejected.
LOAD DATA
infile ' ' #specifies the name of a datafile containing data that you want to load
BADFILE ' ' #specifies the name of... (1 Reply)
Discussion started by: raka123
1 Replies
10. Shell Programming and Scripting
Hi to all,
I have a file like that in attach, I need to create a table or csv with only this field:
"Barcode","Device Name", "ACSL".
I tried with grep with -B options but the number of lines are different for any block is different, there is a method with sed or awk to extract it.
Thanks a... (2 Replies)
Discussion started by: alen192
2 Replies
LEARN ABOUT ULTRIX
mu-extract
MU-EXTRACT(1) General Commands Manual MU-EXTRACT(1)
NAME
mu_extract - display and save message parts (attachments), and open them with other tools.
SYNOPSIS
mu extract [options] <file> mu extract [options] <file> <pattern>
DESCRIPTION
mu extact is the mu sub-command for extracting MIME-parts (e.g., attachments) from mail messages. It works on message files, and does not
require the message to be indexed in the database.
For attachments, the file name used when saving it, is the name of the attachment in the message. If there is no such name, or when saving
non-attachment MIME-parts, a name is derived from the message-id of the message.
If you specify a pattern (a case-insensitive regular expression) as the second argument, all attachments with filenames matching that pat-
tern will be extracted. The regular expressions are Perl-compatible (as per the PCRE-library).
Without any options, mu extract simply outputs the list of leaf MIME-parts in the message. Only 'leaf' MIME-parts (including RFC822 attach-
ments) are considered, multipart/* etc. are ignored.
OPTIONS
-a, --save-attachments
save all MIME-parts that look like attachments.
--save-all
save all non-multipart MIME-parts.
--parts=<parts>
only consider the following numbered parts (comma-separated list).The numbers for the parts can be seen from running mu extract
without any options but only the message file.
--target-dir=<dir>
save the parts in the target directory rather than the current working directory.
--overwrite
overwrite existing files with the same name; by default overwriting is not allowed.
--play Try to 'play' (open) the attachment with the default
application for the particular file type. On MacOS, this uses the open program, on other platforms is uses xdg-open. You can choose
a different program by setting the MU_PLAY_PROGRAM environment variable.
EXAMPLES
To display information about all the MIME-parts in a message file:
$ mu extract msgfile
To extract MIME-part 3 and 4 from this message, overwriting existing files with the same name:
$ mu extract --parts=3,4 --overwrite msgfile
To extract all files ending in '.jpg' (case-insensitive):
$ mu extract msgfile '.*.jpg'
To extract an mp3-file, and play it in the the default mp3-playing application.
$ mu extract --play msgfile 'whoopsididitagain.mp3'
BUGS
Please report bugs if you find them: http://code.google.com/p/mu0/issues/list
AUTHOR
Dirk-Jan C. Binnema <djcb@djcbsoftware.nl>
SEE ALSO
mu(1)
User Manuals February 2012 MU-EXTRACT(1)