06-20-2007
NO.
what is my problem is i sent this CSV FILE to excel spread sheet.
when open the csv file, i could not see whole column width. it showing excel default column width. so, i cannot see whole column. i need to manually darg he column to see column result. so, i want to increase the column width before sening to e-mail attachment.
that is my problem.
thx for your help. pl write the script
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
FOLD(1) BSD General Commands Manual FOLD(1)
NAME
fold -- fold long lines for finite width output device
SYNOPSIS
fold [-bs] [-w width] [file ...]
DESCRIPTION
The fold utility is a filter which folds the contents of the specified files, or the standard input if no files are specified, breaking the
lines to have a maximum of 80 columns.
The options are as follows:
-b Count width in bytes rather than column positions.
-s Fold line after the last blank character within the first width column positions (or bytes).
-w width
Specify a line width to use instead of the default 80 columns. Width should be a multiple of 8 if tabs are present, or the tabs
should be expanded using expand(1) before using fold.
ENVIRONMENT
The LANG, LC_ALL and LC_CTYPE environment variables affect the execution of fold as described in environ(7).
SEE ALSO
expand(1), fmt(1)
STANDARDS
The fold utility conforms to IEEE Std 1003.1-2001 (``POSIX.1'').
BUGS
If underlining is present it may be messed up by folding.
BSD
August 2, 2004 BSD