would you please give me brief explanation about
thanks again.
---------- Post updated at 11:10 AM ---------- Previous update was at 10:32 AM ----------
Quote:
Originally Posted by RavinderSingh13
Hello ken6503,
Could you please try following, it may help you.
Output will be as follows. EDIT: Adding a non one liner form for same.
Thanks,
R. Singh
Thanks R.Singh.
the code works.
I have some questions about this code.
1. what is the difference between "gsub(/s\(/,X,$NF)" and "gsub(/s\(/,"",$NF)"
2. Is it necessary to read the file twice? in the code, think it only execute NR==FNR.
I tried below code, the results are same
1. what is the difference between "gsub(/s\(/,X,$NF)" and "gsub(/s\(/,"",$NF)"
2. Is it necessary to read the file twice? in the code, think it only execute NR==FNR.
I tried below code, the results are same
Hello Ken6503,
For 1st query: gsub(/s\(/,X,$NF) means it will substitute strings (/ and \)with NULL value. (I have used \(/ because (,) are meta characters and to
tell awk not to take their special meaning and take characters as it is we use escape character \)
For 2nd query:
Thank you for pointing out same, Yes you are right we can we can read the file once also, so no need to put FNR==NR condition in it,
so code can be reduce to as follows.(Not tested in different scenarios)
Output will be as follows.
Thanks,
R. Singh
Last edited by RavinderSingh13; 01-14-2015 at 01:55 PM..
This User Gave Thanks to RavinderSingh13 For This Post:
if (!s[d[i++]]) print d[i-1] print d[i-1] if hash s[d[i++]] doesn't exist.
s is array with hash index where hash is field 1.
d is array with number index and contains field 3.
I use array with number index to preserve entry order.
This User Gave Thanks to disedorgue For This Post:
i need to add 2 string variables into a positioning array , repeatedly - in loop.
First string in $2, second to $3 then up to the desired count incrementing the "position".
Using set -- alone does not increment the count so I end up with 2 variables in the array.
How do I increment the... (7 Replies)
Hi All,
I currently have flat file with 32 columns. The field delimiter is cntl-A ( \x01). The file has been extracted from an oracle table using a datastage job. However, in the 6th field, the data contains additional control -A characters which came as a part of the table data.
I need... (12 Replies)
I have a postgres sql statement that is the following:
select age from students;
which gives me the entries:
Age
---
10
15
13
12
9
14
10
which is about 7 rows of data.
Now what I would like to do with this is use a shell script to create an array age. As a results... (3 Replies)
Hi Experts,
How to sepearate the list digit with letters : with a space from where the letters begins, or other words from where the digits ended.
file
52087mo(enbatl)
52049mo(enbatl)
52085mo(enbatl)
25051mo(enbatl)
The output should be looks like:
52087 mo(enbatl)
52049... (10 Replies)
I want to strip first few characters from each record until a proper datesamp is found.
Request for getNextPage.................06/29/12 07:49:30 VVUKOVIC@67.208.166.131{7A805FEF76A62FCBB23EA78B5380EF95.tomcat1}TP-Processor14 LogExchUsage: ERROR:: isprof=false : exch=NSDQ
output should be... (2 Replies)
I need to separate Pascal style identifiers (TheyLookLikeThis) into words separated by an underscore (_).
I've tried sed 's//&_&/' but this won't work (obviously). I'd love some help. (4 Replies)
Hi,
I would write a shell script to execute a series of command. However, if the cmd contains "-" in the array. It fails to do so.
I'd tried use ', " or \ but get the same result.
Output: (1 Reply)
Hi,
I wish to store $string1 in $string1array a character in each array element.
Then i wish to echo the entire array to the screen so that it reads as the normal string again.
I have been trying with the code below but does not work. Please help...
To put string into array:
... (5 Replies)
Hi,
Could anybody please guide how to strip all charaters after the last '/' from a string in a shell script.
I have got few strings like
"/tmp/oracle/oradata1/abc" or "/var/log/backup/bdfd" and I want to strip anything after the last "/" i.e "abc" and "bdfd" in my case.
Thanks,
Jamal (3 Replies)