Getting all the subdirectories inside directories in excel file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Getting all the subdirectories inside directories in excel file
# 1  
Old 07-02-2015
Getting all the subdirectories inside directories in excel file

Can anyone help me with a short command or script for the below scenario

there is a path,
Code:
/a/b/c/home??

Inside the above path there are number of subdirectories such as
Code:
one
two
three
four

i need to take all the subdirectories inside
Code:
home??

with full path. i need only one level of subdirectories.
the output should be.
Code:
/a/b/c/homeaa/one
/a/b/c/homeaa/two
/a/b/c/homeaa/three
/a/b/c/homeaa/four
/a/b/c/homebb/one
/a/b/c/homebb/two
/a/b/c/homebb/three
/a/b/c/homebb/four

Is there a way so that i can get the above output in an excel file?
# 2  
Old 07-02-2015
If you don't mind having a trailing backslash printed with your directory names, the trivial way to do it is:
Code:
printf '%s\n' /a/b/c/home??/*/

If you do mind the trailing backslash, you can use a for loop on the same pathname pattern and print the loop control variable with the backslash stripped off.

Of course, how you put the results into an excel spreadsheet is up to you.

Last edited by Don Cragun; 07-02-2015 at 03:55 AM.. Reason: Add note about excel file creation.
This User Gave Thanks to Don Cragun For This Post:
# 3  
Old 07-02-2015
Hello little,

Nice to see you again in forum. Could you please try following and let me know if this helps, I have made a similar directory structure in my /tmp and tried following command, you can replace the path with your actual and path and if happy with results then re-direct it's output to an excel file too.
Code:
find /tmp/a/b/c/home?? -mindepth 1 -maxdepth 1 -type d | sort -t/ -k5,5

In my case following is the output.
Code:
/tmp/a/b/c/homeaa/one
/tmp/a/b/c/homeaa/three
/tmp/a/b/c/homeaa/two
/tmp/a/b/c/homebb/one
/tmp/a/b/c/homebb/three
/tmp/a/b/c/homebb/two

Hope this helps.

Thanks,
R. Singh
This User Gave Thanks to RavinderSingh13 For This Post:
# 4  
Old 07-02-2015
Quote:
Originally Posted by RavinderSingh13
Hello little,

Nice to see you again in forum. Could you please try following and let me know if this helps, I have made a similar directory structure in my /tmp and tried following command, you can replace the path with your actual and path and if happy with results then re-direct it's output to an excel file too.
Code:
find /tmp/a/b/c/home?? -mindepth 1 -maxdepth 1 -type d | sort -t/ -k5,5

In my case following is the output.
Code:
/tmp/a/b/c/homeaa/one
/tmp/a/b/c/homeaa/three
/tmp/a/b/c/homeaa/two
/tmp/a/b/c/homebb/one
/tmp/a/b/c/homebb/three
/tmp/a/b/c/homebb/two

Hope this helps.

Thanks,
R. Singh
Hi Ravinder, thanks for the code, I tried your code, I know its a correct one but ksh shell is not able to recognize maxdepth and mindepth options of find command.
# 5  
Old 07-02-2015
Unless your version of the Korn shell has find as a built-in, the issue isn't ksh, but the version of find you're using. And, since you didn't bother telling us what operating system you're using, RavinderSingh13 supplied a sample script that works on the system he's using without worrying about options that might not be available on your unnamed system.

The code I suggested should work with ksh on any system (unless you have a huge number of matching directories and/or relatively long pathnames). And, if that is a problem in your environment, it would disappear if you used the for loop I suggested.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Remove all the subdirectories except latest 5 inside any given directory

I Want to remove all the sub-directories except latest five in any given TGTDIR. Is there a way to do so without making a cd to TGTDIR? I have tried the following but not worked. Thank you. rm -rf `ls -t $TGTDIR | awk 'NR>5'` (20 Replies)
Discussion started by: Devendra Hupri
20 Replies

2. Shell Programming and Scripting

Looping inside directories based on a file which contains file directory list

Hi All, Please help. I have got a file which contains a listing of a file and some directories after it, one by one. I am calling this file xyz.txt here file1 dir1 dir2 dir3 dir4 file2 dir5 dir6 dir7 dir8 file3 dir9 dir10 dir11 dir12 (6 Replies)
Discussion started by: Piyush Jakra
6 Replies

3. UNIX for Dummies Questions & Answers

Find directories without subdirectories

Hello, I have to find all directories, which contain files, but dont have subdirectories. For example if i have tree like: ├── kat11 │ ├── kat21 │ │ └── Dokument\ bez\ nazwy │ └── kat22 │ ├── kat31 │ │ └── Dokument\ bez\ nazwy │ └── kat32 │ └──... (13 Replies)
Discussion started by: eValker
13 Replies

4. UNIX and Linux Applications

Perl Script to read an excel file into an array and search in the UNIX directories

Hi, I want the Perl script with versions 5.8.2 and 5.8.5 starting with #!/usr/bin/perl The Perl program should read the excel file or text file line by line and taking into an array and search in the UNIX directories for reference file of .jsp or .js or .xsl with path .The Object names... (2 Replies)
Discussion started by: pasam
2 Replies

5. Shell Programming and Scripting

backup of directories and subdirectories

Hello I'm new to the area Bash scripting and that is why I have a search script that is run on my unix server and always when I start the server or every 24 hours The script will create backups of directories and subdirectories I never found what I'm here make a new thread ... (1 Reply)
Discussion started by: HansWurst
1 Replies

6. Shell Programming and Scripting

How to find files only inside the subdirectories only?

Hi I have a directory with two subdirectories and also have a code like below to search files modified in last 2 minutes. # ls hello080909.txt inbox outbox # find . -type f -mmin +2 ./inbox/hello2080909.txt ./outbox/hi0080909.txt ./hello080909.txt The above code just searches and... (3 Replies)
Discussion started by: Tuxidow
3 Replies

7. AIX

recursive archive directories and subdirectories

Hi everyone, Maybe this is simple question for many of you, but I get confused.:confused: How to archive a parent directory which contains some subdirectories and some files? I have searched this forum, there are some commands like tar,etc, I tried but can not be implemented in my system.... (6 Replies)
Discussion started by: wilsonSurya
6 Replies

8. Shell Programming and Scripting

Listing directories and subdirectories

How can list the directories and the subdirectories in a folder. It is possible with a single UNIX command. For example i have a folder named "archive" and another folder named "0808" and then multiple folders are there ... Can i list all the directories and subdirectories in the folder... (6 Replies)
Discussion started by: karansachdeva
6 Replies

9. Shell Programming and Scripting

Display only subdirectories from given directories

Hi Genius, I would like to display all the subdirectories only with timestamp. For exmple: Given Directory : orabkup /orabkup total 11365112 drwxr-xr-x 9 oracle oradba 256 Jan 03 16:01 db1 /orabkup/db1: total 0 drwxr-xr-x 2 oracle oradba 256 Jan 03 16:01... (8 Replies)
Discussion started by: HAA
8 Replies

10. UNIX for Dummies Questions & Answers

Permissions for Directories and Subdirectories

Is it possible to have a directory owned (by root) with permissions drwx------ and then have a sub directory of rwxrwxrwx. I know that this may be soo simple but I had no luck googling it. Thanks for your help (1 Reply)
Discussion started by: clancymf
1 Replies
Login or Register to Ask a Question