Re: RE: qsh find command -size +20M

[bdietz400@xxxxxxxxx]

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