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
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
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
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
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
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
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
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
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
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
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)