06-21-2007
Do not uuencode the csv file before running the awk script. Run your SQL, then awk then uuencode then mail.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
HI guys,
I have created a script to read 1 column in a csv file and then place it in text file.
However, when i checked out the text file, it is not in a column format...
Example:
CSV file contains
name,age
aa,11
bb,22
cc,33
After using awk to get first column
TXT file... (1 Reply)
Discussion started by: mdap
1 Replies
2. UNIX for Dummies Questions & Answers
I have a .csv file in Unix box i need a UNIX script to convert the.csv files to.xls format.
Its very urgent please help me. (1 Reply)
Discussion started by: moon_friend
1 Replies
3. Shell Programming and Scripting
I have a csv file which I need to process and export back to xlsx file.
For instance, the csv contains:
John Smith, job-title, hours
John Smith, job-title, hours
Mary Smith job-title, hours
etc.
I need to import that to a script, get id of redundant data i.e:
John smith, job-title,... (13 Replies)
Discussion started by: _tina_
13 Replies
4. Shell Programming and Scripting
Hi,
i want to disply the o/p in HTML format from unix environment.
Let me explain my requirement.
First an automated email should be sent in HTML format. The report contains number of error on a daily basis for this week.
email looks like below,
01-04-2010 1000
02-04-2010 ... (3 Replies)
Discussion started by: apsprabhu
3 Replies
5. Shell Programming and Scripting
Hi All,
I have created a Unix Shell script whch creates a *.csv file and export it to Excel.
The problem i am facing is that Users wants one of the AMOUNT field in comma separted values. Example :
if the Amount has the value as 3000000 User wants to be in 3,000,000 format.
This Amount format... (2 Replies)
Discussion started by: rawat_me01
2 Replies
6. UNIX Desktop Questions & Answers
Hi All,
I have an csv file with three rows, where first containing header deatils. is there any way to make the first row to appear bold using UNIX command.
Input File:
Name Rank
arun 1
babu 2
Expected Output:
Name Rank
arun 1
babu 2 (7 Replies)
Discussion started by: arunmanas
7 Replies
7. Shell Programming and Scripting
Hi,
I need to make some changes in a csv file using awk or perl. Unfortunately, all my attempts have led to nothing so I hope you guys can help me.
I have the following example input file including header(original file has 35 fields):
ABC: DE
Time: 2012/09/07... (3 Replies)
Discussion started by: Subbeh
3 Replies
8. Shell Programming and Scripting
Hi Friends,
I'm a great fan of this forum... it has helped me tone my skills in shell scripting. I have a challenge here, which I'm sure you guys would help me in achieving...
File A has a list of job ids and I need to compare this with the File B (*.log) and File C (extend *.log) and copy... (6 Replies)
Discussion started by: asnandhakumar
6 Replies
9. Shell Programming and Scripting
I'm just wondering is there any way to capture the output of a unix command in a csv format.
df -h gives the result of filesystem,free space,Used space, use %,mounted on.
Is there a way to capture the command output and format it as comma sparated or fixed length file. (3 Replies)
Discussion started by: anita81
3 Replies
10. Shell Programming and Scripting
Hi All,
I'm new to forum good to hear all.
I stuck in converting date format in csv file using unix
csv file contains as below
,750,0000000000000000GCJR, ,06/22/2016 14:48:44
I want to convert into as below
,750,0000000000000000GCJR, ,06/22/2016 02:48:44 PM
Please reply asap..... (22 Replies)
Discussion started by: Raghureds
22 Replies
LEARN ABOUT SUSE
uuencode
uuencode(n) Text encoding & decoding binary data uuencode(n)
__________________________________________________________________________________________________________________________________________________
NAME
uuencode - UU-encode/decode binary data
SYNOPSIS
package require Tcl 8
package require uuencode ?1.1.4?
::uuencode::encode string
::uuencode::decode string
::uuencode::uuencode ?-name string? ?-mode octal? (-file filename | ?--? string)
::uuencode::uudecode (-file filename | ?--? string)
_________________________________________________________________
DESCRIPTION
This package provides a Tcl-only implementation of the uuencode(1) and uudecode(1) commands. This encoding packs binary data into printable
ASCII characters.
::uuencode::encode string
returns the uuencoded data. This will encode all the data passed in even if this is longer than the uuencode maximum line length. If
the number of input bytes is not a multiple of 3 then additional 0 bytes are added to pad the string.
::uuencode::decode string
Decodes the given encoded data. This will return any padding characters as well and it is the callers responsibility to deal with
handling the actual length of the encoded data. (see uuencode).
::uuencode::uuencode ?-name string? ?-mode octal? (-file filename | ?--? string)
::uuencode::uudecode (-file filename | ?--? string)
UUDecode a file or block of data. A file may contain more than one embedded file so the result is a list where each element is a
three element list of filename, mode value and data.
OPTIONS
-filename name
Cause the uuencode or uudecode commands to read their data from the named file rather that taking a string parameter.
-name string
The uuencoded data header line contains the suggested file name to be used when unpacking the data. Use this option to change this
from the default of "data.dat".
-mode octal
The uuencoded data header line contains a suggested permissions bit pattern expressed as an octal string. To change the default of
0644 you can set this option. For instance, 0755 would be suitable for an executable. See chmod(1).
EXAMPLES
% set d [uuencode::encode "Hello World!"]
2&5L;&\@5V]R;&0A
% uuencode::uudecode $d
Hello World!
% set d [uuencode::uuencode -name hello.txt "Hello World"]
begin 644 hello.txt
+2&5L;&@5V]R;&0`
`
end
% uuencode::uudecode $d
{hello.txt 644 {Hello World}}
BUGS, IDEAS, FEEDBACK
This document, and the package it describes, will undoubtedly contain bugs and other problems. Please report such in the category base64
of the Tcllib SF Trackers [http://sourceforge.net/tracker/?group_id=12883]. Please also report any ideas for enhancements you may have for
either package and/or documentation.
KEYWORDS
encoding, uuencode
COPYRIGHT
Copyright (c) 2002, Pat Thoyts
base64 1.1.4 uuencode(n)