Strange sort -r results


 
Thread Tools Search this Thread
Top Forums UNIX for Beginners Questions & Answers Strange sort -r results
# 1  
Old 11-20-2018
Strange sort -r results

Hi Folks -


I have this file that looks like this:

Code:
 outbox/logs/Client_1042.log
 outbox/logs/Client_941.log
 outbox/logs/Client_942.log
 outbox/logs/Client_943.log
 outbox/logs/Client_944.log

And this is my code:
Code:
#!/bin/bash
_OUTBOX_BIN="outbox/logs/"
_NAME="Client"
_TEMP="temp.txt"
_FDMEE_LOG="$(sort -r ${_TEMP} | sed -n "\#${_OUTBOX_BIN}${_NAME}_# {s#.*/##; p; q}").log"

echo $_FDMEE_LOG

And I need it to return the file suffix with the highest numerical value. Therefore it should return 1042 but instead it's returning Client_944.log. Do you know why?


Thanks!

Last edited by Scrutinizer; 11-20-2018 at 12:21 PM.. Reason: quote tags -> code tags
# 2  
Old 11-20-2018
Code:
awk -F'[_.]' '{print $(NF-1)}' myFile | sort -rn | head -1

# 3  
Old 11-20-2018
Sorry, I only gave am example. Here is the full file I am working with. Getting an error with your suggestion.


It should return "Client_1042.log"


Code:
 AP_Backup 18-09-12.zip
 apr/2018-09-20 09_11_03/2018-09-20 09_11_03.html
 apr/2018-09-20 09_11_03/access_log.zip
 apr/2018-09-21 09_10_57/2018-09-21 09_10_57.html
 apr/2018-09-21 09_10_57/access_log.zip
 apr/2018-09-22 09_10_42/2018-09-22 09_10_42.html
 apr/2018-09-22 09_10_42/access_log.zip
 apr/2018-09-23 09_10_01/2018-09-23 09_10_01.html
 apr/2018-09-23 09_10_01/access_log.zip
 apr/2018-09-24 09_10_13/2018-09-24 09_10_13.html
 apr/2018-09-24 09_10_13/access_log.zip
 apr/2018-09-25 09_10_59/2018-09-25 09_10_59.html
 apr/2018-09-25 09_10_59/access_log.zip
 apr/2018-09-26 09_11_06/2018-09-26 09_11_06.html
 apr/2018-09-26 09_11_06/access_log.zip
 apr/2018-09-27 09_11_09/2018-09-27 09_11_09.html
 apr/2018-09-27 09_11_09/access_log.zip
 apr/2018-09-28 09_17_10/2018-09-28 09_17_10.html
 apr/2018-09-28 09_17_10/access_log.zip
 apr/2018-09-29 09_10_56/2018-09-29 09_10_56.html
 apr/2018-09-29 09_10_56/access_log.zip
 apr/2018-09-30 09_10_39/2018-09-30 09_10_39.html
 apr/2018-09-30 09_10_39/access_log.zip
 apr/2018-10-01 09_10_58/2018-10-01 09_10_58.html
 apr/2018-10-01 09_10_58/access_log.zip
 apr/2018-10-02 09_11_15/2018-10-02 09_11_15.html
 apr/2018-10-02 09_11_15/access_log.zip
 apr/2018-10-03 09_11_09/2018-10-03 09_11_09.html
 apr/2018-10-03 09_11_09/access_log.zip
 apr/2018-10-04 09_11_04/2018-10-04 09_11_04.html
 apr/2018-10-04 09_11_04/access_log.zip
 apr/2018-10-05 09_11_12/2018-10-05 09_11_12.html
 apr/2018-10-05 09_11_12/access_log.zip
 apr/2018-10-06 09_13_52/2018-10-06 09_13_52.html
 apr/2018-10-06 09_13_52/access_log.zip
 apr/2018-10-07 09_11_59/2018-10-07 09_11_59.html
 apr/2018-10-07 09_11_59/access_log.zip
 apr/2018-10-08 09_10_54/2018-10-08 09_10_54.html
 apr/2018-10-08 09_10_54/access_log.zip
 apr/2018-10-09 09_11_26/2018-10-09 09_11_26.html
 apr/2018-10-09 09_11_26/access_log.zip
 apr/2018-10-10 09_11_22/2018-10-10 09_11_22.html
 apr/2018-10-10 09_11_22/access_log.zip
 apr/2018-10-11 09_10_49/2018-10-11 09_10_49.html
 apr/2018-10-11 09_10_49/access_log.zip
 apr/2018-10-12 09_11_17/2018-10-12 09_11_17.html
 apr/2018-10-12 09_11_17/access_log.zip
 apr/2018-10-13 09_11_57/2018-10-13 09_11_57.html
 apr/2018-10-13 09_11_57/access_log.zip
 apr/2018-10-14 09_10_28/2018-10-14 09_10_28.html
 apr/2018-10-14 09_10_28/access_log.zip
 apr/2018-10-15 09_10_33/2018-10-15 09_10_33.html
 apr/2018-10-15 09_10_33/access_log.zip
 apr/2018-10-16 09_11_37/2018-10-16 09_11_37.html
 apr/2018-10-16 09_11_37/access_log.zip
 apr/2018-10-17 09_12_29/2018-10-17 09_12_29.html
 apr/2018-10-17 09_12_29/access_log.zip
 apr/2018-10-18 09_11_48/2018-10-18 09_11_48.html
 apr/2018-10-18 09_11_48/access_log.zip
 apr/2018-10-19 09_12_05/2018-10-19 09_12_05.html
 apr/2018-10-19 09_12_05/access_log.zip
 apr/2018-10-20 09_12_06/2018-10-20 09_12_06.html
 apr/2018-10-20 09_12_06/access_log.zip
 apr/2018-10-21 09_10_39/2018-10-21 09_10_39.html
 apr/2018-10-21 09_10_39/access_log.zip
 apr/2018-10-22 09_11_06/2018-10-22 09_11_06.html
 apr/2018-10-22 09_11_06/access_log.zip
 apr/2018-10-23 09_11_39/2018-10-23 09_11_39.html
 apr/2018-10-23 09_11_39/access_log.zip
 apr/2018-10-24 09_11_44/2018-10-24 09_11_44.html
 apr/2018-10-24 09_11_44/access_log.zip
 apr/2018-10-25 09_11_08/2018-10-25 09_11_08.html
 apr/2018-10-25 09_11_08/access_log.zip
 apr/2018-10-26 09_11_25/2018-10-26 09_11_25.html
 apr/2018-10-26 09_11_25/access_log.zip
 apr/2018-10-27 09_11_17/2018-10-27 09_11_17.html
 apr/2018-10-27 09_11_17/access_log.zip
 apr/2018-10-28 09_10_27/2018-10-28 09_10_27.html
 apr/2018-10-28 09_10_27/access_log.zip
 apr/2018-10-29 09_10_44/2018-10-29 09_10_44.html
 apr/2018-10-29 09_10_44/access_log.zip
 apr/2018-10-30 09_11_17/2018-10-30 09_11_17.html
 apr/2018-10-30 09_11_17/access_log.zip
 apr/2018-10-31 09_11_39/2018-10-31 09_11_39.html
 apr/2018-10-31 09_11_39/access_log.zip
 apr/2018-11-01 09_12_37/2018-11-01 09_12_37.html
 apr/2018-11-01 09_12_37/access_log.zip
 apr/2018-11-02 09_11_40/2018-11-02 09_11_40.html
 apr/2018-11-02 09_11_40/access_log.zip
 apr/2018-11-03 09_14_18/2018-11-03 09_14_18.html
 apr/2018-11-03 09_14_18/access_log.zip
 apr/2018-11-04 09_11_18/2018-11-04 09_11_18.html
 apr/2018-11-04 09_11_18/access_log.zip
 apr/2018-11-05 09_11_19/2018-11-05 09_11_19.html
 apr/2018-11-05 09_11_19/access_log.zip
 apr/2018-11-06 09_15_46/2018-11-06 09_15_46.html
 apr/2018-11-06 09_15_46/access_log.zip
 apr/2018-11-07 09_15_13/2018-11-07 09_15_13.html
 apr/2018-11-07 09_15_13/access_log.zip
 apr/2018-11-08 09_12_04/2018-11-08 09_12_04.html
 apr/2018-11-08 09_12_04/access_log.zip
 apr/2018-11-09 09_12_36/2018-11-09 09_12_36.html
 apr/2018-11-09 09_12_36/access_log.zip
 apr/2018-11-10 09_16_32/2018-11-10 09_16_32.html
 apr/2018-11-10 09_16_32/access_log.zip
 apr/2018-11-11 09_12_30/2018-11-11 09_12_30.html
 apr/2018-11-11 09_12_30/access_log.zip
 apr/2018-11-12 09_25_11/2018-11-12 09_25_11.html
 apr/2018-11-12 09_25_11/access_log.zip
 apr/2018-11-13 09_12_24/2018-11-13 09_12_24.html
 apr/2018-11-13 09_12_24/access_log.zip
 apr/2018-11-14 09_14_43/2018-11-14 09_14_43.html
 apr/2018-11-14 09_14_43/access_log.zip
 apr/2018-11-15 09_12_42/2018-11-15 09_12_42.html
 apr/2018-11-15 09_12_42/access_log.zip
 apr/2018-11-16 09_12_51/2018-11-16 09_12_51.html
 apr/2018-11-16 09_12_51/access_log.zip
 apr/2018-11-17 09_13_23/2018-11-17 09_13_23.html
 apr/2018-11-17 09_13_23/access_log.zip
 apr/2018-11-18 09_12_35/2018-11-18 09_12_35.html
 apr/2018-11-18 09_12_35/access_log.zip
 apr/2018-11-19 09_12_37/2018-11-19 09_12_37.html
 apr/2018-11-19 09_12_37/access_log.zip
 apr/2018-11-20 09_13_06/2018-11-20 09_13_06.html
 apr/2018-11-20 09_13_06/access_log.zip
 Artifact Snapshot.zip
 Backup 18-10-31.zip
 Backup 18-11-05.zip
 Backup 18-11-13.zip
 Backup 18-11-15.zip
 Backup_Friday.zip
 Backup_Wednesday.zip
 data/24720211231.xlsx
 data/24920211231.xlsx
 data/25020211231.csv
 data/25120211231.csv
 data/25420211231.csv
 data/26720180930.dat
 data/26820180930.dat
 data/26920180930.dat
 data/27020180930.dat
 data/27120180930.dat
 data/AClient-Vendor_253.json
 data/AClient-Vendor_255.json
 data/AClient-Vendor_731.json
 data/Client_248.json
 data/Client_291.json
 data/Client_307.json
 data/Client_311.json
 data/Client_692.json
 data/Client_867.json
 data/ClientHolding_1000.dat
 data/ClientHolding_1001.dat
 data/ClientHolding_1002.dat
 data/ClientHolding_1003.dat
 data/ClientHolding_1004.dat
 data/ClientHolding_1007.dat
 data/ClientHolding_1008.dat
 data/ClientHolding_1009.dat
 data/ClientHolding_1010.dat
 data/ClientHolding_1011.dat
 data/ClientHolding_1012.dat
 data/ClientHolding_1013.dat
 data/ClientHolding_1014.dat
 data/ClientHolding_1015.dat
 data/ClientHolding_1016.dat
 data/ClientHolding_1041.dat
 data/ClientHolding_1042.dat
 data/ClientHolding_193_ECM.dat
 data/ClientHolding_194_ECM.dat
 data/ClientHolding_196_ECM.dat
 data/ClientHolding_262_ECM.dat
 data/ClientHolding_263_ECM.dat
 data/ClientHolding_267.dat
 data/ClientHolding_268.dat
 data/ClientHolding_269.dat
 data/ClientHolding_270.dat
 data/ClientHolding_271.dat
 data/ClientHolding_281.dat
 data/ClientHolding_282.dat
 data/ClientHolding_283.dat
 data/ClientHolding_297.dat
 data/ClientHolding_299.dat
 data/ClientHolding_300.dat
 data/ClientHolding_303.dat
 data/ClientHolding_304.dat
 data/ClientHolding_321.dat
 data/ClientHolding_357.dat
 data/ClientHolding_358.dat
 data/ClientHolding_359.dat
 data/ClientHolding_360.dat
 data/ClientHolding_361.dat
 data/ClientHolding_362.dat
 data/ClientHolding_363.dat
 data/ClientHolding_364.dat
 data/ClientHolding_365.dat
 data/ClientHolding_369.dat
 data/ClientHolding_370.dat
 data/ClientHolding_374.dat
 data/ClientHolding_375.dat
 data/ClientHolding_376.dat
 data/ClientHolding_377.dat
 data/ClientHolding_380.dat
 data/ClientHolding_381.dat
 data/ClientHolding_382.dat
 data/ClientHolding_383.dat
 data/ClientHolding_388.dat
 data/ClientHolding_425.dat
 data/ClientHolding_426.dat
 data/ClientHolding_440.dat
 data/ClientHolding_446.dat
 data/ClientHolding_448.dat
 data/ClientHolding_449.dat
 data/ClientHolding_450.dat
 data/ClientHolding_453.dat
 data/ClientHolding_455.dat
 data/ClientHolding_476.dat
 data/ClientHolding_481.dat
 data/ClientHolding_521.dat
 data/ClientHolding_522.dat
 data/ClientHolding_525.dat
 data/ClientHolding_535.dat
 data/ClientHolding_536.dat
 data/ClientHolding_585.dat
 data/ClientHolding_586.dat
 data/ClientHolding_587.dat
 data/ClientHolding_588.dat
 data/ClientHolding_589.dat
 data/ClientHolding_590.dat
 data/ClientHolding_591.dat
 data/ClientHolding_592.dat
 data/ClientHolding_593.dat
 data/ClientHolding_641.dat
 data/ClientHolding_642.dat
 data/ClientHolding_643.dat
 data/ClientHolding_644.dat
 data/ClientHolding_645.dat
 data/ClientHolding_646.dat
 data/ClientHolding_647.dat
 data/ClientHolding_749.dat
 data/ClientHolding_751.dat
 data/ClientHolding_762.dat
 data/ClientHolding_763.dat
 data/ClientHolding_781.dat
 data/ClientHolding_782.dat
 data/ClientHolding_783.dat
 data/ClientHolding_801_ECM.dat
 data/ClientHolding_802_ECM.dat
 data/ClientHolding_803_ECM.dat
 data/ClientHolding_805_ECM.dat
 data/ClientHolding_809_ECM.dat
 data/ClientHolding_810_ECM.dat
 data/ClientHolding_812_ECM.dat
 data/ClientHolding_813_ECM.dat
 data/ClientHolding_815_ECM.dat
 data/ClientHolding_816.dat
 data/ClientHolding_817.dat
 data/ClientHolding_821.dat
 data/ClientHolding_823.dat
 data/ClientHolding_852.dat
 data/ClientHolding_853.dat
 data/ClientHolding_854.dat
 data/ClientHolding_855.dat
 data/ClientHolding_856.dat
 data/ClientHolding_857.dat
 data/ClientHolding_858.dat
 data/ClientHolding_859.dat
 data/ClientHolding_860.dat
 data/ClientHolding_900.dat
 data/ClientHolding_907.dat
 data/ClientHolding_909.dat
 data/ClientHolding_910.dat
 data/ClientHolding_911.dat
 data/ClientHolding_912.dat
 data/ClientHolding_913.dat
 data/ClientHolding_914.dat
 data/ClientHolding_941.dat
 data/ClientHolding_942.dat
 data/ClientHolding_943.dat
 data/ClientHolding_944.dat
 data/ClientHolding_945.dat
 data/ClientHolding_946.dat
 data/ClientHolding_947.dat
 data/ClientHolding_948.dat
 data/ClientHolding_949.dat
 data/ClientHolding_951.dat
 data/ClientHolding_952.dat
 data/ClientHolding_953.dat
 data/ClientHolding_954.dat
 data/ClientHolding_955.dat
 data/ClientHolding_956.dat
 data/ClientHolding_957.dat
 data/ClientHolding_958.dat
 data/ClientHolding_959.dat
 data/ClientHolding_960.dat
 data/ClientHolding_961.dat
 data/ClientHolding_962.dat
 data/ClientHolding_963.dat
 data/ClientHolding_964.dat
 data/ClientHolding_965.dat
 data/ClientHolding_966.dat
 data/ClientHolding_967.dat
 data/ClientHolding_981.dat
 data/ClientHolding_982_ECM.dat
 data/ClientHolding_985.dat
 data/ClientHolding_987.dat
 data/ClientHolding_988.dat
 data/ClientHolding_989.dat
 data/ClientHolding_990.dat
 data/ClientHolding_991.dat
 data/ClientHolding_992.dat
 data/ClientHolding_993.dat
 data/ClientHolding_994.dat
 data/ClientHolding_995.dat
 data/ClientHolding_996.dat
 data/ClientHolding_997.dat
 data/ClientHolding_999.dat
 data/EPBCS Assignment Data_276.dat
 data/EPBCS Assignment Data_277.dat
 data/EPBCS Assignment Data_342.dat
 data/EPBCS Assignment Data_343.dat
 data/EPBCS Assignment Data_344.dat
 data/EPBCS Assignment Data_345.dat
 data/EPBCS Assignment Data_353.dat
 data/EPBCS Assignment Data_366.dat
 data/EPBCS Assignment Data_367.dat
 data/EPBCS Assignment Data_368.dat
 data/EPBCS Assignment Data_420.dat
 data/EPBCS Assignment Data_421.dat
 data/EPBCS Assignment Data_422.dat
 data/EPBCS Assignment Data_423.dat
 data/EPBCS Assignment Data_424.dat
 data/EPBCS Assignment Data_520.dat
 data/EPBCS Assignment Data_546.dat
 data/EPBCS Assignment Data_547.dat
 data/EPBCS Assignment Data_548.dat
 data/EPBCS Assignment Data_561.dat
 data/EPBCS Assignment Data_573.dat
 data/EPBCS Assignment Data_574.dat
 data/EPBCS Assignment Data_575.dat
 data/EPBCS Assignment Data_576.dat
 data/EPBCS Assignment Data_577.dat
 data/EPBCS Assignment Data_578.dat
 data/EPBCS Assignment Data_579.dat
 data/EPBCS Assignment Data_580.dat
 data/EPBCS Assignment Data_581.dat
 data/EPBCS Assignment Data_583.dat
 data/EPBCS Assignment Data_584.dat
 data/EPBCS Employee Metadata_346.dat
 data/EPBCS Employee Metadata_347.dat
 data/EPBCS Employee Metadata_348.dat
 data/EPBCS Employee Metadata_349.dat
 data/EPBCS Employee Metadata_350.dat
 data/EPBCS Employee Metadata_351.dat
 data/EPBCS Employee Metadata_352.dat
 data/EPBCS Employee Metadata_582.dat
 data/FGC_190_ECI.dat
 data/FGC_193_ECI.dat
 data/FGC_196_ECI.dat
 data/FGC_801_ECI.dat
 data/FGC_802_ECI.dat
 data/FGC_803_ECI.dat
 data/FGC_805_ECI.dat
 data/FGC_807_ECI.dat
 data/FGC_808_ECI.dat
 data/FGC_809_ECI.dat
 data/FGC_810_ECI.dat
 data/FGC_812_ECI.dat
 data/FGC_813_ECI.dat
 data/FGC_815_ECI.dat
 data/FGC_982_ECI.dat
 epmapplicationsnapshot.xml
 Export_Expense.zip
 inbox/CPX_ERP_ASSETS/Assets Subledger_Excel Output.csv
 inbox/ERP_FS_Acc_Map.txt
 inbox/ERP_FS_ENT_Map.txt
 inbox/ERP_FS_Prj_Map.txt
 inbox/EXPENSE_TransDet/Account_Analysis.csv
 inbox/HCM_DATA_FILE/DATA_ENTITY_MAPS.txt
 inbox/HCM_DATA_FILE/EPBCS HCM Extract Report_EPBCS HCM Extract Report.csv
 inbox/HCM_DATA_FILE/HCM_DATA_FILE_AcctMaps.txt
 inbox/Metadata/Parent and child value report.csv
 inbox/Metadata/Project Parent Child_Project Parent Child.csv
 inbox/Metadata/Suppliers In System.csv
 inbox/OEP_FS_ERP_GL/OEP_FS_ERP_GL_Accts_102518.txt
 inbox/OEP_FS_ERP_GL/OEP_FS_ERP_GL_AllMaps_102518.txt
 inbox/VENDOR_ERP_AP/AP Report_AP Report(2).csv
 inbox/VENDOR_ERP_AP/AP Report_AP Report.csv
 inbox/VENDOR_ERP_AP/AP Report_AP Report.xlsx
 inbox/VENDOR_ERP_AP/AP Report_AP Report_0927.csv
 inbox/WF_EMP_DIM/SampleHCMDataFile.txt
 mdarouie 18-10-12.zip
 outbox/AClient-Vendor_257.dat
 outbox/AClient-Vendor_259.dat
 outbox/AClient-Vendor_260.dat
 outbox/AClient-Vendor_790.dat
 outbox/AClient-Vendor_791.dat
 outbox/AClient-Vendor_842.dat
 outbox/AClient-Vendor_845.dat
 outbox/AClient-Vendor_847.dat
 outbox/AClient-Vendor_848.dat
 outbox/AClient-Vendor_849.dat
 outbox/AClient-Vendor_851.dat
 outbox/Client_1023.dat
 outbox/Client_1024.dat
 outbox/Client_1025.dat
 outbox/Client_1026.dat
 outbox/Client_290.dat
 outbox/Client_302.dat
 outbox/Client_315.dat
 outbox/Client_316.dat
 outbox/Client_317.dat
 outbox/Client_322.dat
 outbox/Client_355.dat
 outbox/Client_356.dat
 outbox/Client_427.dat
 outbox/Client_428.dat
 outbox/Client_429.dat
 outbox/Client_431.dat
 outbox/Client_432.dat
 outbox/Client_433.dat
 outbox/Client_434.dat
 outbox/Client_435.dat
 outbox/Client_436.dat
 outbox/Client_437.dat
 outbox/Client_438.dat
 outbox/Client_439.dat
 outbox/Client_441.dat
 outbox/Client_442.dat
 outbox/Client_445.dat
 outbox/Client_447.dat
 outbox/Client_461.dat
 outbox/Client_462.dat
 outbox/Client_465.dat
 outbox/Client_466.dat
 outbox/Client_467.dat
 outbox/Client_470.dat
 outbox/Client_472.dat
 outbox/Client_482.dat
 outbox/Client_485.dat
 outbox/Client_684.dat
 outbox/Client_685.dat
 outbox/Client_688.dat
 outbox/Client_690.dat
 outbox/Client_691.dat
 outbox/Client_694.dat
 outbox/Client_696.dat
 outbox/Client_698.dat
 outbox/Client_701.dat
 outbox/Client_703.dat
 outbox/Client_705.dat
 outbox/Client_707.dat
 outbox/Client_723.dat
 outbox/Client_726.dat
 outbox/Client_727.dat
 outbox/Client_728.dat
 outbox/Client_729.dat
 outbox/Client_730.dat
 outbox/Client_732.dat
 outbox/Client_733.dat
 outbox/Client_742.dat
 outbox/Client_755.dat
 outbox/Client_759.dat
 outbox/Client_760.dat
 outbox/Client_761.dat
 outbox/Client_864.dat
 outbox/Client_865.dat
 outbox/Client_891.dat
 outbox/Client_894.dat
 outbox/Client_895.dat
 outbox/Client_896.dat
 outbox/Client_897.dat
 outbox/Client_898.dat
 outbox/Client_899.dat
 outbox/Client_901.dat
 outbox/Client_905.dat
 outbox/Client_906.dat
 outbox/logs/Cloud ERP_982.log
 outbox/logs/Client_1000.log
 outbox/logs/Client_1001.log
 outbox/logs/Client_1002.log
 outbox/logs/Client_1003.log
 outbox/logs/Client_1004.log
 outbox/logs/Client_1005.log
 outbox/logs/Client_1006.log
 outbox/logs/Client_1007.log
 outbox/logs/Client_1008.log
 outbox/logs/Client_1009.log
 outbox/logs/Client_1010.log
 outbox/logs/Client_1011.log
 outbox/logs/Client_1012.log
 outbox/logs/Client_1013.log
 outbox/logs/Client_1014.log
 outbox/logs/Client_1015.log
 outbox/logs/Client_1016.log
 outbox/logs/Client_1021.log
 outbox/logs/Client_1022.log
 outbox/logs/Client_1023.log
 outbox/logs/Client_1024.log
 outbox/logs/Client_1025.log
 outbox/logs/Client_1026.log
 outbox/logs/Client_1028.log
 outbox/logs/Client_1029.log
 outbox/logs/Client_1030.log
 outbox/logs/Client_1031.log
 outbox/logs/Client_1033.log
 outbox/logs/Client_1034.log
 outbox/logs/Client_1035.log
 outbox/logs/Client_1036.log
 outbox/logs/Client_1037.log
 outbox/logs/Client_1038.log
 outbox/logs/Client_1039.log
 outbox/logs/Client_1040.log
 outbox/logs/Client_1041.log
 outbox/logs/Client_1042.log
 outbox/logs/Client_941.log
 outbox/logs/Client_942.log
 outbox/logs/Client_943.log
 outbox/logs/Client_944.log
 outbox/logs/Client_945.log
 outbox/logs/Client_946.log
 outbox/logs/Client_947.log
 outbox/logs/Client_948.log
 outbox/logs/Client_949.log
 outbox/logs/Client_950.log
 outbox/logs/Client_951.log
 outbox/logs/Client_952.log
 outbox/logs/Client_953.log
 outbox/logs/Client_954.log
 outbox/logs/Client_955.log
 outbox/logs/Client_956.log
 outbox/logs/Client_957.log
 outbox/logs/Client_958.log
 outbox/logs/Client_959.log
 outbox/logs/Client_960.log
 outbox/logs/Client_961.log
 outbox/logs/Client_962.log
 outbox/logs/Client_963.log
 outbox/logs/Client_964.log
 outbox/logs/Client_965.log
 outbox/logs/Client_966.log
 outbox/logs/Client_967.log
 outbox/logs/Client_981.log
 outbox/logs/Client_983.log
 outbox/logs/Client_984.log
 outbox/logs/Client_985.log
 outbox/logs/Client_986.log
 outbox/logs/Client_987.log
 outbox/logs/Client_988.log
 outbox/logs/Client_989.log
 outbox/logs/Client_990.log
 outbox/logs/Client_991.log
 outbox/logs/Client_992.log
 outbox/logs/Client_993.log
 outbox/logs/Client_994.log
 outbox/logs/Client_995.log
 outbox/logs/Client_996.log
 outbox/logs/Client_997.log
 outbox/logs/Client_998.log
 outbox/logs/Client_999.log
 outbox/MDM_Client - Custom_632.dat
 outbox/MDM_Client - Custom_683.dat
 outbox/MDM_Client - Custom_753.dat
 outbox/MDM_Client - Custom_757.dat
 outbox/MDM_Client - Custom_758.dat
 outbox/TableExport_198.zip
 outbox/TableExport_199.zip
 PROD_Backup 18-10-26_FULL.zip
 
 Total 568


Last edited by Scrutinizer; 11-20-2018 at 12:23 PM.. Reason: quote tags -> code tags
# 4  
Old 11-20-2018
Hi, try:

Code:
awk -F/ '/Client.*log/{print $NF}' "${_TEMP}" | sort -t_ -k 2,2n | tail -1

# 5  
Old 11-20-2018
Code:
awk -F'[_./]' 'NF>=2 && $(NF-2)~/^Client/{print $(NF-1)}' myFile | sort -rn | head -1

# 6  
Old 11-20-2018
No sort needed to find the maximum.
Code:
awk '$0 ~ SEARCH {
        for(N=1; N<=NF; N++)
        if(($N ~ /^[0-9]+$/) && (MAX < ($N+0)))
        {       MAX=$N; NAME=$0; break; }
}

END {
        N=split(NAME,A,"/");
        print A[N]
}' SEARCH="Client_" FS='[_/.-]' data

# 7  
Old 11-20-2018
Quote:
Originally Posted by Corona688
No sort needed to find the maximum.
Code:
awk '$0 ~ SEARCH {
        for(N=1; N<=NF; N++)
        if(($N ~ /^[0-9]+$/) && (MAX < ($N+0)))
        {       MAX=$N; NAME=$0; break; }
}

END {
        N=split(NAME,A,"/");
        print A[N]
}' SEARCH="Client_" FS='[_/.-]' data




Thank you very much everyone! This method works great for me!


However, how would I set the results into the variable called _FDMEE_LOG? I can't seem to get it.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Strange results from 'strings | sort'

Using the 'strings' command and piping the result to 'sort' is producing strange results. I get block of lines that begin with asterisks, then a block that begins with some text, then more lines that begin with asterisks. The actual content is correct - lines beginning with asterisks is the... (5 Replies)
Discussion started by: edstevens
5 Replies

2. Shell Programming and Scripting

Find with rm command gives strange results

I want to remove any files that are older than 2 days from a directory. It deletes those files. Then it comes back with a message it is a directory. What am I doing wrong here? + find /mydir -mtime +2 -exec rm -f '{}' ';' rm: /mydir is a directory (2 Replies)
Discussion started by: jtamminen
2 Replies

3. UNIX for Advanced & Expert Users

Rsync in progress, strange results

Disclaimer, I've been a Linux admin for a while but don't frequently setup rsysnc jobs. Here's the command I'm running on CentOS 5.5, rsync 2.6.8: rsync -arvz --progress --compress-level=9 /src/ /dest/ /src has 1.5 TB of data, /dest/ is a new destination and started out empy. Oh ya, both... (4 Replies)
Discussion started by: DustinT
4 Replies

4. UNIX for Dummies Questions & Answers

sort find results

Hi, I have a problem with a shell script. The script should find all .cpp and .h files and list them. With: for file in `find $src -name '*.h' -o -name '*.cpp' it gives out this: H:\FileList\A\E\F\G\newCppFile.cpp H:\FileList\header01.h H:\FileList\B\nextCppFile.cpp ... (4 Replies)
Discussion started by: shellBeginner75
4 Replies

5. Shell Programming and Scripting

Help with sort folder results

Here is the code, but the list is not sorted properly (alphabetically)? <?php function folderlist(){ $startdir = './'; $ignoredDirectory = '.'; $ignoredDirectory = '..'; if (is_dir($startdir)){ if ($dh = opendir($startdir)){ while (($folder = readdir($dh)) !== false){ if... (0 Replies)
Discussion started by: mrlayance
0 Replies

6. Shell Programming and Scripting

Strange results from FDISK?????

Hi all, I am writing script that returns the size of each disk or partition when called. I am using FDISK -l and parsing the results to get the result I want. When I execute fdisk -l it shows correct results, BUT when I execute the same thing with results to be put in a variable, I get strange... (5 Replies)
Discussion started by: alirezan
5 Replies

7. UNIX for Advanced & Expert Users

Sort command - strange behaviour

Hi guys, I have the following example data: A;00:00:19 B;00:01:02 C;00:00:13 D;00:00:16 E;00:02:27 F;00:00:12 G;00:00:21 H;00:00:19 I;00:00:13 J;00:13:22 I run the following sort against it, yet the output is as follows: sort -t";" +1 -nr example_data.dat A;00:00:19 (16 Replies)
Discussion started by: miwinter
16 Replies

8. UNIX for Dummies Questions & Answers

Strange Results

I am using th following to get the percentage and have never used bc before: percent=$(echo "scale=4;(34117/384000)*100" | bc) 8.884600 percent=$(echo "scale=2;(34117/384000)*100" | bc) 8.00 Why do I get the results of 8.00 instead of 8.88 when using a scale of 2. I only want 2 decimal... (2 Replies)
Discussion started by: mariaa33
2 Replies

9. AIX

Strange ls results..

Multipart question.. Can anybody explain why this happens : -rw-rw-r-- 1 fnsw fnusr 1531061 Feb 13 21:45 filename1.log -rw-rw-r-- 1 fnsw fnusr 1760706 Feb 10 22:10 filename2.log -rw-rw-r-- 1 fnsw fnusr 1525805 Aug 16 2005 filename3.log -rw-rw-r-- 1... (3 Replies)
Discussion started by: dbridle
3 Replies

10. UNIX for Dummies Questions & Answers

How to sort find results

Hi-- Ok. I have now found that: find -x -ls will do what I need as far as finding all files on a particular volume. Now I need to sort the results by the file's modification date/time. Is there a way to do that? Also, I notice that for many files, whereas the man for find says ls is... (8 Replies)
Discussion started by: groundlevel
8 Replies
Login or Register to Ask a Question