03-14-2013
The example you showed doesn't have any dates in it.
Show representative input and representative output and we can try. Otherwise we'll blindly do things which do what you say, not what you actually want.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all,
Am new to scripting. So i just need your ideas to help me out. Here goes my requirement.
I have two csv files
1.csv 2.csv
abc,1.24 abc,1
def,2.13 def,1
I need to compare the first column of 1.csv with 2.csv and if matches then need to compare... (2 Replies)
Discussion started by: chinnahyd
2 Replies
2. Shell Programming and Scripting
I have been trying to find a good solution for this seemingly simple task for 2 days, and I'm giving up and posting a thread. I hope someone can help me out!
I'm on HPUX, using sqlplus, mailx, awk, have some other tools available, but can't install stuff that isn't already in place (without a... (6 Replies)
Discussion started by: soldstatic
6 Replies
3. Shell Programming and Scripting
Hi Fellows,
I have been struggling to fix an issue in csv records to compose sql statements and have been really losing sleep over it. Here is the problem:
I have csv files in the following pipe-delimited format:
Column1|Column2|Column3|Column4|NEWLINE
Address Type|some descriptive... (4 Replies)
Discussion started by: khayal
4 Replies
4. Shell Programming and Scripting
Hi
I have two csv files, with the following formats:
FileA.log:
Application, This occured blah
Application, That occured blah
Application, Also this
AnotherLog, Bob did this
AnotherLog, Dave did that
FileB.log:
Uk, London, Application, datetime, LaterDateTime, Today it had'nt... (8 Replies)
Discussion started by: PerlNewbRP
8 Replies
5. Shell Programming and Scripting
hi, someone to know how can i read a specific column of csv file and search the value in other csv columns if exist the value in the second csv copy entire row with all field in a new csv file. i suppose that its possible using awk but i m not expertise thanks in advance (8 Replies)
Discussion started by: giankan
8 Replies
6. Shell Programming and Scripting
Hi,
I am tryng to read from a csv file and based on some grep command output I will modify one of the column in the same csv.
Example:-
Input CSV:-
20120829001415,noneAA,google.com
20120829001415,dfsafds,google.com
20120829001415,noneAA,google.com
Intermediate Step:- If 2nd column of... (3 Replies)
Discussion started by: kmajumder
3 Replies
7. UNIX for Dummies Questions & Answers
Hi all,
I have a csv file that appears as follows:
,2013/03/26,2012/12/26,4,1,"2017/09/26,5.75%","2017/09/26,1,2018/09/26,1,2019/09/26,1,2020/09/26,1,2021/09/26,1",,,2012/12/26,now when i use the split function like this:
my @f = split/,/; the split function will split the data that is... (2 Replies)
Discussion started by: WongSifu
2 Replies
8. Shell Programming and Scripting
(say) I have 2 csv files - file1.csv & file2.csv as mentioned below:
file1.csv
ID,version,cost
1000,1,30
2000,2,40
3000,3,50
4000,4,60
file2.csv
ID,version,cost
1000,1,30
2000,2,45
3000,4,55
6000,5,70
... (1 Reply)
Discussion started by: Naresh101
1 Replies
9. Shell Programming and Scripting
(say) I have 2 csv files - file1.csv & file2.csv as mentioned below:
file1.csv
ID,version,cost
1000,1,30
2000,2,40
3000,3,50
4000,4,60
file2.csv
ID,version,cost
1000,1,30
2000,2,45
3000,4,55
6000,5,70
The... (7 Replies)
Discussion started by: Naresh101
7 Replies
10. Shell Programming and Scripting
Hi,
I have a file of csv data, which looks like this:
file1:
1AA,LGV_PONCEY_LES_ATHEE,1,\N,1,00020460E1,0,\N,\N,\N,\N,2,00.22335321,0.00466628
2BB,LES_POUGES_ASF,\N,200,200,00006298G1,0,\N,\N,\N,\N,1,00.30887539,0.00050312... (10 Replies)
Discussion started by: djoseph
10 Replies
LEARN ABOUT DEBIAN
mmencode
MIMENCODE(1) General Commands Manual MIMENCODE(1)
NAME
mimencode - Translate to and from mail-oriented encoding formats
(Same program also installed as "mmencode".)
SYNOPSIS
mimencode[-u] [-b] [-q] [-p] [file name] [-o outputfile]
DESCRIPTION
The mimencode program simply converts a byte stream into (or out of) one of the standard mail encoding formats defined by MIME, the pro-
posed standard for internet multimedia mail formats. Such an encoding is necessary because binary data cannot be sent through the mail.
The encodings understood by mimencode are preferable to the use of the uuencode/uudecode programs, for use in mail, in several respects
that were important to the authors of MIME.
By default, mimencode reads standard input, and sends a "base64" encoded version of the input to standard output.
The (really not necessary) "-b" option tells mimencode to use the "base64" encoding.
The "-q" option tells mimencode to use the "quoted-printable" encoding instead of base64.
The "-u" option tells mimencode to decode the standard input rather than encode it.
The "-p" option tells mimencode to translate decoded CRLF sequences into the local newline convention during decoding and to do the reverse
during encoding. This option is only meaningful when -b (base64 encoding) is in effect.
If a file name argument is given, input is read from that file rather than from standard input.
The "-o" option, which must be followed by a file name, sends output to the named file rather than to standard output.
RATIONALE
Mimencode is intended to be a replacement for uuencode for mail and news use. The reason is simple: uuencode doesn't work very well in a
number of circumstances and ways. In particular, uuencode uses characters that don't translate well across all mail gateways (particularly
ASCII <-> EBCDIC gateways). Also, uuencode is not standard -- there are several variants floating around, encoding and decoding things in
different and incompatible ways, with no "standard" on which to base an implementation. Finally, uuencode does not generally work well in
a pipe, although some variants have been modified to do so. Mimencode implements the encodings which were defined for MIME as uuencode
replacements, and should be considerably more robust for email use.
SEE ALSO
metamail(1), mailto(1)
BUGS
This program was originally distributed as "mmencode". That name turns out to conflict with a program of the same name that is part of the
Slate software from BBN, but totally changing the name to mimencode would create other problems (notably with portability to systems where
the left half of file names is limited to 8 characters). Currently, it is being distributed with links under BOTH names. The programs in
the distribution that call the program all call it as "mimencode", so the "mmencode" version may be deleted at sites where it causes a
problem. (The source files are still named "mmencode" rather than "mimencode".)
COPYRIGHT
Copyright (c) 1991 Bell Communications Research, Inc. (Bellcore)
Permission to use, copy, modify, and distribute this material for any purpose and without fee is hereby granted, provided that the above
copyright notice and this permission notice appear in all copies, and that the name of Bellcore not be used in advertising or publicity
pertaining to this material without the specific, prior written permission of an authorized representative of Bellcore. BELLCORE MAKES NO
REPRESENTATIONS ABOUT THE ACCURACY OR SUITABILITY OF THIS MATERIAL FOR ANY PURPOSE. IT IS PROVIDED "AS IS", WITHOUT ANY EXPRESS OR IMPLIED
WARRANTIES.
AUTHOR
Nathaniel S. Borenstein
Bellcore Prototype Release 1 MIMENCODE(1)