01-10-2012
@Jayan
your tput command only shows the bold result in terminal ( not in the csv file )
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hi
I unload the table results from oracle to csv file foramt.
i need increse the width of each column using unix commands
could you pl tell me how to increase the width of each column to spefic width uisng sed unix command or na other unix commands
i have file name called report.csv
inside... (38 Replies)
Discussion started by: raosurya
38 Replies
2. 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
3. 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
4. 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
5. Shell Programming and Scripting
Hi ,
i want to change this question, i will post soon.. (6 Replies)
Discussion started by: srikanth2567
6 Replies
6. 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
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
TPUT(1) BSD General Commands Manual TPUT(1)
NAME
tput, clear -- terminal capability interface
SYNOPSIS
tput [-T term] attribute [attribute-args] ...
DESCRIPTION
tput makes terminal-dependent information available to users or shell applications. The options are as follows:
-T The terminal name as specified in the terminfo(5) database, for example, ``vt100'' or ``xterm''. If not specified, tput retrieves
the ``TERM'' variable from the environment.
tput outputs a string if the attribute is of type string; a number if it is of type integer. Otherwise, tput exits 0 if the terminal has the
capability and 1 if it does not, without further action.
If the attribute is of type string, and takes arguments (e.g. cursor movement, the terminfo ``cup'' sequence) the arguments are taken from
the command line immediately following the attribute.
The following special attributes are available:
clear Clear the screen (the terminfo(5) ``cl'' sequence).
init Initialize the terminal (the terminfo(5) ``is2'' sequence).
longname Print the descriptive name of the user's terminal type.
reset Reset the terminal (the terminfo(5) ``rs1, rs2, rs3'' and ``rf'' sequence).
EXIT STATUS
The exit status of tput is based on the last attribute specified. If the attribute is of type string or of type integer, tput exits 0 if the
attribute is defined for this terminal type and 1 if it is not. If the attribute is of type boolean, tput exits 0 if the terminal has this
attribute, and 1 if it does not. tput exits 2 if any error occurred.
EXAMPLES
tput cl cm 5 10 clear the screen and goto line 5 column 10
tput cm 6 11 DC 6 goto line 6 column 11 and delete 6 characters
SEE ALSO
termcap(3), termcap(5)
HISTORY
The tput command appears in 4.4BSD.
BUGS
tput can't really distinguish between different types of attributes.
Not all terminfo entries contain the reset sequence, so using the init sequence may be more useful.
BSD
September 29, 2009 BSD