04-19-2011
Position of the string in a complex file
I had a similar problem few days back and got this fixed with the below command when I have a file with this format
HTML Code:
GS*12345*****
ST*1********
A*
B*
E*
RMR*123455(This is the unique number to locate this row)
F*
SE*1***
GE*12345*
GS*878787*****
ST*2
H*
J*
RMR*567889(This is the unique number to locate this row)
L*
SE*
GE*878787****
And with this code, I was able to find the location of account '56789'
HTML Code:
awk '/^GS/{p=NR}$0~"^RMR.*\\*"k{f=1}/^GE/&&f{printf("%d %d\n",p,NR);f=0}' k="567889" filename
However, when I have a file with duplicate account number in different GS-GE loops, I get both the occurrence with the above command. How do I fetch the exact GS-GE loop when there is a duplicate account number in 2 different GS-GE. I will also have the '12345' in GS row as the search string. So basically, I will have '12345' from GS and '56789' from RMR as my search strings.
HTML Code:
GS*12345*****
ST*1********
A*
B*
E*
RMR*123455(This is the unique number to locate this row)
F*
SE*1***
GE*12345*
GS*676767*****
ST*2
H*
J*
RMR*567889(This is the unique number to locate this row)
L*
SE*
GE*676767****
GS*787878*****
ST*3
A*
B*
RMR*567889(This is the unique number to locate this row)
L*
SE*
GE*787878****
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I need a script for...
how to find a position of column data and print some string in the next line and same position
position should find based on *HEADER8* in text
for ex: ord123 abs 123 987HEADER89 test234
ord124 abc 124 987HEADER88 test235
... (1 Reply)
Discussion started by: naveenkcl
1 Replies
2. UNIX for Dummies Questions & Answers
I have a file and it contains some text and the length is 145. I need to add a string which is of length 8 at the 120th position. Is it possible to add???? Need help on this....:( (4 Replies)
Discussion started by: sivakumar.rj
4 Replies
3. UNIX for Dummies Questions & Answers
Hi All,
My requisite is to search for the string "0108"(which is the year and has come in the wrong year format) in a particular column say 4th column in a tab delimited file and then replace it with 2008(the correct year format) in the same position where 0108 was found in the same file..The... (27 Replies)
Discussion started by: ganesh_248
27 Replies
4. Shell Programming and Scripting
To trim 3rd field in for all the lines of a file and replace the modified string in that particular field.
For example i have a file called Temp.txt having content
Temp.txt
-----------------
100,234,M1234
400,234,K1734
300,345,T3456
----------------
So the modified file output should... (4 Replies)
Discussion started by: rpadhi
4 Replies
5. UNIX for Dummies Questions & Answers
Hi
I am looking for a particular string in a file.If the string exists, then I want to replace another string with some other text.Once replaced, search for the same text after that character position in the file. :wall:
E.g: Actual File content:
Hello
Name: Nitin Raj
Welcome to Unix... (4 Replies)
Discussion started by: dashing201
4 Replies
6. Shell Programming and Scripting
here is what i want to achieve... consider a file contains below contents. the file size is large about 60mb
cat dump.sql
INSERT INTO `table1` (`id`, `action`, `date`, `descrip`, `lastModified`) VALUES (1,'Change','2011-05-05 00:00:00','Account Updated','2012-02-10... (10 Replies)
Discussion started by: vivek d r
10 Replies
7. Shell Programming and Scripting
I am having a text file which is having more than 200 lines.
EX:
001010122 12000 BIB 12000 11200 1200003
001010122 2000 AND 12000 11200 1200003
001010122 12000 KVB 12000 11200 1200003
In the above file i want to search for string KVB and add/replace... (1 Reply)
Discussion started by: suryanarayana
1 Replies
8. Shell Programming and Scripting
Hi,
i have a text file as :
abc 0 1 Pass
hjk 1 1 Pass
bhk 0 0 Fail
jjh 8 2 Pass
nkji 0 1 Pass
Now I want to check that if 1st column is jjh , then , store the value of 3rd string of that line in a variable. Hence, 2... (8 Replies)
Discussion started by: Anamika08
8 Replies
9. Shell Programming and Scripting
Hi,
I have a file with multiple lines(fixed width dat file). I want to search for '02' in the positions 45-46 and if available, in that lines, I need to replace value in position 359 with blank. As I am new to unix, I am not able to figure out how to do this. Can you please help me to achieve... (9 Replies)
Discussion started by: Pradhikshan
9 Replies
10. UNIX for Dummies Questions & Answers
I am trying to replace the string in position 26 through 35 of the data file with 10 spaces and I want the remaining file to stay as is, the record length is over 900 characters? I am trying to use the AWK and substr but I am not getting it formatted correctly.
Before... (6 Replies)
Discussion started by: fnwine1500
6 Replies
LEARN ABOUT OPENSOLARIS
dat_rmr_query
dat_rmr_query(3DAT) Direct Access Transport Library Functions dat_rmr_query(3DAT)
NAME
dat_rmr_query - provide RMR parameters
SYNOPSIS
cc [ flag... ] file... -ldat [ library... ]
#include <dat/udat.h>
DAT_RETURN
dat_rmr_query (
IN DAT_RMR_HANDLE rmr_handle,
IN DAT_RMR_PARAM_MASK rmr_param_mask,
OUT DAT_RMR_PARAM *rmr_param
)
PARAMETERS
rmr_handle Handle for an instance of the RMR.
rmr_param_mask Mask for RMR parameters.
rmr_param Pointer to a Consumer-allocated structure that the Provider fills with RMR parameters.
DESCRIPTION
The dat_rmr_query() function provides RMR parameters to the Consumer. The Consumer passes in a pointer to the Consumer-allocated structures
for RMR parameters that the Provider fills.
The rmr_param_mask parameter allows Consumers to specify which parameters to query. The Provider returns values for rmr_param_mask
requested parameters. The Provider can return values for any other parameters.
Not all parameters can have a value at all times. For example, lmr_handle, target_address, segment_length, mem_privileges, and rmr_context
are not defined for an unbound RMR.
RETURN VALUES
DAT_SUCCESS The operation was successful.
DAT_INVALID_PARAMETER The rmr_param_mask parameter is invalid.
DAT_INVALID_HANDLE The mr_handle parameter is invalid.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Interface Stability |Standard: uDAPL, 1.1, 1.2 |
+-----------------------------+-----------------------------+
|MT-Level |Unsafe |
+-----------------------------+-----------------------------+
SEE ALSO
libdat(3LIB), attributes(5)
SunOS 5.11 16 Jul 2004 dat_rmr_query(3DAT)