Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Is this sort working as it is supposed to be? A bit confused whether it is sorting correctly or not
Top Forums UNIX for Beginners Questions & Answers Is this sort working as it is supposed to be? A bit confused whether it is sorting correctly or not Post 303036026 by newbie_01 on Wednesday 12th of June 2019 11:01:53 PM
Old 06-13-2019
@Jim

Not sure if this is what you are after. That is my first thought too, there is a special / hidden / unprintable character somewhere.

Please find below echo and the sort and OS flavor.

The one that RudiC suggested works find. I've also uploaded the test.txt file if you still want to give it a go.

Code:
$ echo 'SYS|PSTUBTBL|TABLE' | od -c
0000000   S   Y   S   |   P   S   T   U   B   T   B   L   |   T   A   B
0000020   L   E  \n
0000023
$ echo 'SYS|WRI$_ADV_ASA_RECO_DATA|TABLE' | od -c
0000000   S   Y   S   |   W   R   I   $   _   A   D   V   _   A   S   A
0000020   _   R   E   C   O   _   D   A   T   A   |   T   A   B   L   E
0000040  \n
0000041
$ view xx.txt
$ echo 'SYSTEM|OL$HINTS|TABLE' | od -c
0000000   S   Y   S   T   E   M   |   O   L   $   H   I   N   T   S   |
0000020   T   A   B   L   E  \n
0000026
$ echo 'SYSTEM|OL$NODES|TABLE' | od -c
0000000   S   Y   S   T   E   M   |   O   L   $   N   O   D   E   S   |
0000020   T   A   B   L   E  \n
0000026


$ sort -t"|" -k1,1 test.txt
MDSYS|OGIS_GEOMETRY_COLUMNS|TABLE
MDSYS|OGIS_SPATIAL_REFERENCE_SYSTEMS|TABLE
MDSYS|SDO_IDX_TAB_SEQUENCE|SEQUENCE
MDSYS|SDO_PREFERRED_OPS_USER|TABLE
MDSYS|SDO_ST_TOLERANCE|TABLE
MDSYS|SDO_TOPO_DATA$|TABLE
MDSYS|SDO_TOPO_RELATION_DATA|TABLE
MDSYS|SDO_TOPO_TRANSACT_DATA$|VIEW
MDSYS|SDO_TXN_IDX_DELETES|TABLE
MDSYS|SDO_TXN_IDX_EXP_UPD_RGN|TABLE
MDSYS|SDO_TXN_IDX_INSERTS|TABLE
MDSYS|SRSNAMESPACE_TABLE|TABLE
MDSYS|USER_ANNOTATION_TEXT_METADATA|VIEW
MDSYS|USER_SDO_3DTHEMES|VIEW
MDSYS|USER_SDO_3DTXFMS|VIEW
MDSYS|USER_SDO_ANIMATIONS|VIEW
MDSYS|USER_SDO_CACHED_MAPS|VIEW
MDSYS|USER_SDO_GEOM_METADATA|VIEW
MDSYS|USER_SDO_LIGHTSOURCES|VIEW
MDSYS|USER_SDO_LRS_METADATA|VIEW
MDSYS|USER_SDO_MAPS|VIEW
MDSYS|USER_SDO_SCENES|VIEW
MDSYS|USER_SDO_STYLES|VIEW
MDSYS|USER_SDO_THEMES|VIEW
MDSYS|USER_SDO_VIEWFRAMES|VIEW
ORDDATA|ORDDCM_CONFORMANCE_VLD_MSGS|VIEW
OUTLN|OL$HINTS|TABLE
OUTLN|OL$NODES|TABLE
SYS|DATA_PUMP_XPL_TABLE$|TABLE
SYS|IMPDP_STATS|INDEX
SYS|IMPDP_STATS|TABLE
SYS|KU$_DATAPUMP_MASTER_10_1|TABLE
SYS|KU$_DATAPUMP_MASTER_11_1_0_7|TABLE
SYS|KU$_DATAPUMP_MASTER_11_1|TABLE
SYS|KU$_DATAPUMP_MASTER_11_2|TABLE
SYS|KU$_LIST_FILTER_TEMP_2|TABLE
SYS|KU$_LIST_FILTER_TEMP|TABLE
SYS|KU$NOEXP_TAB|TABLE
SYS|KU$XKTFBUE|TABLE
SYS|ODCI_SECOBJ$|TABLE
SYS|ODCI_WARNINGS$|TABLE
SYS|PLAN_TABLE$|TABLE
SYS|PSTUBTBL|TABLE
SYS|WRI$_ADV_ASA_RECO_DATA|TABLE
SYSTEM|OL$HINTS|TABLE
SYSTEM|OL$NODES|TABLE
XDB|PATH_VIEW|VIEW
XDB|RESOURCE_VIEW|VIEW
XDB|XDB$ACL|TABLE
XDB|XDB$IMPORT_TT_INFO|TABLE
XDB|XDB$RESCONFIG|TABLE
XDB|XDB$XIDX_IMP_T|TABLE


$ sort test.txt
MDSYS|OGIS_GEOMETRY_COLUMNS|TABLE
MDSYS|OGIS_SPATIAL_REFERENCE_SYSTEMS|TABLE
MDSYS|SDO_IDX_TAB_SEQUENCE|SEQUENCE
MDSYS|SDO_PREFERRED_OPS_USER|TABLE
MDSYS|SDO_ST_TOLERANCE|TABLE
MDSYS|SDO_TOPO_DATA$|TABLE
MDSYS|SDO_TOPO_RELATION_DATA|TABLE
MDSYS|SDO_TOPO_TRANSACT_DATA$|VIEW
MDSYS|SDO_TXN_IDX_DELETES|TABLE
MDSYS|SDO_TXN_IDX_EXP_UPD_RGN|TABLE
MDSYS|SDO_TXN_IDX_INSERTS|TABLE
MDSYS|SRSNAMESPACE_TABLE|TABLE
MDSYS|USER_ANNOTATION_TEXT_METADATA|VIEW
MDSYS|USER_SDO_3DTHEMES|VIEW
MDSYS|USER_SDO_3DTXFMS|VIEW
MDSYS|USER_SDO_ANIMATIONS|VIEW
MDSYS|USER_SDO_CACHED_MAPS|VIEW
MDSYS|USER_SDO_GEOM_METADATA|VIEW
MDSYS|USER_SDO_LIGHTSOURCES|VIEW
MDSYS|USER_SDO_LRS_METADATA|VIEW
MDSYS|USER_SDO_MAPS|VIEW
MDSYS|USER_SDO_SCENES|VIEW
MDSYS|USER_SDO_STYLES|VIEW
MDSYS|USER_SDO_THEMES|VIEW
MDSYS|USER_SDO_VIEWFRAMES|VIEW
ORDDATA|ORDDCM_CONFORMANCE_VLD_MSGS|VIEW
OUTLN|OL$HINTS|TABLE
OUTLN|OL$NODES|TABLE
SYS|DATA_PUMP_XPL_TABLE$|TABLE
SYS|IMPDP_STATS|INDEX
SYS|IMPDP_STATS|TABLE
SYS|KU$_DATAPUMP_MASTER_10_1|TABLE
SYS|KU$_DATAPUMP_MASTER_11_1_0_7|TABLE
SYS|KU$_DATAPUMP_MASTER_11_1|TABLE
SYS|KU$_DATAPUMP_MASTER_11_2|TABLE
SYS|KU$_LIST_FILTER_TEMP_2|TABLE
SYS|KU$_LIST_FILTER_TEMP|TABLE
SYS|KU$NOEXP_TAB|TABLE
SYS|KU$XKTFBUE|TABLE
SYS|ODCI_SECOBJ$|TABLE
SYS|ODCI_WARNINGS$|TABLE
SYS|PLAN_TABLE$|TABLE
SYS|PSTUBTBL|TABLE
SYSTEM|OL$HINTS|TABLE
SYSTEM|OL$NODES|TABLE
SYS|WRI$_ADV_ASA_RECO_DATA|TABLE
XDB|PATH_VIEW|VIEW
XDB|RESOURCE_VIEW|VIEW
XDB|XDB$ACL|TABLE
XDB|XDB$IMPORT_TT_INFO|TABLE
XDB|XDB$RESCONFIG|TABLE
XDB|XDB$XIDX_IMP_T|TABLE


$ uname -a
Linux [hostname] 2.6.18-419.el5 #1 SMP Wed Feb 22 22:40:57 EST 2017 x86_64 x86_64 x86_64 GNU/Linux
$ cat redhat-release
Red Hat Enterprise Linux Server release 5.11 (Tikanga)

test.txt (1.5 KB) 
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Script not working correctly

I have a simple script that I want to run every 30 minutes but only when I execute it. I don't want it to be a crontab job. so i have for example date ls -l who sleep 1800 The first time it executes correctly but after the first time it nevers execute back again. It should execute after... (2 Replies)
Discussion started by: elchalateco
2 Replies

2. Shell Programming and Scripting

if not working correctly

Anyone have an idea why this if statement does not work correctly? "test2.sh" 18 lines, 386 characters #!/usr/bin/sh WARNING=80 CRITICAL=95 check_it() { if ] || ];then echo "YES ] || ]" else echo "NO ] || ]" fi } check_it 80.1 check_it 81.1 (3 Replies)
Discussion started by: 2dumb
3 Replies

3. Shell Programming and Scripting

Variable not working correctly.

Hi, I have a script where I am trying to set a local variable using the following, MYVAR="$NAME"_"$NAME2".txt where say, NAME = one NAME2 = two so I want the output one_two.txt but what I am getting is, two.txt basically the $NAME2 is overwriting, what am I doing wrong? ... (3 Replies)
Discussion started by: walsh_j
3 Replies

4. Programming

Shell Implementation not working correctly

//save in/out int tmpin = dup(0); int tmpout = dup(1); //set initial input int fdin; if(_inputFile) { fdin = open(_inputFile, O_RDONLY | O_CREAT, S_IREAD | S_IWRITE); } else { //use default input fdin = dup(tmpin); } int ret; int fdout; for(int i = 0; i... (14 Replies)
Discussion started by: AirBronto
14 Replies

5. Shell Programming and Scripting

rsync is not correctly working

We are using Red Hat linux system. I am transferring my rman backup files to another server. Here is the command i am using to transfer the files. /usr/bin/rsync -avpP --delete /xyz/xyz/ 99.99.999.99::db110bkp Here is the rsync version. >rsync --version rsync version 3.0.6 ... (1 Reply)
Discussion started by: govindts
1 Replies

6. Programming

I am a little bit confused in a socket example through select()

Hi, I am a newbie about network programming. All codes come from this book: UNIX Network Programming Volume 1, Third Edition. It is a TCP server by use select() int main(int argc, char **argv) { int i, maxi, maxfd, listenfd, connfd, sockfd; int ... (2 Replies)
Discussion started by: sehang
2 Replies

7. UNIX for Dummies Questions & Answers

Grep Regexp not working correctly

Consider the following code: grep -o -e '^STEAM_::\d+$' workfile3.tmp A sample format of a valid string for the regexp would be: STEAM_0:1:12345678 Here is an example line from the workfile3.tmp file: 465:L 01/02/2012 - 00:05:33: "Spartan1-1-7<8><STEAM_0:1:47539638><>" connected No... (2 Replies)
Discussion started by: spinner0205
2 Replies

8. Shell Programming and Scripting

awk not working correctly

Hi I am attempting to right a script which will read a table and extract specfic information. LASTFAILEDJOB=/usr/openv/netbackup/scripts/GB-LDN/Junaid/temp_files/lastfailedjob cat /usr/openv/netbackup/scripts/GB-LDN/Junaid/temp_files/lastfailedjob 237308646 If i run the following... (5 Replies)
Discussion started by: Junes
5 Replies

9. UNIX for Dummies Questions & Answers

vnc No Longer Working Correctly

Hello All, Yesterday, all day, I was using x11vnc and vncviewer to connect to a server. But today for some reason it is not working. I don't remember changing any settings or anything like that, but because it stopped working correctly I guess something has...? I'm issuing the exact same... (0 Replies)
Discussion started by: mrm5102
0 Replies

10. UNIX for Beginners Questions & Answers

Are the brains of the UNIXoid working correctly?

Today I saw the topic. sum-even-numbers-1-100 At that time, it was already closed but not the point. Other thoughts came to mind. All newcomers to Haskell are afraid that when they study it, their brains will turn inside out. I did not notice anything like that. And all because the brains of all... (4 Replies)
Discussion started by: nezabudka
4 Replies
All times are GMT -4. The time now is 09:08 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy