Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Formatting a line of data into columns Post 302314731 by nistleloy on Saturday 9th of May 2009 08:47:15 PM
Old 05-09-2009
Formatting a line of data into columns

Hi all,

I'm a little stuck with a data file I've been collecting data in. The file contains one field of data running continuously down the file and I can't work out how to format the data into three columns.

This is a mock up of the file: Each r# is a random number and varies in length, this goes down the file for a long ways.
Code:
r1
r2
r3
r1
r2
r3
r1
r2
r3

This is how i'd like it to look with three columns of data.
Code:
r1         r2          r3
r1         r2          r3
r1         r2          r3


Also with awk I can get data based on a field number ($1, $2) is there anyway of selecting data based on a line number?

Thanks for any responses,
nistleloy
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Text formatting to 132 columns

I want to take a file that is generated in 132 columns from a unix based report generator and transfer it to a windows environment and preserve the column length. Any ideas how I can do this so that whatever windows based text editor that reads the document will know it should be in 132 columns?... (16 Replies)
Discussion started by: jmossman
16 Replies

2. Shell Programming and Scripting

Formatting info into columns

Hi This question has kind of been asked before but I couldn't get any of the solutions to work. I need to format fields being cut from a file into columns so it looks like a table. e.g Full name Address Hiredate Joe Smith London 11.01.01 Bill King ... (8 Replies)
Discussion started by: straight_edge
8 Replies

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

4. Shell Programming and Scripting

Formatting output in columns

I have a file which contains data in below format: nbkv28s MgmtReporting -> TradingDesk 1 nbkv28s RMBS -> Credits 178 nbkv28s RMBS -> PassThrough 96 nbkv28s RMBS -> Prepayment 111 nbkv28s RMBS -> RMBSHome 370 nbkv28s RMBS -> TradingStrategy 98 nbkvnze RMBS -> RMBSHome 85 nbkvugn GSF... (3 Replies)
Discussion started by: mohsin.quazi
3 Replies

5. UNIX for Advanced & Expert Users

formatting the data

HI I want to make it single row if start with braces i.e. { .Any idea {1:XXX2460275191}{2:SEC00687921131112201641N}{3:{58910}}{4: :R:GENL :C::xx//xx1 :20C::yy//yy1 :2S:xxT} {1:XXX2460275190}{2:SEC00687921131112201641y}{3:{58911}}{4: :z:GENL :v::xx//xx1 :10C::yy//yy1 :4S:xxT ... (2 Replies)
Discussion started by: mohan705
2 Replies

6. Shell Programming and Scripting

formatting columns

Hi I have a file that is several gigs in size and basically I want to change the format of it. Obviously I cannot go through it manually. The file looks like this: 897 2 901 2 905 2 909 2 913 2 917 2 921 2 925 2 929 2 933 2 937 2 941 2 945 2 949 0 (1 Reply)
Discussion started by: kylle345
1 Replies

7. Shell Programming and Scripting

Formatting File having big single line into 95 Char Per Line

Hi All, I have 4 big files which contains one big line containing formatted character records, I need to format each file in such way that each File will have 95 Characters per line. Last line of each file will have newline character at end. Before:- File Name:- File1.dat 102 121340560... (10 Replies)
Discussion started by: lancesunny
10 Replies

8. Shell Programming and Scripting

Formatting columns in file

I have a script that creates a file with three column output. The columns look like this: Policy Name Name Volume VLS-EDWARDS-ARCHIVED_FILE-WINDOWS 10 12 XLZ-BASE-CYGWIN-ARCHIVED-FILE-LINUX 2 21 ZLX-GOLD-FILES-JAPANFILERS1-LINUX 20 27 ZLX-GOLD-FILES-JAPANFILERS2-LINUX13 29... (4 Replies)
Discussion started by: newbie2010
4 Replies

9. Shell Programming and Scripting

Perl syntax for formatting columns and text

Dear all, Pzl let me know what is the syntax for converting the columns format to text as i have lots of values for but when i put these values in xls sheet the values are automatically converted to and one more question i have is how to call values from shell script into perl script eg. ... (3 Replies)
Discussion started by: sagar_1986
3 Replies

10. Shell Programming and Scripting

Bash formatting data into columns

Hi guys, I'm trying to create a table of aggregated data using just bash commands. My data is in three columns, for example: 2014-01-01 testA 64 2014-01-01 testB 27 2014-02-01 testA 31 2014-02-02 testB 29 2014-02-02 testC 12 And the result I am looking for is: ... (4 Replies)
Discussion started by: mccmjc
4 Replies
XGetTextProperty()														XGetTextProperty()

Name
  XGetTextProperty - read one of a window's text properties.

Synopsis
  Status XGetTextProperty(display, w, text_prop_return, property)
	Display *display;
	Window w;
	XTextProperty *text_prop_return;
	Atom property;

Arguments
  display   Specifies a connection to an X server; returned from XOpenDisplay().

  w	    Specifies the window.

  text_prop_return
	    Returns the XTextProperty structure.

  property  Specifies the property name.

Returns
  Zero on failure, non-zero on success.

Availability
  Release 4 and later.

Description
  XGetTextProperty() reads the specified property from the window and stores the data in the returned XTextProperty structure.	It stores the
  data in the value field, the type of the data in the encoding field, the format of the data in the format field, and the number of items of
  data	in  the  nitems  field.  An extra byte containing null (which is not included in the nitems number) is stored at the end of the value
  field of text_prop_return.  The particular interpretation of the property's encoding and data as ``text'' is left to the  calling  applica-
  tion.  If the specified property does not exist on the window, XGetTextProperty() sets the value field to NULL, the encoding field to None,
  the format field to zero, and the nitems field to zero.

  If it was able to set these files in the XTextProperty structure, XGetTextProperty() returns a non-zero status;  otherwise,  it  returns  a
  zero status.

  For more information, see Volume One, Chapter 12, Interclient Communication.

Structures
     typedef struct {
	 unsigned char *value;	      /* same as Property routines */
	 Atom encoding; 	      /* prop type */
	 int format;		      /* prop data format: 8, 16, or 32 */
	 unsigned long nitems;	      /* number of data items in value */
     } XTextProperty;

Errors
  BadAtom
  BadWindow

See Also
  XFreeStringList(), XSetTextProperty(), XStringListToTextProperty(), XTextPropertytoStringList.

Xlib - Window Manager Hints													XGetTextProperty()
All times are GMT -4. The time now is 12:13 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy