06-22-2007
Hi Ygor,
i did same thing as you said. In excel there is no data.
pl tell me what is missing.
i did sql first
then i used your awk code then i used
/usr/bin/uuencode Report.xls Report.xls > attachment_report.xls
then i did mailx.
no data in excel
pl help me
thx
N.
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 MOJAVE
git-column
GIT-COLUMN(1) Git Manual GIT-COLUMN(1)
NAME
git-column - Display data in columns
SYNOPSIS
git column [--command=<name>] [--[raw-]mode=<mode>] [--width=<width>]
[--indent=<string>] [--nl=<string>] [--padding=<n>]
DESCRIPTION
This command formats its input into multiple columns.
OPTIONS
--command=<name>
Look up layout mode using configuration variable column.<name> and column.ui.
--mode=<mode>
Specify layout mode. See configuration variable column.ui for option syntax.
--raw-mode=<n>
Same as --mode but take mode encoded as a number. This is mainly used by other commands that have already parsed layout mode.
--width=<width>
Specify the terminal width. By default git column will detect the terminal width, or fall back to 80 if it is unable to do so.
--indent=<string>
String to be printed at the beginning of each line.
--nl=<N>
String to be printed at the end of each line, including newline character.
--padding=<N>
The number of spaces between columns. One space by default.
GIT
Part of the git(1) suite
Git 2.17.1 10/05/2018 GIT-COLUMN(1)