10-13-2011
Single row fixed length flat file data extractration
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
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
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
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
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
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
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
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
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
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
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
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
LEARN ABOUT XFREE86
glshademodel
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)