Sponsored Content
Full Discussion: Format csv file using Unix
Special Forums UNIX Desktop Questions & Answers Format csv file using Unix Post 302588777 by itkamaraj on Tuesday 10th of January 2012 01:44:24 AM
Old 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

FORMAT OF CSV FILE under unix environment.

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

AWK CSV to TXT format, TXT file not in a correct column format

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

Unix script to convert .csv file to.xls format

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

Format CSV file

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

Convert the below file to csv format

Hi , i want to change this question, i will post soon.. (6 Replies)
Discussion started by: srikanth2567
6 Replies

6. Shell Programming and Scripting

Retaining the Unix CSV format in Excel format while exporting

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

Format csv file

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

Match list of strings in File A and compare with File B, C and write to a output file in CSV format

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

UNIX command output in csv format

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

Change date format in am/pm in csv files using UNIX

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) 						      General Commands Manual							   tput(1)

NAME
tput - query terminfo database SYNOPSIS
type] capname... type] capname [parms...] DESCRIPTION
The command uses the database to make terminal-dependent capabilities and information available to the shell (see terminfo(4)). The com- mand outputs a string if the attribute (capname) is of type string, or an integer if the attribute is of type integer. If the attribute is of type boolean, simply sets the exit code for TRUE, for FALSE), and produces no output. Command-line Arguments The command recognizes the following command-line arguments: Indicates the type of terminal. Normally this flag is unnecessary because the default is taken from the environment variable capname Indicates the attribute from the database. See terminfo(4). In addition, the following capnames are supported: Echo the clear-screen sequence for the current terminal. Echo the initialize sequence for the current terminal. Echo the sequence that will reset the current terminal. parms If the capname takes optional numeric parameters, the parms will be placed in the string output by The capnames are read from stdin and multiple capnames are allowed. Only one capname is allowed per line when reading from stdin. EXTERNAL INFLUENCES
Environment Variables determines the locale to use. This overrides settings of other environment variables. determines the language to use for messages. determines the terminal type if the option is not specified. EXAMPLES
Echo clear-screen sequence for the current terminal. Print the number of columns for the current terminal. Print the number of columns for the 70092 terminal. Set shell variable to stand-out-mode sequence for current terminal. This might be followed by a prompt: Set exit code to indicate if current terminal is a hard copy terminal. Clear the screen, move the cursor to line 10, column 20 and turn on bold. RETURN VALUE
If capname is of type boolean, then the exit code is set to for true and for false. If capname is not of type boolean and fails, an error message is printed, and exit code is set to one of the following depending on the failure: The capability name is of type integer and does not exist. Usage error. Unknown terminal type. Unknown capability name. An error occurred. If the exit code is a is printed if a capability name of type integer is requested for a terminal that has no entry for that capability name in the database (such as FILES
Terminfo data base Definition files SEE ALSO stty(1), untic(1M), terminfo(4). STANDARDS CONFORMANCE
tput(1)
All times are GMT -4. The time now is 05:43 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy