Sponsored Content
Full Discussion: Parse Directory path - awk
Top Forums Shell Programming and Scripting Parse Directory path - awk Post 303039562 by greycells on Wednesday 9th of October 2019 11:49:22 AM
Old 10-09-2019
Original File

Code:
slsins,/data/application-nr/slsins/MYRIAD/MYRIAD_RISK_03,10,IEE1
slsins,/data/application-nr/slsins/MYRIAD/MYRIAD_RISK_02,10,IEE1
slsins,/data/dbdumps-nr/slsins/ggg001/DMP_QLN18300/QLN18300,10,IEE1
slsins,/data/dbdumps-nr/slsins/ggg001/DMP_QLN63500/QLN63500,10,IEE1
slsins,/data/dbdumps-nr/slsins/ggg001/DMP_PLNLOD2031/PLNLOD2031,10,IEE1
slsins,/data/dbdumps-nr/slsins/ggg001/DMP_QLN16800/QLN16800,10,IEE1
slsins,/data/dbdumps-nr/slsins/ggg001,10,
slsins,/data/dbdumps-nr/slsins/ggg001/DMP_QLN63200/QLN63200,10,
slsins,/data/dbdumps-nr/slsins/ggg001/DMP_QLN63100/QLN63100,10,IEE1
slsins,/data/dbdumps-nr/slsins/ggg001/DMP_QLN17800/QLN17800,10,IEE1
slsins,/data/dbdumps-rp/slsins/ggg001,10,IEE1
slsins,/data/dbdumps-rp/slsins/ggg002,10,IEE1
slsins,/data/dbdumps-nr/slsins/ggg001/DMP_QLN17700/QLN17700,10,IEE1
slsins,/data/application-nr/slsins/MYRIAD/MYRAID_RISK_01,,IEE1
slsins,/data/dbdumps-nr/slsins/ggg001/DMP_PLNLOD2071/PLNLOD2071,10,IEE1
slsins,/data/dbdumps-nr/gshins01/syb001,10,IEE1
slsins,/data/dbdumps-nr/gshins01/ggg001,10,IEE1
slsins,/data/dbdumps-nr/slsins/ggg001/DMP_QLN63600/QLN63600,10,IEE1
slsins,/data/dbdumps-nr/slsins/ggg001/DMP_DLNLOD2125,,IEE1
slsins,/data/applications-nr/gshins01/pCloud,10,IEE1
slsins,/data/application-rp/slsins/Odyssey/Odyssey_26656_03,10,IEE1
slsins,/data/application-nr/slsins/CDDS,10,IEE1
slsins,/data/dbdumps-nr/slsins/ggg001/DMP_QLN17100/QLN17100,10,IEE1
slsins,/data/dbdumps-nr/slsins/ggg001/DMP_DLN45100,10,IEE1
slsins,/data/dbdumps-rp/gshins01/sql001,10,IEE1
slsins,/data/application-rp/slsins/Odyssey/Odyssey_26656_03/IB_Odyssey_03,10,IEE1
slsins,/data/dbdumps-nr/slsins/ggg001/DMP_QLN17900/QLN17900,10,IEE1
slsins,/data/dbdumps-nr/slsins/ggg001/DMP_QLN64000/QLN64000,10,IEE1


$ sort -t, -k2,2 -k4r -k3 ei
Code:
slsins,/data/application-nr/slsins/CDDS,10,IEE1
slsins,/data/application-nr/slsins/MYRIAD/MYRAID_RISK_01,,IEE1
slsins,/data/application-nr/slsins/MYRIAD/MYRIAD_RISK_02,10,IEE1
slsins,/data/application-nr/slsins/MYRIAD/MYRIAD_RISK_03,10,IEE1
slsins,/data/application-rp/slsins/Odyssey/Odyssey_26656_03,10,IEE1
slsins,/data/application-rp/slsins/Odyssey/Odyssey_26656_03/IB_Odyssey_03,10,IEE1
slsins,/data/applications-nr/gshins01/pCloud,10,IEE1
slsins,/data/dbdumps-nr/gshins01/ggg001,10,IEE1
slsins,/data/dbdumps-nr/gshins01/syb001,10,IEE1
slsins,/data/dbdumps-nr/slsins/ggg001,10,
slsins,/data/dbdumps-nr/slsins/ggg001/DMP_DLN45100,10,IEE1
slsins,/data/dbdumps-nr/slsins/ggg001/DMP_DLNLOD2125,,IEE1
slsins,/data/dbdumps-nr/slsins/ggg001/DMP_PLNLOD2031/PLNLOD2031,10,IEE1
slsins,/data/dbdumps-nr/slsins/ggg001/DMP_PLNLOD2071/PLNLOD2071,10,IEE1
slsins,/data/dbdumps-nr/slsins/ggg001/DMP_QLN16800/QLN16800,10,IEE1
slsins,/data/dbdumps-nr/slsins/ggg001/DMP_QLN17100/QLN17100,10,IEE1
slsins,/data/dbdumps-nr/slsins/ggg001/DMP_QLN17700/QLN17700,10,IEE1
slsins,/data/dbdumps-nr/slsins/ggg001/DMP_QLN17800/QLN17800,10,IEE1
slsins,/data/dbdumps-nr/slsins/ggg001/DMP_QLN17900/QLN17900,10,IEE1
slsins,/data/dbdumps-nr/slsins/ggg001/DMP_QLN18300/QLN18300,10,IEE1
slsins,/data/dbdumps-nr/slsins/ggg001/DMP_QLN63100/QLN63100,10,IEE1
slsins,/data/dbdumps-nr/slsins/ggg001/DMP_QLN63200/QLN63200,10,
slsins,/data/dbdumps-nr/slsins/ggg001/DMP_QLN63500/QLN63500,10,IEE1
slsins,/data/dbdumps-nr/slsins/ggg001/DMP_QLN63600/QLN63600,10,IEE1
slsins,/data/dbdumps-nr/slsins/ggg001/DMP_QLN64000/QLN64000,10,IEE1
slsins,/data/dbdumps-rp/gshins01/sql001,10,IEE1
slsins,/data/dbdumps-rp/slsins/ggg001,10,IEE1
slsins,/data/dbdumps-rp/slsins/ggg002,10,IEE1

$ more file1
Code:
slsins,/data/application-nr/slsins/CDDS,10,IEE1
slsins,/data/application-nr/slsins/MYRIAD/MYRIAD_RISK_02,10,IEE1
slsins,/data/application-nr/slsins/MYRIAD/MYRIAD_RISK_03,10,IEE1
slsins,/data/application-rp/slsins/Odyssey/Odyssey_26656_03,10,IEE1
slsins,/data/application-rp/slsins/Odyssey/Odyssey_26656_03/IB_Odyssey_03,10,IEE1
slsins,/data/applications-nr/gshins01/pCloud,10,IEE1
slsins,/data/dbdumps-nr/gshins01/ggg001,10,IEE1
slsins,/data/dbdumps-nr/gshins01/syb001,10,IEE1
slsins,/data/dbdumps-nr/slsins/ggg001/DMP_DLN45100,10,IEE1
slsins,/data/dbdumps-nr/slsins/ggg001/DMP_PLNLOD2031/PLNLOD2031,10,IEE1
slsins,/data/dbdumps-nr/slsins/ggg001/DMP_PLNLOD2071/PLNLOD2071,10,IEE1
slsins,/data/dbdumps-nr/slsins/ggg001/DMP_QLN16800/QLN16800,10,IEE1
slsins,/data/dbdumps-nr/slsins/ggg001/DMP_QLN17100/QLN17100,10,IEE1
slsins,/data/dbdumps-nr/slsins/ggg001/DMP_QLN17700/QLN17700,10,IEE1
slsins,/data/dbdumps-nr/slsins/ggg001/DMP_QLN17800/QLN17800,10,IEE1
slsins,/data/dbdumps-nr/slsins/ggg001/DMP_QLN17900/QLN17900,10,IEE1
slsins,/data/dbdumps-nr/slsins/ggg001/DMP_QLN18300/QLN18300,10,IEE1
slsins,/data/dbdumps-nr/slsins/ggg001/DMP_QLN63100/QLN63100,10,IEE1
slsins,/data/dbdumps-nr/slsins/ggg001/DMP_QLN63500/QLN63500,10,IEE1
slsins,/data/dbdumps-nr/slsins/ggg001/DMP_QLN63600/QLN63600,10,IEE1
slsins,/data/dbdumps-nr/slsins/ggg001/DMP_QLN64000/QLN64000,10,IEE1
slsins,/data/dbdumps-rp/gshins01/sql001,10,IEE1
slsins,/data/dbdumps-rp/slsins/ggg001,10,IEE1
slsins,/data/dbdumps-rp/slsins/ggg002,10,IEE1


$ more file2
Code:
slsins,/data/application-nr/slsins/MYRIAD/MYRAID_RISK_01,,IEE1
slsins,/data/dbdumps-nr/slsins/ggg001,10,
slsins,/data/dbdumps-nr/slsins/ggg001/DMP_DLNLOD2125,,IEE1
slsins,/data/dbdumps-nr/slsins/ggg001/DMP_QLN63200/QLN63200,10,

 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Parse value from multiple row to create the path

Hi all, Hope all the expert can help me in this situation. Let say I have one file with multiple record like below: NAME=FRAGMENT LANGUAGE=1 DIALECT=0 GENDER=NONE FILE=TEST1 DIRECTORY=D:/DETAILS/1/0/test1.txt END NAME=FRAGMENT LANGUAGE=1 DIALECT=0 GENDER=NONE (13 Replies)
Discussion started by: shirleyeow
13 Replies

2. UNIX for Dummies Questions & Answers

awk to parse a directory name?

Hi, I have a directory file name: /auto/space/user/jen/CED/CED_01MZ/visit1/DCE_2eco/016/echo1 I would like to just get the following outputs into variables such that: variable1 = /auto/space/user/jen/CED/CED_01MZ/visit1/ and variable2 = DCE_2eco/016/echo1 I've tried it with... (2 Replies)
Discussion started by: nixjennings
2 Replies

3. Shell Programming and Scripting

Retrieve directory path from full file path through sh

Hi, I have a file abcd.txt which has contents in the form of full path file names i.e. $home> vi abcd.txt /a/b/c/r1.txt /q/w/e/r2.txt /z/x/c/r3.txt Now I want to retrieve only the directory path name for each row i.e /a/b/c/ /q/w/e/ How to get the same through shell script?... (7 Replies)
Discussion started by: royzlife
7 Replies

4. Shell Programming and Scripting

sed/awk for extracting directory from file path

Hi, I have following path: set file_path = D:/forums/prac/somedir/new1/file1.txt or set file_path = E:/new/forums1/prac/somedir/new2/file2.txt I need to grep "somedir" from file path. In this case preceding directory "prac" remains same for both the paths, but directories preceding... (7 Replies)
Discussion started by: sarbjit
7 Replies

5. Shell Programming and Scripting

Parse file name out of UNC path

Hello, I searched the forums and didn't see a situation like this: I cannot figure out how to parse out just the file name from the full path. The path looks like this: \\foo\bar\filename.ext I don't think something like 'cut' will work so I tried to whip up a regex but couldn't get it... (12 Replies)
Discussion started by: bytesnoop
12 Replies

6. Shell Programming and Scripting

Parse output path to set variable

I am looking to parse a text file output and set variables based on what is cropped from the parsing. Below is my script I am looking to add this feature too. All it does is scan a certain area of users directories for anyone using up more than X amount of disk space. It then writes to the... (4 Replies)
Discussion started by: es760
4 Replies

7. Shell Programming and Scripting

Variable of Path directory is not parsing in awk

Hi All, i had to split one files into 10 equally. For that i have coded below awk. OUTPUT_FILE=/home/sit/path/Files/file_EXPORT.lst DIR_NM=`dirname ${OUTPUT_FILE}` awk -v CURR_DATE="$(date +'%d-%m-%Y-%H-%M')" -v pth=$DIR_NM '{print >> pth/"tgt_file_name"CURR_DATE"_"NR%10 }' ${OUTPUT_FILE} ... (7 Replies)
Discussion started by: looney
7 Replies

8. UNIX for Beginners Questions & Answers

Convert Relative path to Absolute path, without changing directory to the file location.

Hello, I am creating a file with all the source folders included in my git branch, when i grep for the used source, i found source included as relative path instead of absolute path, how can convert relative path to absolute path without changing directory to that folder and using readlink -f ? ... (4 Replies)
Discussion started by: Sekhar419
4 Replies

9. UNIX for Beginners Questions & Answers

What is the difference ../directory path and ./directory path in ksh?

What is the difference ../directory path and ./directory path in ksh? (1 Reply)
Discussion started by: TestKing
1 Replies
All times are GMT -4. The time now is 06:24 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy