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
BOOM(1)                                                      CAO-VLSI Reference Manual                                                     BOOM(1)

NAME
BOOM - BOOlean Minimization ORIGIN
This software belongs to the ALLIANCE CAD SYSTEM developed by the ASIM team at LIP6 laboratory of Universite Pierre et Marie CURIE, in Paris, France. Web : http://asim.lip6.fr/recherche/alliance/ E-mail : alliance-users@asim.lip6.fr SYNOPSIS
boom [-VTOAP] [-l num] [-d num] [-i num] [-a num] [-sjbgpwtmorn] filename [outname] DESCRIPTION
BOOM is used for the first step of the synthesis process. It optimizes a behavioural description using a Reduced Ordered Binary Decision Diagram representation of logic functions. The file filename is the input behavioural description and must be written in vbe(5) format. The resulting behavioural optimized description is saved with the name outname or input_name_o in vbe(5) format. ENVIRONMENT VARIABLES
MBK_WORK_LIB(1) indicates the path to the read/write directory for the session. OPTIONS
-V Verbose mode on. Each step of the optimization is displayed on the standard output. -T Trace mode on. Some debug informations are displayed on the standard output. -O Reverses initial Bdd variables order. -A BOOM performs a local optimization and keeps the architecture of the initial description by saving most of the intermediate sig- nals. This mode is well-suited for big or regular circuits such as multipliers, adders. By default BOOM performs a global opti- mization and removes most of the intermediate signals so that the outputs are expressed in terms of the inputs or the internal registers. This mode is well-suited for random circuits such as FSMs. -P Uses a parameter file input_name.boom describing optimization directives and constraints. (see below for the exact syntax) # Example of .boom file # # The list of auxiliary signals that have to be kept # during optimization. # Generally carry signals, ram address signals etc ... # BEGIN_KEEP carry[3:0] ram_address[3:0] END # # The list of auxiliary signals which assigned # expression won't be modified. # Generally it's ram output signals. # BEGIN_DONT_TOUCH ram_out[7:0] END -l num Specifies the optimization level [0-3] (default is 0, low level). -d num Specifies the delay optimization percent (default is 0% delay, 100% surface). -i num Specifies the number of iterations for the choosen optimization algorithm (for experts only). -a num Specifies the amplitude during bdd reordering (for experts only). -sjbgpwtmorn Specifies which algorithm has to be used for the boolean optimization. SEE ALSO
boom(5), vbe(5), asimut(1), boog(1), MBK_WORK_LIB(1). BUG REPORT
This tool is under development at the ASIM department of the LIP6 laboratory. We need your feedback to improve documentation and tools. ASIM
/LIP6 August 25, 2000 BOOM(1)
All times are GMT -4. The time now is 09:47 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy