Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Formatting text file
Top Forums Shell Programming and Scripting Formatting text file Post 302977810 by ROCK_PLSQL on Friday 22nd of July 2016 07:50:06 AM
Old 07-22-2016
Hi Ravindra,

This is my input file.

Code:
pname tmgnsr.tpfile_01 analy, lists=8, lines=5900, duration cap: 27.682 seconds
pname tmgnsr.tpfile_01 analy, lists=5, lines=1234, duration cap: 5.12 seconds
pname tmgnsr.sdcfile_01 analy, lists=4, lines=878172, duration cap: 27.145 seconds
pname tmgnsr.sdcfile_02 analy, lists=4, lines=200, duration cap: 34.624 seconds
pname tmgnsr.sdcfile_03 analy, lists=4, lines=200, duration cap: 8.076 seconds
pname tmgnsr.mndfile_01 analy, lists=3, lines=900, duration cap: 37.393 seconds
pname tmgnsr.mndfile_03 analy, lists=1, lines=900, duration cap: 43.077 seconds
pname tmgnsr.mndfile_04 analy, lists=8, lines=5900, duration cap: 16.371 seconds
pname tmgnsr.mndfile_05 analy, lists=1, lines=30, duration cap: 10.967 seconds
pname tmgnsr.mndfile_06 analy, lists=8, lines=900, duration cap: 6.688 seconds
pname tmgnsr.mndfile_abc_01 analy, lists=8, lines=900, duration cap: 22.231 seconds

I want the output as below.

Code:
tmgnsr ,tpfile_01 , 8, 5900, 27.682
tmgnsr ,tpfile_01 , 5, 1234, 5.12
tmgnsr ,sdcfile_01 , 4, 878172, 27.145
tmgnsr ,sdcfile_02 , 4, 200, 34.624
tmgnsr ,sdcfile_03 , 4, 200, 8.076
tmgnsr ,mndfile_01 , 3, 900, 37.393
tmgnsr ,mndfile_02 , 1, 900, 43.077
tmgnsr ,mndfile_03 , 8, 5900, 16.371
tmgnsr ,mndfile_04 , 1, 30, 10.967
tmgnsr ,mndfile_05 , 8, 900, 6.688
tmgnsr ,mndfile_abc_01 , 8, 900, 22.231

Thanks.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

text file formatting by perl

have a simple text file as input.i have to print that file in paragraph format.whenevr it finds "\n" in the input text it should start printing in next paragraph in output file.also a fixed amount of space should be given before start writing in every paragraph. the input and output file format... (5 Replies)
Discussion started by: avik1983
5 Replies

2. Shell Programming and Scripting

Formatting a text file based on newline and delimiter characters

Hi Everybody, I need some help on formatting the files coming into unix box on the fly. I get a file some thing like this in a single line. ISA^M00^M ^M00^M ^M14^M006929681900 ^M01^M095449419 ... (5 Replies)
Discussion started by: ntekupal
5 Replies

3. UNIX for Dummies Questions & Answers

Text file formatting

Hi all! I'm new in unix, and faced with some difficulties. So I have text file f.e. "textfile" which contains rows like: aaa bbb ccc ddd How could I format it, so the file looks like: aaabbb cccddd Thanks in andvance (5 Replies)
Discussion started by: consta.v
5 Replies

4. UNIX for Dummies Questions & Answers

formatting of the text file

Hi Guys, I have a file with contents in the below format DO_VJ_IDOC;03.23.2009;22:31:09; ZJDO_VJ_IDOC;03.23.2009;22:46:14; ZJDO_RESEND_FAILURES;03.24.2009;01:46:18; Now i need to replace the semicolons with tabs for which i am usig the sed command which gives the O/p as below ... (1 Reply)
Discussion started by: rohit.shetty84
1 Replies

5. Shell Programming and Scripting

Formatting a text file to get data in exact line by line

I have my data something like this SERIAL FIRSTOCCURRENCE NETPROTOCOL 1947430693 07/01/2009 05:16:40 FR SERIAL FIRSTOCCURRENCE NETPROTOCOL 1947430746 07/01/2009 05:18:05 FR I want the output as follows.... (1 Reply)
Discussion started by: rdhanek
1 Replies

6. Shell Programming and Scripting

Formatting text file in unix

Hi, I am using the following format command for formatting my text file in unix. awk -F":" '{ printf "%-50s%-1s%-50s\n", $1,":", $2}' filename > targetfile The target file is then sent as an attachment via email. When I view the target file in notepad multiple lines get spanned as a... (2 Replies)
Discussion started by: AAA
2 Replies

7. Shell Programming and Scripting

Formatting the text file using shell script

How to add the filename to end of each line with | as seperator, except first and last line of the file(s) in directories(with diff tree structure) using shell script?. And also how to replace a list of strings with another set of strings, which is present in a file?. Kindly help out on... (1 Reply)
Discussion started by: av_vinay
1 Replies

8. Shell Programming and Scripting

Comparing and Formatting the text file

hi, I need a script which can format the below text file which contains comments file1.txt -------- //START //Name: some value //Date: //Changes:............. //..................... //END //START //Date: //Name: some value //Changes:............. //..................... (3 Replies)
Discussion started by: flamingo_l
3 Replies

9. Shell Programming and Scripting

[Solved] Formatting the text file

Hi All, I ahve requirement where I want to put the text file in into proper format. I am wondering how can i achieve that:- Host/Alias Name IP Address Resolved sinuiy01.infra.go2uti.com 10.240.8.158 N sinuid20.devtst.go2uti.com 10.240.8.230 N sinuid21.devtst.go2uti.com... (6 Replies)
Discussion started by: sharsour
6 Replies

10. Shell Programming and Scripting

Formatting a text file

Hi All :), I have a formatting question and I am unsure on how I should proceed with my bash shell script. I am unsure weather to use perl or simply edit it in bash. I prefer bash but I am only aware of the awk utility to extract parts of a file, not edit output. Scenario: I have a file... (5 Replies)
Discussion started by: bstrizzy
5 Replies

LEARN ABOUT SUSE

tk_nameofcapstyle

Tk_GetCapStyle(3)					       Tk Library Procedures						 Tk_GetCapStyle(3)

__________________________________________________________________________________________________________________________________________________

NAME

       Tk_GetCapStyle, Tk_NameOfCapStyle - translate between strings and cap styles

SYNOPSIS

       #include <tk.h>

       int
       Tk_GetCapStyle(interp, string, capPtr)

       const char *
       Tk_NameOfCapStyle(cap)

ARGUMENTS

       Tcl_Interp *interp (in)		Interpreter to use for error reporting.

       const char *string (in)		String containing name of cap style: one of "butt", "projecting", or "round".

       int *capPtr (out)		Pointer to location in which to store X cap style corresponding to string.

       int cap (in)			Cap style: one of CapButt, CapProjecting, or CapRound.
_________________________________________________________________

DESCRIPTION

       Tk_GetCapStyle  places  in  *capPtr  the  X  cap  style corresponding to string.  This will be one of the values CapButt, CapProjecting, or
       CapRound.  Cap styles are typically used in X graphics contexts to indicate how the end-points of lines should be capped.  See the X  docu-
       mentation for information on what each style implies.

       Under  normal  circumstances the return value is TCL_OK and interp is unused.  If string does not contain a valid cap style or an abbrevia-
       tion of one of these names, then an error message is stored in interp->result, TCL_ERROR is returned, and *capPtr is unmodified.

       Tk_NameOfCapStyle is the logical inverse of Tk_GetCapStyle.  Given a cap style such as CapButt it  returns  a  statically-allocated  string
       corresponding to cap.  If cap is not a legal cap style, then "unknown cap style" is returned.

KEYWORDS

       butt, cap style, projecting, round

Tk																 Tk_GetCapStyle(3)
All times are GMT -4. The time now is 09:28 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy