sorry If I am not clear. Basically my input is like below with ID's. I want to sort 4th columns with the hierarchy sort as MANUAL,POO TO etc . I have added expected output below
Applying copious amounts of phantasy, (or wildly guessing, whatever you prefer) let me try to paraphrase your request, which, btw, dramatically changed during the course of the thread:
A file of records consisting of fields separated by "~" needs to be rearranged by a sub field of the 4th field which in turn is separated by "->". I use the term "rearranged" as I can't dream up an algorithm to sort character B after P after M. The algorithm with which to rearrange is not defined.
From a row delimited by ~ take the 4th field and from that delimited by > take the last record and group record based on the entire row . I don't need to sort I need to group basically it is ending in sort. As you mentioned I am not worried about where B comes. I need to group MANUAL and others If any it can be of any order.
The desired output can be in a form below.
OR
OR
Last edited by arunkumar_mca; 10-05-2017 at 09:05 AM..
oops it is not last record it is second last . My bad.
When I mean entire row is the the record group needs to with ID as shown in example. I need to ID to be preserved with the grouping. I the example below the ID associated with the records needs be stick to it where the record moved based on grouping
Dear Team
I am using DB2 v9 .
I have a condition to check roles based on hierarchies like below example.
1.Ramesh has Roles as "Manager" and "Interviewer"
2.KITS has Roles as "Interviewer"
3.ANAND has Roles as "Manager" and "Interviewer"
select * FROM TESTING
NAME ... (6 Replies)
Hi,
I have a file with the following structure
M17XX-050-01-001 1100000000
A16 1.341E+05
...
B18 3.084E+02
total 1.344E+05
XY35 5.694E+03
...
XY241 6.725E+02
total 9.897E+05
Wr81Z 5.195E+00
...
Wr91Z 1.029E+02
Wr92Z 1.285E+02
total 9.897E+05
M17XX-050-01-001 1010000000... (2 Replies)
Hi all,
I would like to know the difference between the different dir structures present in solaris!!!
Meaning what does /usr contain, /etc ,/opt/ ,so on...
I know what /usr and /etc are used for.
But why are /opt /bin /sbin /var and many more that i have missed
I would appreciate if... (1 Reply)
Hi,
Please have a look this: http://tldp.org/LDP/Linux-Filesystem-Hierarchy/Linux-Filesystem-Hierarchy.pdf
I think this can be very useful for a beginner/intermediate level user to understand the filesystem hierarchy and as well as it can be used as a reference to various linux commands and... (0 Replies)
Hi guys.
I'm willing to copy a specific file system hierarchy, but I would not like to maintain the directory tree organization.
For example:
Let's say /a/b/c is the fs I'm wanting to copy to my destination,
and that c is a directory with 30 files, 10 on /a/b/c , 10 on a/b/c/c1 and 10... (2 Replies)
I'm new to shell scripting and I'm having a tough time figuring out how to script something. Can anyone help?
Here is my setup and what I want to do:
A directory contains a list of projects by year (2000, 2001, etc) and customers (01-001) all of which have the same internal directory setup... (3 Replies)