Sponsored Content
Top Forums Shell Programming and Scripting FORMAT OF CSV FILE under unix environment. Post 302122877 by raosurya on Thursday 21st of June 2007 06:20:40 PM
Old 06-21-2007
I tried this excel macro. i did not get any thing.
Honestly, i do not know where put code.
In excel, i went tools, macro, visul basic editor.
i type your code. nothing happend. pl guide me.
where use this code.
thx. N.
if you unix script using awk command, pl provide script for me.
thx.N
 

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. Shell Programming and Scripting

Display o/p in HTML format from unix environment

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

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

6. UNIX Desktop Questions & Answers

Format csv file using Unix

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

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
catch(n)						       Tcl Built-In Commands							  catch(n)

__________________________________________________________________________________________________________________________________________________

NAME
       catch - Evaluate script and trap exceptional returns

SYNOPSIS
       catch script ?resultVarName? ?optionsVarName?
_________________________________________________________________

DESCRIPTION
       The  catch  command may be used to prevent errors from aborting command interpretation.	The catch command calls the Tcl interpreter recur-
       sively to execute script, and always returns without raising an error, regardless of any errors that might occur while executing script.

       If script raises an error, catch will return a non-zero integer value corresponding to the exceptional return code returned  by	evaluation
       of  script.  Tcl defines the normal return code from script evaluation to be zero (0), or TCL_OK.  Tcl also defines four exceptional return
       codes: 1 (TCL_ERROR), 2 (TCL_RETURN), 3 (TCL_BREAK), and 4 (TCL_CONTINUE).  Errors during evaluation of a script are indicated by a  return
       code of TCL_ERROR.  The other exceptional return codes are returned by the return, break, and continue commands and in other special situa-
       tions as documented.  Tcl packages can define new commands that return other integer values as return codes as well, and scripts that  make
       use of the return -code command can also have return codes other than the five defined by Tcl.

       If  the	resultVarName  argument  is given, then the variable it names is set to the result of the script evaluation.  When the return code
       from the script is 1 (TCL_ERROR), the value stored in resultVarName is an error message.  When  the  return  code  from	the  script  is  0
       (TCL_OK), the value stored in resultVarName is the value returned from script.

       If  the	optionsVarName	argument  is  given, then the variable it names is set to a dictionary of return options returned by evaluation of |
       script.	Tcl specifies two entries that are always defined in the dictionary: -code and -level.	When the return code  from  evaluation	of |
       script  is  not	TCL_RETURN, the value of the -level entry will be 0, and the value of the -code entry will be the same as the return code. |
       Only when the return code is TCL_RETURN will the values of the -level and -code entries be something else, as further described in the doc- |
       umentation for the return command.													   |

       When  the  return  code	from  evaluation  of script is TCL_ERROR, three additional entries are defined in the dictionary of return options |
       stored in optionsVarName: -errorinfo, -errorcode, and -errorline.  The value of the -errorinfo entry is a formatted stack trace	containing |
       more  information  about the context in which the error happened.  The formatted stack trace is meant to be read by a person.  The value of |
       the -errorcode entry is additional information about the error stored as a list.  The -errorcode value is meant to be further processed	by |
       programs,  and may not be particularly readable by people.  The value of the -errorline entry is an integer indicating which line of script |
       was being evaluated when the error occurred.  The values of the -errorinfo and -errorcode entries of the most recent error are also  avail- |
       able as values of the global variables ::errorInfo and ::errorCode respectively. 							   |

       Tcl packages may provide commands that set other entries in the dictionary of return options, and the return command may be used by scripts |
       to set return options in addition to those defined above.

EXAMPLES
       The catch command may be used in an if to branch based on the success of a script.
	      if { [catch {open $someFile w} fid] } {
		  puts stderr "Could not open $someFile for writing
$fid"
		  exit 1
	      }

       There are more complex examples of catch usage in the documentation for the return command.

SEE ALSO
       break(n), continue(n), dict(n), error(n), return(n), tclvars(n)

KEYWORDS
       catch, error

Tcl									8.5								  catch(n)
All times are GMT -4. The time now is 11:09 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy