Sponsored Content
Top Forums Shell Programming and Scripting Read columns from file by position Post 302421612 by alain.kazan on Saturday 15th of May 2010 06:04:24 AM
Old 05-15-2010
Hello ,

Input file ( each filed has a position and length )
Code:
id ( position 1 , length 5 )  ; Name ( position 6, length 20 ) ; TITLE ( position 26 , length 10 ) ; Type ( position 36 , length 20 ) ; 
Salary ( position 56 , length 5 ) ; DEPT.ID ( position 61, length 5 )

Code:
ID        NAME           TITLE        TYPE         SALARY     DEPT. ID
---       -----------    ---------    ----------   -------    --------
24        JOHN SMITH     MANAGER      FULL TIME    1000       26

Desired Output file :

Code:
JOHN SMITH   MANAGER  FULL TIME

Many thanks

Last edited by Scott; 05-15-2010 at 07:20 AM.. Reason: Please use code tags
 

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
XmTextFieldPosToXY(library call)										  XmTextFieldPosToXY(library call)

NAME
XmTextFieldPosToXY -- A TextField function that accesses the x and y position of a character position SYNOPSIS
#include <Xm/TextF.h> Boolean XmTextFieldPosToXY( Widget widget, XmTextPosition position, Position *x, Position *y); DESCRIPTION
XmTextFieldPosToXY accesses the x and y position, relative to the upper left corner of the TextField widget, of a given character position in the text buffer. widget Specifies the TextField widget ID position Specifies the character position in the text for which the x and y position is accessed. This is an integer number of characters from the beginning of the buffer. The first character position is 0. x Specifies the pointer in which the x position is returned. The returned position is the distance from the left side of the wid- get to the left border of the character. This value is meaningful only if the function returns True. y Specifies the pointer in which the y position is returned. The returned position is the distance from the top of the widget to the character's baseline. This value is meaningful only if the function returns True. For a complete definition of TextField and its associated resources, see XmTextField(3). RETURN
This function returns True if the character position is displayed in the TextField widget; otherwise, it returns False, and no x or y value is returned. RELATED
XmTextField(3). XmTextFieldPosToXY(library call)
All times are GMT -4. The time now is 04:56 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy