Sponsored Content
Top Forums Shell Programming and Scripting Finding multiple column values and match in a fixed length file Post 302438556 by naveen_sangam on Tuesday 20th of July 2010 05:45:22 AM
Old 07-20-2010
Finding multiple column values and match in a fixed length file

Hi,

I have a fixed length file where I need to verify the values of 3 different fields, where each field will have a different value.

How can I do that in a single step.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Comparing column of variable length anf fixed width file

Hi, I have two input files. File1: ID Name Place 1-234~name1~Newyork 1-34~name2~Boston 1-2345~name3~Hungary File1 is a variable length file where each column is seperated by delimitter "~". File2: ID Country 1-34<<11 SPACES>>USA<<7 spaces>> 1-234<<10 SPACES>>UK<<8... (5 Replies)
Discussion started by: manneni prakash
5 Replies

2. Shell Programming and Scripting

print a file with one column having fixed character length

Hi guys, I have tried to find a solution for this problem but couln't. If anyone of you have an Idea do help me. INPUT_FILE with three columns shown to be separated by - sign A5BNK723NVI - 1 - 294 A7QZM0VIT - 251 - 537 A7NU3411V - 245 - 527 I want an output file in which First column... (2 Replies)
Discussion started by: smriti_shridhar
2 Replies

3. UNIX for Dummies Questions & Answers

What the command to find out the record length of a fixed length file?

I want to find out the record length of a fixed length file? I forgot the command. Any body know? (9 Replies)
Discussion started by: tranq01
9 Replies

4. UNIX for Dummies Questions & Answers

Convert a tab delimited/variable length file to fixed length file

Hi, all. I need to convert a file tab delimited/variable length file in AIX to a fixed lenght file delimited by spaces. This is the input file: 10200002<tab>US$ COM<tab>16/12/2008<tab>2,3775<tab>2,3783 19300978<tab>EURO<tab>16/12/2008<tab>3,28523<tab>3,28657 And this is the expected... (2 Replies)
Discussion started by: Everton_Silveir
2 Replies

5. UNIX for Dummies Questions & Answers

Fixed length file extracting values in columns

How do I extract values in a few columns in a row of a fixed length file? If there are 8 columns and I need to extract values of 2nd,4th and 6 th columns, how do i do that? I used cut command, this I used only for one column. How do I do it more than one column? The below command will give... (1 Reply)
Discussion started by: princetd001
1 Replies

6. UNIX for Dummies Questions & Answers

Count on grep for more than two values in a row of fixed length file

I want to get count on number of records in a few folders by running grep command for more than two columns in a row of fixed length file. suppose if i have a fixed length file has 5 columns and I want to see the record counts for country =can and province = bc and time stamp <= 12 feb 2013... (14 Replies)
Discussion started by: princetd001
14 Replies

7. Shell Programming and Scripting

awk Print New Column For Every Two Lines and Match On Multiple Column Values to print another column

Hi, My input files is like this axis1 0 1 10 axis2 0 1 5 axis1 1 2 -4 axis2 2 3 -3 axis1 3 4 5 axis2 3 4 -1 axis1 4 5 -6 axis2 4 5 1 Now, these are my following tasks 1. Print a first column for every two rows that has the same value followed by a string. 2. Match on the... (3 Replies)
Discussion started by: jacobs.smith
3 Replies

8. Shell Programming and Scripting

Match value in column and append file with new values

Hi, I need help to match two files based on two columns. file_1 ID AA An Ca Ele Pro Su Ot Tra g13950 No No Yes No Yes Yes Yes Yes g05760 Yes No No No No Yes Yes Yes g12640 No No No No No No No No k17720 No Yes No No No No No Yes g05640 Yes Yes Yes No No Yes Yes Yes file_2 ... (8 Replies)
Discussion started by: redse171
8 Replies

9. Shell Programming and Scripting

Break one long string into multiple fixed length lines

This is actually a KSH under Unix System Services (Z/OS), but hoping I can get a standard AIX/KSH solution to work... I have a very large, single line file in Windows, that we download via FTP, with the "SITE WRAP" option, into a Z/OS file with an LRECL of 200. This essentially breaks the single... (4 Replies)
Discussion started by: bubbawuzhere
4 Replies

10. Shell Programming and Scripting

UNIX command -Filter rows in fixed width file based on column values

Hi All, I am trying to select the rows in a fixed width file based on values in the columns. I want to select only the rows if column position 3-4 has the value AB I am using cut command to get the column values. Is it possible to check if cut -c3-4 = AB is true then select only that... (2 Replies)
Discussion started by: ashok.k
2 Replies
branch(1rheolef)                                                    rheolef-6.1                                                   branch(1rheolef)

NAME
branch -- handle a family of fields SYNOPSIS
branch [options] filename EXAMPLE
Generates vtk file colection for visualization with paraview: branch output.branch -paraview DESCRIPTION
Read and output a branch of finite element fields from file, in field text file format. INPUT FILE SPECIFICATION
-Idir add dir to the RHEOPATH search path. See also geo(2) for RHEOPATH mechanism. filename specifies the name of the file containing the input field. - read field on standard input instead on a file. -ndigit int Number of digits used to print floating point values when using the `-geo' option. Default depends upon the machine precision asso- ciated to the Float type. OUTPUT AND RENDER SPECIFICATION
-extract int Extract the i-th record in the file. The output is a field or multi-field file format. -branch Output on stdout in `.branch' format. This is the default. -paraview Generate a collection of vtk files for using paraview. -vtk Generate a single vtk file with numbered fields. -gnuplot Run 1d animation using gnuplot. -plotmtv This driver is unsupported for animations. OTHER OPTIONS
-umin float -umax float set the solution range for the gnuplot driver. By default this range is computed from the first field of the branch, and this could be problematic when this field is initialy zero. -topography filename[.field[.gz]] performs a tridimensionnal elevation view based on the topographic data. -proj performs a P1 projection on the fly. This option is useful when rendering P0 data while vtk render requieres P1 description. -elevation For two dimensional field, represent values as elevation in the third dimension. This is the default. -noelevation Prevent from the elevation representation. -scale float applies a multiplicative factor to the field. This is useful e.g. in conjonction with the elevation option. The default value is 1. -verbose print messages related to graphic files created and command system calls (this is the default). -noverbose does not print previous messages. -clean clear temporary graphic files (this is the default). -noclean does not clear temporary graphic files. -execute execute graphic command (this is the default). -noexecute does not execute graphic command. Generates only graphic files. This is usefull in conjuction with the -noclean command. BRANCH FILE FORMAT
The `.branch' file format bases on the `.field' one: EXAMPLE GENERAL FORM #!branch #!branch branch branch 1 1 11 <version> <nfield=1> <nvalue=N> time u <key> <field name> #time 3.14 #<key> <key value 1> #u #<field name> field <field 1> ..... .... ..... .... #time 6.28 #<key> <key value N> #u #<field name> field <field N> ..... .... The key name is here time, but could be any string (without spaces). The previous example contains one field at each time step. Labels appears all along the file to facilitate direct jumps and field and step skips. The format supports several fields, such as (t,u(t),p(t)), where u could be a multi-component (e.g. a vector) field: #!branch branch 1 2 11 time u p #time 3.14 #u mfield 1 2 #u0 field ... #u1 field ... #p #time 6.28 ... SEE ALSO
geo(2) rheolef-6.1 rheolef-6.1 branch(1rheolef)
All times are GMT -4. The time now is 05:58 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy