Sponsored Content
Top Forums Shell Programming and Scripting Read columns from file by position Post 302421777 by malcomex999 on Sunday 16th of May 2010 04:59:40 AM
Old 05-16-2010
Try...
Code:
awk 'NR>2{print substr($0,6,20)"," substr($0,26,10)"," substr($0,36,20)}' infile

If you need with space, change the comma to space...
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

read space filled file and replace text at specific position

Hi I have a spaced filled file having records like below: What I want is to read line having RT3 at position 17-19 then go to position 2651 check the 18 characters (might be space filled till 18 characters). This position should have a... (6 Replies)
Discussion started by: COD
6 Replies

2. Shell Programming and Scripting

Read value from particular position in file.

From unix script i want to read string value in a file from position 2 to 5. which command can be used or any alternatives there?? (2 Replies)
Discussion started by: krishnarao
2 Replies

3. Shell Programming and Scripting

read file until certain line position

let's say I have this file format and another file i only want to get the lines between "test" and "*", so how do I do that and then assign to a variable with a space in between? (5 Replies)
Discussion started by: finalight
5 Replies

4. Shell Programming and Scripting

use awk to read randomly located columns in an excel file

Hi, I have an excel file that have a random count of columns/fields and what im trying to do is to only retrieve all the rows under 2 specific field headers. I can use the usually command for awk which is awk 'print{ $1 $2}' > output.txt, but the location of the 2 specific field headers is... (9 Replies)
Discussion started by: mdap
9 Replies

5. Shell Programming and Scripting

Change many columns position/order

Hi everyone, Please some help over here. (I´m using cygwing) I have files with 40 columns and 2000 lines in average. I´m trying to change the order position as follow. Original columns position:... (3 Replies)
Discussion started by: cgkmal
3 Replies

6. Shell Programming and Scripting

Read columns from delimited file in UNIX

Hello I need to read the columns from a flat file delimited by Hex code X02. The Sample file is Red^B1000^BJohn Blue^B2000^BSam Green^B3000^BDan Note: Hex code X02 shows as ^B in vi. I need to read the file and process the columns in each row. I tried using awk -F command but... (7 Replies)
Discussion started by: injey
7 Replies

7. Shell Programming and Scripting

Read flat file upto certain number of columns

Hello Guys Please help me with the below issue I want to read a flat file source upto certain number of columns Say my flat file has 30 columns but I want to read upto 25 columns only How come the above issue can be addressed? Thanks a lot!!!! (1 Reply)
Discussion started by: Pratik4891
1 Replies

8. Shell Programming and Scripting

How to read data from tab delimited file after a specific position?

Hi Experts, I have a tab deliminated file as below myfile.txt Local Group Memberships *Administrators *Guests I need data in below format starting from 4th position. myfile1.txt Administrators Guests the above one is just an example and there could... (15 Replies)
Discussion started by: Litu1988
15 Replies

9. Shell Programming and Scripting

Merge Two files on the basis of 2 columns at diffrent position

Hello, I am trying to merge two files with multiple records having a common columns but on first file its on 7th column and on 2nd file it on 6th column. First file(file1.txt) - 7th Column is unique H|123|Alex|Ren|W|9856746|2345789|20152202| H|97654|Ray|John||9855678|2345790|20152201|... (6 Replies)
Discussion started by: Mannu2525
6 Replies

10. UNIX for Beginners Questions & Answers

Delete columns with a specific title XXX, where the position change in each file

Goodmorning, I know how to cut a string and a column, and how to find a word. I have a file with over 100 columns. All columns have a title in the first line. I have to delete all columns with the XXX title. I can't use cut -f because the position of XXX columns change in each file, and in... (14 Replies)
Discussion started by: echo manolis
14 Replies
CURSES(3)						   BSD Library Functions Manual 						 CURSES(3)

NAME
curses_cursor, getcury, getcurx, getyx, getbegy, getbegx, getbegyx, getmaxy, getmaxx, getmaxyx, getpary, getparx, getparyx, move, wmove, mvcur, wcursyncup -- curses cursor and window location and positioning routines LIBRARY
Curses Library (libcurses, -lcurses) SYNOPSIS
#include <curses.h> int getcury(WINDOW *win); int getcurx(WINDOW *win); void getyx(WINDOW *win, int y, int x); int getbegy(WINDOW *win); int getbegx(WINDOW *win); void getbegyx(WINDOW *win, int y, int x); int getmaxy(WINDOW *win); int getmaxx(WINDOW *win); void getmaxyx(WINDOW *win, int y, int x); int getpary(WINDOW *win); int getparx(WINDOW *win); void getparyx(WINDOW *win, int y, int x); int move(int y, int x); int wmove(WINDOW *win, int y, int x); int mvcur(int oldy, int oldx, int y, int x); void wcursyncup(WINDOW *win); DESCRIPTION
These functions and macros locate and position cursors and windows. The getcury() and getcurx() functions get the current row and column positions, respectively, of the cursor in the window win. The getyx() macro sets the values of y and x to the current row and column positions of the cursor in the window win. The origin row and columns of a window win can be determined by calling the getbegy() and getbegx() functions, respectively, and the maximum row and column for the window can be found by calling the functions getmaxy() and getmaxx(), respectively. The getbegyx() and getmaxyx() macros set the values of y and x to the origin and maximum row and column positions, respectively, for the window win. The getpary() and getparx() functions return the row and column position of the given subwindow relative to the window's parent. The macro getparyx() sets the values of y and x to the origin of the subwindow relative to the window's parent. The move() function positions the cursor on the current window at the position given by y, x. The cursor position is not changed on the screen until the next refresh(). The wmove() function is the same as the move() function, excepting that the cursor is moved in the window specified by win. The function mvcur() moves the cursor to y, x on the screen. The arguments oldy, oldx define the previous cursor position for terminals that do not support absolute cursor motions. The curses library may optimise the cursor motion based on these values. If the mvcur() succeeds then the curses internal structures are updated with the new position of the cursor. If the destination arguments for mvcur() exceed the terminal bounds an error will be returned and the cursor position will be unchanged. The wcursyncup() function sets the cursor positions of all ancestors of win to that of win. RETURN VALUES
Functions returning pointers will return NULL if an error is detected. The functions that return an int will return one of the following values: OK The function completed successfully. ERR An error occurred in the function. SEE ALSO
curses_refresh(3) STANDARDS
The NetBSD Curses library complies with the X/Open Curses specification, part of the Single Unix Specification. The getbegx(), getbegy(), getcurx(), getcury(), getmaxx(), getmaxy(), getparx(), and getpary() functions are extensions. HISTORY
The Curses package appeared in 4.0BSD. BSD
February 23, 2010 BSD
All times are GMT -4. The time now is 06:07 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy