I think this should get you going on the awk statement
I think that should work with just awk or nawk, but for sure works with gawk.
I really dont know how to format awk stuff or I would format that up for you.
As for the email problem Ive never had a problem with a unix formatted csv file opening in excel... Not sure why the un2dos command is goofing up your email formatting/encoding...
I have a CSV file which contains number series as one of the fields. Some of the records of the field look like :
079661/3
I have to convert the above series as
079661
079662
079663
and store it as 3 different records.
Looking for help on how to achieve this. Am a newbie at Shell... (10 Replies)
I am trying to parse a csv file in the below 'name-value pair' format and then use the values corresponding to the name.
Type:G,Instance:instance1,FunctionalID:funcid,Env:dev,AppName:appname... (6 Replies)
I have a CSV file that needs to through two seperate processes (in the end there will be 2 files (Dload.unl and Tload.unl and we'll say the input file name is mass.csv). I have a processfile() function that will call the process Dload funtion. In Dload I want to read mass.csv into Dload and then... (1 Reply)
Hey guys,
I'm in the process of learning PHP and BASH scripting. I'm getting there, slowly ;)
I would like some help with parsing a CSV file. This file contains a list of hostnames, dates, and either Valid, Expired, or Expired Soon in the last column.
Basically, I want to parse the file,... (12 Replies)
Yes, there is a great doc out there that discusses parsing csv files with sed, and this topic has been covered before but not enough to answer my question (unix.com forums).
I'm trying to parse a CSV file that has optional quotes like the following:
"Apple","Apples, are fun",3.60,4.4,"I... (3 Replies)
Hello list,
I am working on a csv file which contains two fields per record which contain IP addresses. What I am trying to do is find records which have identical fields(IP addresses) which occur 4(four) times, and if they do, delete all records with that specific identical field(ip address).
... (4 Replies)
Hi Members, I am stuck with the following problem. Request your kind help
I have an csv file which contains, 1 header record, data records and 1 footer record. Sample is as below
Contents of cm_update_file_101010.csv
--------------------------------------------------
... (6 Replies)
Hi,
Newbie here and I need some help to parse a csv file that contains fields separated by ",". What I need to achieve here is, read the 1 line file and extract 240 fields and pass to a variable and then read the next 240 fields and pass to a variable, over and over. If anyone can assist that... (4 Replies)
Hi,
I have basic knowledge on unix shell scripting(not an expert).
My requirement is reading the csv file using the schema defined in the configuration file and if the condition is not mached then move the unmatched record to a error file and matched good records into other file.
In brief: ... (43 Replies)
Hello All,
I have an input CSV file like below, where first row data can be in different position after every run of the tool, i.e. pzTest in below example is in column 1, but it can be also in 3 column and same for all the headers in the first row.
pzTest, pzExtract, pxUpdate, pzInfo... (1 Reply)
Discussion started by: asirohi
1 Replies
LEARN ABOUT DEBIAN
amc-mailing
AMC-MAILING(1) Auto Multiple Choice AMC-MAILING(1)NAME
AMC-mailing - mail PDF annotated completed answer sheets to students
SYNOPSIS
auto-multiple-choice mailing [--xmlargs args.xml] --projet project-dir --students-list students-list.csv [--list-encoding encoding]
--email-column col --sender sender-email --subject subject --text email-body [--debug file.log]
[transport arguments...]
DESCRIPTION
The command AMC-mailing.pl sends by email the PDF annotated completed answer sheets to the students. Email addresses are taken from the
students list file.
--projet project-dir
Gives the project directory.
--students-list students-list.csv
sets the students list file name.
--list-encoding encoding
selects an encoding for file students-list.csv (default is utf-8).
--email-column col
sets the name of the column containing the email addresses of the students in the students list file.
--sender sender-email
sets the sender email.
--subject subject
sets the subject of the emails to send.
--text email-body
sets the body text of the emails to send.
--transport transport
sets the transport to use. transport may be sendmail or SMTP.
--debug file.log
gives a file to fill with debugging information.
TRANSPORT ARGUMENTS
Depending on the value used for argument transport, the following arguments can be added:
Transport sendmail
--sendmail-path path
sets the path to the sendmail command (defaults to /usr/sbin/sendmail).
Transport SMTP
--smtp-host host
sets the SMTP hostname (defaults to smtp).
--smtp-port port
sets the port to use (default value is 25).
ARGUMENTS IN A XML FILE
To avoid encoding problems, one can place some arguments in a XML file and use the --xmlargs file.xml argument as the first command
argument. Here is an exemple of such a file:
<?xml version="1.0" encoding="UTF-8"?>
<arguments>
<arg>--sender</arg><arg>Bienvenue <paamc@passoire.fr></arg>
<arg>--text</arg><arg>Voila votre copie corrigee</arg>
<arg>--subject</arg><arg>QCM</arg>
</arguments>
AUTHORS
Alexis Bienvenue <paamc@passoire.fr>
Main author
Jean Berard
Translation from French
Georges Khaznadar
Translation from French
COPYRIGHT
Copyright (C) 2008-2012 Alexis Bienvenue
This document can be used according to the terms of the GNU General Public License, version 2 or later.
Auto Multiple Choice 1.1.1 06/19/2012 AMC-MAILING(1)