Sponsored Content
Top Forums Shell Programming and Scripting Fixed length flat file extraction Post 302564496 by rdcwayx on Thursday 13th of October 2011 08:10:31 PM
Old 10-13-2011
Quote:
Originally Posted by vbe
Code:
ant:/home/vbe $ cat extractfile001
1111 AAAA 100    US
2222 BBBB 200    IN
3333 CCCC 3000   UK

ant:/home/vbe $ grep AAAA <extractfile001|awk '{print $2,  $3}'
AAAA 100
ant:/home/vbe $ grep AAAA <extractfile001|awk '{print $3}'        
100

since already use awk command, no need grep

Code:
awk '/AAAA/{print $2,  $3}' extractfile001

---------- Post updated at 11:10 AM ---------- Previous update was at 11:07 AM ----------

Quote:
Originally Posted by laxmi1166
Hii vbe
Thanks for the Reply ,But i am getting all the data under $2 ,$3(i have 9 million records under $2 , $3 ,attached the data below ) ..
I want single row data ,like (where condition in Sql). Can we get it in unix
kindly Advice.


VALLEYAREA AMBULANCE
VALLEYAREA AMBULANCE
ANTHONY MEDICAL
CHARLES COUNTY
CHARLES COUNTY
CHARLES COUNTY
CHARLES COUNTY
DOMINIC AMBULATORY
DOMINIC AMBULATORY
DOMINIC AMBULATORY
FRANCIS FIRE
JOHNS REGIONAL
JOSEPHS HOSPITAL
LUKES HOSPITAL
LUKES METHODIST
MARYS HOSP
MARYS HOSP
MARYS HOSPITAL
MARYS LIFEFLIGHT

thanks and regards
Laxmi
Your new sourc file are totally different with your first topic, which has 4 column. Please let us know what your expect output from it.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Flat File Extraction

Hi all, I'm new in the unix environment. I'm having a challenge in extracting data from a flat file and convert it to a CSV file format or I should be able to open it with MS Excel. The input data in my flat file looks like this: AV00001001155000063637143326711145412082EM SITHOLE... (3 Replies)
Discussion started by: Mthimbana
3 Replies

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

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

4. UNIX for Dummies Questions & Answers

Conditional sorting on fixed length flat file

I have a fixed length file that need to be sorted according to the following rule IF B=1 ORDER by A,B Else ORDER by A,C Input file is ABC 131 112 122 231 212 222 Output needed ABC 112 131 122 212 231 222 (1 Reply)
Discussion started by: zsk_00
1 Replies

5. Shell Programming and Scripting

Exporting a flat fixed length file (Urgent)

Hi All, So far, I've been extracting data from db2 tables and exporting the file as a tab delimited file into a UNIX server using the following command: export to /.../.../.../.../.../SM_RAW_DATA.dat of del modified by coldel| nochardel select a.accno, a.CUR_BL_AM, ... (1 Reply)
Discussion started by: jj2485
1 Replies

6. Shell Programming and Scripting

how to read fixed length flat file....

Hi Gurus, Thanks in advance... I am new to writing shell scripting and help me out reading a flat file with fixed length. I have a fixed length flat file with storename(lenth 6) , emailaddress(lenth 15), location(10). There is NO delimiters in that file. Like the following str00001.txt... (2 Replies)
Discussion started by: willywilly
2 Replies

7. Shell Programming and Scripting

reading fixed length flat file and calling java code using shell scripting

I am new to shell scripting and I have to to the following I have a flat file with storename(lenth 20) , emailaddress(lenth 40), location(15). There is NO delimiters in that file. Like the following str00001.txt StoreName emailaddress location... (3 Replies)
Discussion started by: willywilly
3 Replies

8. UNIX for Advanced & Expert Users

Insert Delimiter at fixed locations in a flat file

Hi Can somebody help me with solution for this PLEASE? I have a flat file and need to insert delimiters at fixed positions in all the lines so that I can easily convert into EXCEL with columns defined as per their width. For Example Here is the file { kkjhdhal sdfewss sdtereetyw... (7 Replies)
Discussion started by: jd_mca
7 Replies

9. Shell Programming and Scripting

Flat file-make field length equal to header length

Hello Everyone, I am stuck with one issue while working on abstract flat file which i have to use as input and load data to table. Input Data- ------ ------------------------ ---- ----------------- WFI001 Xxxxxx Control Work Item A Number of Records ------ ------------------------... (5 Replies)
Discussion started by: sonali.s.more
5 Replies

10. UNIX for Dummies Questions & Answers

Length of a fixed width file

I have a fixed width file of length 53. when is try to get the lengh of the record of that file i get 2 different answers. awk '{print length;exit}' <File_name> The above code gives me length 50. wc -L <File_name> The above code gives me length 53. Please clarify on... (2 Replies)
Discussion started by: Amrutha24
2 Replies
GLSHADEMODEL(3G)														  GLSHADEMODEL(3G)

NAME
glShadeModel - select flat or smooth shading C SPECIFICATION
void glShadeModel( GLenum mode ) PARAMETERS
mode Specifies a symbolic value representing a shading technique. Accepted values are GL_FLAT and GL_SMOOTH. The initial value is GL_SMOOTH. DESCRIPTION
GL primitives can have either flat or smooth shading. Smooth shading, the default, causes the computed colors of vertices to be interpo- lated as the primitive is rasterized, typically assigning different colors to each resulting pixel fragment. Flat shading selects the com- puted color of just one vertex and assigns it to all the pixel fragments generated by rasterizing a single primitive. In either case, the computed color of a vertex is the result of lighting if lighting is enabled, or it is the current color at the time the vertex was speci- fied if lighting is disabled. Flat and smooth shading are indistinguishable for points. Starting when glBegin is issued and counting vertices and primitives from 1, the GL gives each flat-shaded line segment i the computed color of vertex i+1, its second vertex. Counting similarly from 1, the GL gives each flat-shaded polygon the computed color of the vertex listed in the following table. This is the last vertex to specify the polygon in all cases except single polygons, where the first vertex specifies the flat-shaded color. ------------------------------------- Primitive Type of Polygon i Vertex ------------------------------------- Single polygon (i==1) 1 Triangle strip i+2 Triangle fan i+2 Independent triangle 3i Quad strip 2i+2 Independent quad 4i ------------------------------------- Flat and smooth shading are specified by glShadeModel with mode set to GL_FLAT and GL_SMOOTH, respectively. ERRORS
GL_INVALID_ENUM is generated if mode is any value other than GL_FLAT or GL_SMOOTH. GL_INVALID_OPERATION is generated if glShadeModel is executed between the execution of glBegin and the corresponding execution of glEnd. ASSOCIATED GETS
glGet with argument GL_SHADE_MODEL SEE ALSO
glBegin(3G), glColor(3G), glLight(3G), glLightModel(3G) GLSHADEMODEL(3G)
All times are GMT -4. The time now is 02:34 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy