Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Finding the displacement of a particular field in a file
Top Forums Shell Programming and Scripting Finding the displacement of a particular field in a file Post 302604510 by bobby1015 on Monday 5th of March 2012 09:03:50 AM
Old 03-05-2012
Finding the displacement of a particular field in a file
Hi

I have a file named Employee and it has the following format:
Code:
File name:Employee
00000
0000:0000
YYNNN
20120302
NAME:010:C
ACCOUNT NUM:015,00:N
DATE:008,00:D
#DATA#
ROGER     00000002346123720120302
MAX        00000003654774020110612
JOHNSON  00000000000103420120713
#END#
0000003

How am going to get the displacements for a particular field say for example, I need to have the displacement of ACCOUNT NUM, the answer would be 11, because it starts at position 11. Likewise, I need to get the displacements of all fields in the following format:

Code:
Field               Displacement
Name                    1
Account Num         11
ID                        26

Do we have any command which can get the desired output as shown above. Thanks..Appreciated your help.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Regarding displacement of certain string

Hello,ladies and gentlemen I want to displace a string with another different string in a Korn shell file(*.h) which will includes the code to achieve the goal.How should I code? For example, In receive.sh,I wanna use (Hi) to replace all the (hello).The code to achieve this must be... (2 Replies)
Discussion started by: joshuaduan
2 Replies

2. Shell Programming and Scripting

Finding unique reocrds at a particular field

I have a pipe delimited flat file. I want to grep the records that are unique in the 4th field and repeat only once in the file for e.g.. if the file contains this 3 records i want to get the o/p as: I just gave a sample here and the file is huge one and i cant just grep from the... (7 Replies)
Discussion started by: dsravan
7 Replies

3. Shell Programming and Scripting

Help with finding length of a field

I have a pipe delimited file. I need to check that the first and second fields are 5 characters long and if not i need to append 0 in front of them to make them 5 characters long. can some body let mwe know how i can find the length of the two fields and then make them 5 characters long if they... (6 Replies)
Discussion started by: dsravan
6 Replies

4. Shell Programming and Scripting

awk command for finding field in a file

hi guys i have this file with column number 7 as below: 0 1416 49 37 5 3 2 0 0 0 21 0 26 ... (5 Replies)
Discussion started by: npatwardhan
5 Replies

5. Shell Programming and Scripting

finding field count escaping the blank values

Hi All I have a file.Below are few records of the file. sample.txt CPS,ES,843232910001,ESF81462,W N LINDSAY LTD,01674840629,09-FEB-2009,23-FEB-2009,CDR735,ALL CALLS,01674840629 CPS,ES,843232670001,ESF81462,W N LINDSAY LTD,01674840629,09-FEB-2009,23-FEB-2009,CDR734,ALL... (2 Replies)
Discussion started by: king007
2 Replies

6. Shell Programming and Scripting

Appending 1st field in a file into 2nd field in another file

Hi, I've internally searched through forums for about 2+ hours. Unfortunately, with no luck. Although I've found some cases close to mine below, but didn't help so much. Actually, I'm in short with time. So I had to post my case. Hoping that you can help. I have 2 files, FILE1 ... (0 Replies)
Discussion started by: amurib
0 Replies

7. Shell Programming and Scripting

Help finding a field value then printing line

Hello, I'm trying to only print out the file systems that are greater than 90% full. So far I've got: df -k >sawky8 cat sawky8 | grep -v Filesystem | sed "s/%//g;" >sawky9 cat sawky9 | awk '{print $4}' | read stot print $stot if ;then echo $LINE Problem is it stops after the first... (2 Replies)
Discussion started by: Grueben
2 Replies

8. Shell Programming and Scripting

Help with Awk finding and replacing a field based on a condition

Hi everybody, I'm trying to replace the $98 field with "T" if the last field (108th) is T I've tried awk 'BEGIN{OFS=FS="|"} {if ($108=="T")sub($98,"T"); print}' test.txt but that doesn't do anything also tried awk 'BEGIN{OFS=FS="|"}{ /*T.$/ sub($98,"T")} { print}' test.txt but... (2 Replies)
Discussion started by: jghi123
2 Replies

9. Shell Programming and Scripting

Finding the length of a string in a field

I have a field MPN-BANK-NUMBERO:006,00:N in a file FILE1 How can i display the length of the Bank Number.Any idea ? The output shud take the following format FILE 1 6 Where 1 is the starting position and 6 is the Ending position. (9 Replies)
Discussion started by: bobby1015
9 Replies

10. UNIX for Dummies Questions & Answers

Finding difference in 1st field for rows of data

I have a file that has multiple lines, of grouped data, that typically all have the same values in the 1st field, however, I would like to search the 1st field for any differences and set a flag to use in an "if" statement to run some other routine. An example of the typical file is below,... (2 Replies)
Discussion started by: co21ss
2 Replies

LEARN ABOUT CENTOS

mc-tool

MC-TOOL(1)							     Utilities								MC-TOOL(1)

NAME

       mc-tool - manipulate Mission Control accounts from the command line

SYNOPSIS

       mc-tool list

       mc-tool add PROFILE DISPLAY-NAME [PARAMETER-SETTINGS...]

       mc-tool add MANAGER/PROTOCOL [PARAMETER-SETTINGS...]

       mc-tool update ACCOUNT [PARAMETER-SETTINGS...]

       mc-tool display ACCOUNT DISPLAY-NAME

       mc-tool nick ACCOUNT NICKNAME

       mc-tool service ACCOUNT SERVICE-NAME

       mc-tool icon ACCOUNT ICON

       mc-tool show ACCOUNT

       mc-tool get ACCOUNT PARAMETER [PARAMETER...]

       mc-tool auto-presence ACCOUNT STATUS [MESSAGE]

       mc-tool request ACCOUNT STATUS [MESSAGE]

       mc-tool auto-connect ACCOUNT on|off

       mc-tool remove ACCOUNT

DESCRIPTION

       mc-tool's usage depends on its first argument (the "command")

   SPECIFYING ACCOUNTS
       Where an account name is needed, it may be given as a full object path (e.g.  /org/freedesktop/Telepathy/Account/gabble/jabber/example), or
       as the unique account-specific suffix (e.g.  gabble/jabber/example).

   SPECIFYING PARAMETER SETTINGS
       Many commands take arguments that represent Telepathy connection manager parameters (see the Telepathy Specification for details of these).
       Each argument has the following form:

       TYPE:NAME=VALUE

       where  TYPE  is either int, uint, bool, or string (other parameter types exist, but are currently unsupported by mc-tool), NAME is the name
       of the connection manager parameter (e.g.  account or password), and VALUE is the parameter's value (with integers in decimal, and booleans
       as 0 or 1).

       The update command also accepts arguments of the form clear:NAME which delete the named parameter from the account configuration.

   LIST
       mc-tool list lists the available accounts.

   ADD
       mc-tool	add  adds  an  account.  The  connection  manager and protocol can either be given as the name of a Mission Control profile, (e.g.
       gtalk), or as a slash-separated connection manager name and protocol (e.g.  gabble/jabber).

   DISPLAY
       mc-tool display ACCOUNT DISPLAY-NAME sets the DisplayName property of ACCOUNT to DISPLAY-NAME.

   NICK
       mc-tool nick ACCOUNT NICKNAME sets the Nickname property of ACCOUNT to NICKNAME.

   SERVICE
       mc-tool service ACCOUNT SERVICE-NAME sets the Service property of ACCOUNT to SERVICE-NAME.

   ICON
       mc-tool icon ACCOUNT ICON sets the Icon property of ACCOUNT to ICON.

   SHOW
       mc-tool show ACCOUNT shows information about ACCOUNT.

   GET
       mc-tool get ACCOUNT PARAMETER [PARAMETER...]  shows the values of the given parameters of ACCOUNT.

   ENABLE
       mc-tool enable ACCOUNT sets the Enabled property of ACCOUNT to True.

   DISABLE
       mc-tool disable ACCOUNT sets the Enabled property of ACCOUNT to False.

   AUTO-PRESENCE
       mc-tool auto-presence ACCOUNT STATUS [MESSAGE] sets the AutomaticPresence property of ACCOUNT to STATUS with optional message MESSAGE.

   REQUEST
       mc-tool request ACCOUNT STATUS [MESSAGE] sets the RequestedPresence property of ACCOUNT to STATUS with optional message	MESSAGE;  this	is
       how you tell an account to connect or go offline, for example.

   AUTO-CONNECT
       mc-tool	auto-connect  ACCOUNT  on  sets the ConnectAutomatically property of ACCOUNT to True.  mc-tool auto-connect ACCOUNT off sets it to
       False.

Telepathy							     July 2009								MC-TOOL(1)
All times are GMT -4. The time now is 01:48 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy