Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Getting data from a flat file based on condition
Top Forums Shell Programming and Scripting Getting data from a flat file based on condition Post 302885889 by Corona688 on Tuesday 28th of January 2014 05:46:22 PM
Old 01-28-2014
Quote:
Originally Posted by Vivekit82
Hi,

gawk not working.
In what way is it 'not working'?

Show exactly what you did, letter for letter, as well as the input data, not a mockup.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Sorting a flat file based on multiple colums(using character position)

Hi, I have an urgent task here. I am required to sort a flat file based on multiple columns which are based on the character position in that line. I am restricted to use the character position instead of the space and sort +1 +2 etc to do the sorting. I understand that there is a previous... (8 Replies)
Discussion started by: cucubird
8 Replies

2. Shell Programming and Scripting

Merge lines in Flat file based on first 5 characters

Hi I have the fixed width flat file having the following data 12345aaaaaaaaaabbbbbbbbbb 12365sssssssssscccccccccc 12365sssss 12367ddddddddddvvvvvvvvvv 12367 vvvvv Here the first column is length 5 second is length 10 third is length 10 if the second or third column exceeds... (3 Replies)
Discussion started by: Brado
3 Replies

3. Shell Programming and Scripting

Shell script to email based on flat file output

Hi All, I am a newbee in unix but still have written a shell script which should trigger a mail based on certain conditions but the problem is that my file is not being read. Below is the code please advise. I do not know where is it failing. Note $ and the no followed with it is the no of... (1 Reply)
Discussion started by: apoorva
1 Replies

4. Shell Programming and Scripting

Load data from a flat file to oracle.

I have a flat file with records like Header 123 James Williams Finance2000 124 Pete Pete HR 1500 125 PatrickHeather Engg 3000 Footer The structure is: Eno:4 characters Name:8 characters Surname : 9 characters Dept:7 characters Sal:4characters These are sample... (1 Reply)
Discussion started by: Shivdatta
1 Replies

5. UNIX for Dummies Questions & Answers

Normalize Data and write to a flat file

All, Can anyone please help me with the below scenario. I have a Flat file of the below format. ID|Name|Level|Type|Zip|MAD|Risk|Band|Salesl|Dealer|CID|AType|CValue|LV|HV|DCode|TR|DU|NStartDate|UserRole|WFlag|EOption|PName|NActivationDate|Os|Orig|Cus|OType|ORequired|DType 03|... (10 Replies)
Discussion started by: sp999
10 Replies

6. Shell Programming and Scripting

To read a flat file containing XML data

I have a file something like this:aaaa.xml content of the file is 0,<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <storeInformation xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <s> <BRANCH_NO>3061</BRANCH_NO> <BRANCH_NAME>GREEN EXPRESS</BRANCH_NAME> ... (4 Replies)
Discussion started by: kmanivan82
4 Replies

7. UNIX for Dummies Questions & Answers

Deleting the unwanted data based on condition

hi i have my input data like this aaa bbb ccc asa dff nmj mnj saa dff oik aax cdx saa oik asq sdf dssi want my output file to be like this mnj saa dff oik aax cdx saa oiki want to retain only those lines which will have oik just below them and i want oik to be as next column to those... (1 Reply)
Discussion started by: anurupa777
1 Replies

8. Shell Programming and Scripting

Sort based on positions in flat file

Hello, For example: 12........6789101112..............20212223242526..................50 ( Positions) LName FName DOB (Lastname starts from 1 to 6 , FName from 8 to 15 and date of birth from 21 to29) CURTIS KENNETH ... (5 Replies)
Discussion started by: duplicate
5 Replies

9. Shell Programming and Scripting

Dynamically prepare the condition using flat file sdata

I have a file in which the data looks like A,B My output should be T1.A=T2.A AND T1.B=T2.B If my input is A,B,C My output should be T1.A=T2.A AND T1.B=T2.B AND T1.C=T2.C Currently I am automating my databae script and strucked with this part.Not able to search the... (2 Replies)
Discussion started by: bikky6
2 Replies

10. Shell Programming and Scripting

Adding data from a file based on some condition

I collect data in a file in below format(Month Day Year Size) in RedHat Linux. Now i want to calculate the data size date wise. As i code shell script after long time, i forgot the features and syntax. Can anyone help me regard this please. Feb 8 2014 15 Feb 10 2014 32 Feb 10 2014 32 Feb 12... (2 Replies)
Discussion started by: makauser
2 Replies

LEARN ABOUT LINUX

ntfscluster

NTFSCLUSTER(8)						      System Manager's Manual						    NTFSCLUSTER(8)

NAME

       ntfscluster - identify files in a specified region of an NTFS volume.

SYNOPSIS

       ntfscluster [options] device

DESCRIPTION

       ntfscluster has three modes of operation: info, sector and cluster.

   Info
       The default mode, info is currently not implemented.  It will display general information about the NTFS volume when it is working.

   Sector
       The sector mode will display a list of files that have data in the specified range of sectors.

   Cluster
       The cluster mode will display a list of files that have data in the specified range of clusters.  When the cluster size is one sector, this
       will be equivalent to the sector mode of operation.

OPTIONS

       Below is a summary of all the options that ntfscluster accepts.	Nearly all options have two equivalent names.  The short name is  preceded
       by  -  and the long name is preceded by --.  Any single letter options, that don't take an argument, can be combined into a single command,
       e.g.  -fv is equivalent to -f -v.  Long named options can be abbreviated to any unique prefix of their name.

       -c, --cluster RANGE
	      Any files whose data is in this range of clusters will be displayed.

       -F, --filename NAME
	      Show information about this file.

       -f, --force
	      This will override some sensible defaults, such as not working with a mounted volume.  Use this option with caution.

       -h, --help
	      Show a list of options with a brief description of each one.

       -I, --inode NUM
	      Show information about this inode.

       -i, --info
	      This option is not yet implemented.

       -q, --quiet
	      Reduce the amount of output to a minimum.  Naturally, it doesn't make sense to combine this option with

       -s, --sector RANGE
	      Any files whose data is in this range of sectors will be displayed.

       -v, --verbose
	      Increase the amount of output that ntfscluster prints.

       -V, --version
	      Show the version number, copyright and license for ntfscluster.

EXAMPLES

       Get some information about the volume /dev/hda1.

	      ntfscluster /dev/hda1

       Look for files in the first 500 clusters of /dev/hda1.

	      ntfscluster -c 0-500 /dev/hda1

BUGS

       The info mode isn't implemented yet.  ntfscluster is quite limited, but it has no known bugs.  If you find  a  bug  please  send  an  email
       describing the problem to the development team:
       ntfs-3g-devel@lists.sf.net

AUTHORS

       ntfscluster was written by Richard Russon, with contributions from Anton Altaparmakov.  It was ported to ntfs-3g by Erik Larsson.

AVAILABILITY

       ntfscluster is part of the ntfs-3g package and is available from:
       http://www.tuxera.com/community/

SEE ALSO

       ntfsinfo(8), ntfsprogs(8)

ntfs-3g 2011.4.12AR.4						   November 2005						    NTFSCLUSTER(8)
All times are GMT -4. The time now is 02:07 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy