question Re: how to sort the file name in shell script in Archives of Support Questions (Read Only)

how to sort the file name in shell script

lsundar19 — Fri, 13 Jul 2018 15:06:57 GMT

How to sort the filename in shell.

My files looks like

abcd_2_20180703

abcd_4_20180703

abcd_5_20180703

abcd_1_20180703

abcd_3_20180703

abcd_6_20180703

And i expect after the sorting

abcd_1_20180703

abcd_2_20180703

abcd_3_20180703

abcd_5_20180703

Please help me sort the files. TIA

Re: how to sort the file name in shell script

sandyy006 — Fri, 13 Jul 2018 17:01:04 GMT

@Sundar Lakshmanan

You can simply use "sort" command.

[root@node1 ~]# cat /tmp/a.txt
abcd_2_20180703
abcd_4_20180703
abcd_5_20180703
abcd_1_20180703
abcd_3_20180703
abcd_6_20180703


[root@node1 ~]# sort /tmp/a.txt
abcd_1_20180703
abcd_2_20180703
abcd_3_20180703
abcd_4_20180703
abcd_5_20180703
abcd_6_20180703

Let me know if this helps.

Re: how to sort the file name in shell script

lsundar19 — Sun, 15 Jul 2018 14:01:16 GMT

@Sandeep Nemuri

Thanks for your reply. the above sort will give correct output if the directory have only one day files.

if the directory have 20180704 files.

it sorted output like

abcd_1_20180703

abcd_1_20180704

abcd_2_20180703

abcd_2_20180704

abcd_3_20180703

abcd_3_20180704

abcd_4_20180703

abcd_4_20180704

abcd_5_20180703

abcd_5_20180704

abcd_6_20180703

abcd_6_20180704

But i expect

abcd_1_20180703

abcd_2_20180703

abcd_3_20180703

abcd_4_20180703

abcd_5_20180703

abcd_6_20180703

abcd_1_20180704

abcd_2_20180704

abcd_3_20180704

abcd_4_20180704

abcd_5_20180704

abcd_6_20180704

Any idea?

Re: how to sort the file name in shell script

rguruvannagari — Sun, 15 Jul 2018 14:53:55 GMT

@Sundar Lakshmanan

Try sort with delimiter

# ls -1 | sort -t '_' -nk3

# ls -1 | sort -t '_' -nk3
abcd_1_20180703
abcd_2_20180703
abcd_3_20180703
abcd_4_20180703
abcd_5_20180703
abcd_6_20180703
abcd_1_20180704
abcd_2_20180704
abcd_3_20180704
abcd_4_20180704
abcd_5_20180704
abcd_6_20180704

#cat test.out  | sort -t '_' -nk3

Re: how to sort the file name in shell script

sandyy006 — Sun, 15 Jul 2018 16:34:52 GMT

@Sundar Lakshmanan "sort" was for the requirement this is mentioned in the question details. You can use the command which @rguruvannagari has mentioned in the above comment to sort with the date (3rd column).

Re: how to sort the file name in shell script

lsundar19 — Sun, 15 Jul 2018 20:56:20 GMT

Thanks @ Sandeep Nemuri @ rguruvannagari works fine