09-10-2008
See next post
Last edited by RJ17; 09-10-2008 at 04:12 PM..
Reason: See next post
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi
I have a CSV file with me in this format
Currency, USD, EUR,
USD, 1.00, 1.32,
EUR, 0.66, 1.00,
How do I transpose the file to get to the format below.
currency, currency, rate
USD, USD, 1.00
USD, EUR, 1.32
EUR, USD, 0.66
EUR, EUR, 1.00
Thanks for your help
We are using... (2 Replies)
Discussion started by: cdesiks
2 Replies
2. Shell Programming and Scripting
Folks,
I have a bit of an issue trying to obtain some data from a csv file using PERL. I can sort the file and remove any duplicates leaving only 4 or 5 rows containing data. My problem is that the data contained in the original file contains a lot more columns and when I try ro run this script... (13 Replies)
Discussion started by: lodey
13 Replies
3. Shell Programming and Scripting
Dear All,
I have a comma-separated file.
1. The first line of the file(header) should have 4 commas(5 fields).
2. The last line of the file should have 1 comma(2 fields).
Pls help me in checking this condition in a shell script.
And the number of lines between the first line and last... (11 Replies)
Discussion started by: KrishnaSaran
11 Replies
4. Shell Programming and Scripting
Hi All,
My requirement is create an unix script to parse the xml file and display the values of the Elements/value between the tags on console. Like say, I would like to fetch the value of errorCode from the below xml which is 'U007' and display it. Can we use SED command for this? I have tried... (10 Replies)
Discussion started by: Anil.Wmg
10 Replies
5. Shell Programming and Scripting
Hi,
Our requirement is to parse the input file(.csv format). The each column in the file is delimited with comma. We need to take each column and apply some business validation rule.
If data itself contains comma, then those fields are enclosed with double quotes ("). We can see this double... (7 Replies)
Discussion started by: vfrg
7 Replies
6. Shell Programming and Scripting
Hi,
I have a file with 3 fields in csv format:
/tmp/foo/,MODIFY,bar/toto
"/tmp/foo, bar/","ATTRIB,ISDIR","toto, tata/foobar"I would like to split fields in order to obtain the following:
Line1:
/tmp/foo/
MODIFY
bar/totoLine2:
/tmp/foo, bar/
ATTRIB,ISDIR
toto, tata/foobarCan't find my way... (11 Replies)
Discussion started by: chebarbudo
11 Replies
7. UNIX for Dummies Questions & Answers
Hello !
I am very aware that this is not the first time this question is asked here, because I have already read a lot of previous answers, but none of them worked, so...
As said in the title, I want to read a csv file with a bash script.
Here is a sample of the file:
... (4 Replies)
Discussion started by: Grhyll
4 Replies
8. Shell Programming and Scripting
Hi All,
Hope all you are doing good! Need your help. I have an XML file which needs to be converted CSV file. I am not an expert of awk/sed so your help is highly appreciated!!
XML file looks like this:
<l:event dateTime="2013-03-13 07:15:54.713" layerName="OSB" processName="ABC"... (2 Replies)
Discussion started by: bhaskar_m
2 Replies
9. Shell Programming and Scripting
HI all
I have multiple csv files with the names
VAR1_VAR2_VAR3_VAR4.csv
All the files have the same structure inside just values change.
I am trying to retrieve data from those files by fixing at each time one or more VAR.
I tried to write a script but I have 2 problems:
2-... (1 Reply)
Discussion started by: Jhon.c
1 Replies
10. Shell Programming and Scripting
I am not too savvy with arrays and am assuming that what I am looking for needs arrays. This is my requirement.
So I have the raw data that gets updated to a log as shown below
StudentInfo:
FullInfo = {
Address = Newark
Age = 20
Name= John
}
StudentInfo:... (2 Replies)
Discussion started by: sidnow
2 Replies
post(8) System Manager's Manual post(8)
NAME
post - deliver a message
SYNOPSIS
/usr/lib/mh/post [options] file
OPTIONS
Specifies a file that post should take aliases from. More than one file can be specified, each being preceded with the -alias option. The
post program automatically consults the system alias file, /usr/lib/mh/MailAliases. If there is an Aliasfile entry in your post also con-
sults the file named in that entry. Filters (re-formats) messages sent to blind copy recipients. Recipients named in the Bcc: field nor-
mally receive a new message which includes a copy of the message sent to the other recipients. If this option is specified, this copy of
the message is filtered according to the instructions in the named file. The default is -nofilter. Formats messages so as to conform to
ARPAnet Internet Message Format protocol. This is the default behavior. You can post from formatting messages in this way by using the
-noformat option. Prints a list of the valid options to this command. Adds a Message-ID: or Resent-Message-ID: field to the header.
Specifies the mail system over which mail is sent. The only value allowed is smtp, which is the standard mail system. Additional values
are supported only for use with other mail systems. Informs the user of each step of the posting/filing process. Allows the user to watch
the transport system's handling of the message (for example, local and fast delivery). Specifies the preferred length of the header compo-
nents that contain addresses.
The default settings for post are:
-alias /usr/lib/mh/MailAliases -format -nomsgid -mts smtp -noverbose -nowatch -width 72 -nofilter
DESCRIPTION
The program post is called by send(1) to deliver the message in the named file to local and remote users. In fact, all of the functions at-
tributed to send on its reference page are performed by post, with send acting as a relatively simple pre-processor. Thus, it is post which
parses the various header fields, appends From: and Date: lines, and interacts with the transport system.
Normally, post would not be called directly by the user.
It searches the To:, cc:, Bcc:, and Resent-xxx: header lines of the specified message for destination addresses, checks these addresses for
validity, and formats them so as to conform to ARPAnet Internet Message Format protocol (unless the -noformat option is set). This will
normally cause @local-site to be appended to each local destination address, as well as any local return addresses.
If a Bcc: field is encountered, the mail system will use its addresses for delivery. The Bcc: is removed from the message sent to original
recipients. The copied recipients will receive an entirely new message with a minimal set of headers. The mail system includes a copy of
the message sent to the original recipients in the body of the message.
This command consults the environment variable $SIGNATURE to determine the sender's personal name in constructing the From: line of the
message.
RESTRICTIONS
For this version, the -mts option only supports the value smtp. Additional values are supported for use only with other mail systems.
PROFILE COMPONENTS
The post command does not consult the user's
FILES
The system customization file. The program to process Fcc:s. The program to process Bcc:s. The system alias file.
SEE ALSO
Commands: comp(1), mhmail(1), send(1)
Files: mh-alias(4), mh-mail(4), mtstailor(4)
Standard for the Format of ARPA Internet Text Messages (RFC 822)
post(8)