× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Why not use the Retrieve Directory Information (RTVDIRINF) command and then SQL the heck out of the resulting file(s)?

I would guess that if you want consistent dates you would have to use the stat() (or related)apis.

Bryan

On Jun 3, 2009 12:19pm, rob@xxxxxxxxx wrote:
I am breaking this down a little and on the dates I can see that sometimes

find /QIBM/ProdData/OS400/iSeriesNavigator -size +20M -type f -exec ls -l

{} \;

returns Oct 29 2007. Sometimes it returns Mar 10 15:32. It doesn't

matter what directory. Sometimes it varies within the same directory.

Near as I can figure if the last changed date was this year it shows you

the time. Otherwise it shows you the year.



I made two file names

/rob/what a file name.txt

/rob/what,a,file,name.txt



> find /rob/what* -type f -exec ls -l {} \;

-rw-rw-rw- 1 rob 0 6 Jun 03 12:07 /rob/what a

file name.txt

-rw-rw-rw- 1 rob 0 6 Jun 03 12:07

/rob/what,a,file,name.txt

$



> find /rob/what* -type f -exec ls -l {} \; | awk '{ print $9 "," $5 ","

$6"/"$7"/"$8 }'

/rob/what,6,Jun/03/12:07

/rob/what,a,file,name.txt,6,Jun/03/12:07

$



So awk thinks the space indicates a new field. That makes sense. Commas

it has no problem with (just the darn csv file I am trying to read in

Excel.



1 - How do I get dates consistent?

2 - How do I get awk to ignore some spaces?

3 - How do I get excel to pull in this file and leave what,a,file,name.txt

in one column?

Summary how do I find the big files and get them into Excel?







Rob

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.