File format


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting File format
# 1  
Old 11-10-2009
File format

Dear Friends,

I hope everything's fine for you. I've seen a lots of post today, I hope you will be able to have some times to help me Smilie

I am on SOLARIS 9
I can only use shell (ksh)
I can't use PERL

I am writing a script with functions that list some directories on an FTP server. The idea is to create a list of file on all master directory.

Example :

\home\directory\master1
\home\directory\master1\directory1
\home\directory\master2
\home\directory\master\directory1

and so on ..

I am using NcFTP (NcFTPls) to make this list.

But I have a lots of problems :

First : This list is not on the format that I need :

Code:
here is the list as sample :

-rw-rw----   1 dmz  master 141352584 Oct 19 11:19 SATURNE_1dAV_20090224_20090225_artmod_R20090225.nc
-rw-rw----   1 dmz  master  370328 Oct 18 12:53 SATURNE_DIADCT_ANA_R20090225
-rw-rw----   1 dmz  master    6342 Oct 19 08:56 SATURNE_NOMO_OUT_001_FCST_R20090225
-rw-rw----   1 dmz  master      94 Oct 19 08:56 SATURNE_NOMO_OUT_001_INITSYST_R20090225

As I only need SIZE DATE TIME FILE NAME, here is what I am looking for 

370328 18/10/2009 12:53 SATURNE_DIADCT_ANA_R20090225
141352584 19/10/2009 11:19 SATURNE_1dAV_20090224_20090225_artmod_R20090225.nc
6342 19/10/2009 08:56 SATURNE_NOMO_OUT_001_FCST_R20090225
94 19/10/2009 08:56 SATURNE_NOMO_OUT_001_INITSYST_R20090225

I did try to use SED and AWK but I am not good enough to make tis to work as I need.

Is there any command line that I could add to my function ?

I hope you will be able to help me ...

I am making this edit as I forgot to mention that I need that list to be sort by date time. My need to is get the first and last date time. I have to make report on when the first and the last file were available.

I am writing a new edit as I found a way to format the file like I need :

to get the file like this :

Size date time file name

375028175 18 Oct 13:00 SATURNE_NOMO_OUT_001_INITSYST_R20090225

I used awk on this way :

Code:
awk -F" " '{print $5" "$7" "$6" "$8" "$9}'

But I am still need your help to sort the log file by date time. Thanks in advanced for your help

Last edited by Aswex; 11-10-2009 at 10:29 AM..
# 2  
Old 11-10-2009
The following command list files sorted by date time :
Code:
ncftpls -x "-lrt"

Jean-Pierre.
# 3  
Old 11-10-2009
Hello aigles,

I am using Ncftpls on this way

Code:
ncftpls -x "-lR"

the "t" option did not work for me. I cannot change the Ncftp version. So far the only thing that cannot be done is to get the date on this format dd/mm/yyy

Do you know if it's possible to ask the ftp server to give me the complete date time on the file like this dd/mm/yyyy hh:mm:ss ?

thanks for your help
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Script to generate Excel file or to SQL output data to Excel format/tabular format

Hi , i am generating some data by firing sql query with connecting to the database by my solaris box. The below one should be the header line of my excel ,here its coming in separate row. TO_CHAR(C. CURR_EMP_NO ---------- --------------- LST_NM... (6 Replies)
Discussion started by: dani1234
6 Replies

2. Shell Programming and Scripting

Need help to format one txt file to required format

Hello Everyone, I have one source file which is genarated by SAP in different format(Which I've never seen). I need to convert that file to required format and I need to read this target file from Datastage to use this in my Jobs. So I do not have any other options except to use Unix script to... (4 Replies)
Discussion started by: Prathyu
4 Replies

3. Shell Programming and Scripting

Converting windows format file to unix format using script

Hi, I am having couple of files which i used to copy from windows to Linux, so now in case of text files (CTRL^M) appears at end of line. I know i can convert this windows format file to unix format file by running dos2unix. My requirement here is that i want to do it automatically using a... (5 Replies)
Discussion started by: sarbjit
5 Replies

4. Shell Programming and Scripting

Convert UNIX file format to PC format

Hi All, Is there any way to convert a file which is in UNIX format to a PC format.... Flip command can be used , apart form this command can we have any other way.... like usinf "awk" etc ..... main purpose of not using flip is that my Kshell doesnot support this comamnd.... (2 Replies)
Discussion started by: Samtel
2 Replies

5. UNIX for Dummies Questions & Answers

Convert UNIX file format to PC format

Hi All, Is there any way to convert a file which is in UNIX format to a PC format.... Flip command can be used , apart form this command can we have any other way.... like usinf "awk" etc ..... main purpose of not using flip is that my Kshell doesnot support this comamnd.... (1 Reply)
Discussion started by: Samtel
1 Replies

6. Shell Programming and Scripting

Convert Epoch time format to normal date time format in the same file

I have a file named "suspected" with series of line like these : {'protocol': 17, 'service': 'BitTorrent KRPC', 'server': '219.78.120.166', 'client_port': 52044, 'client': '10.64.68.44', 'server_port': 8291, 'time': 1226506312L, 'serverhostname': ''} {'protocol': 17, 'service': 'BitTorrent... (3 Replies)
Discussion started by: rk4k
3 Replies

7. Shell Programming and Scripting

AWK CSV to TXT format, TXT file not in a correct column format

HI guys, I have created a script to read 1 column in a csv file and then place it in text file. However, when i checked out the text file, it is not in a column format... Example: CSV file contains name,age aa,11 bb,22 cc,33 After using awk to get first column TXT file... (1 Reply)
Discussion started by: mdap
1 Replies

8. UNIX for Dummies Questions & Answers

To convert multi format file to a readable ascii format

Hi I have a file which has ascii , binary, binary decimal coded,decimal & hexadecimal data with lot of special characters (like öƒ.ƒ.„İİ¡Š·œƒ.„İİ¡Š· ) in it. I want to standardize the file into ASCII format & later use that as source . Can any one suggest a way a logic to convert such... (5 Replies)
Discussion started by: gaur.deepti
5 Replies

9. UNIX for Dummies Questions & Answers

Convert UTF8 Format file to ANSI format

:confused: Hi i am trying to convert a file which is in UTF8 format to ANSI format i tried to use the function ICONV but it is throwing error Function i used it as $ iconv -f UTF8 -t ANSI filename Error iam getting is NOT Supported UTF8 to ANSI please some help me out on... (9 Replies)
Discussion started by: rajreddy
9 Replies

10. UNIX for Advanced & Expert Users

Convert UTF8 Format file to ANSI format

:) Hi i am trying to convert a file which is in UTF8 format to ANSI format i tried to use the function ICONV but it is throwing error Function i used it as $ iconv -f UTF8 -t ANSI filename Error iam getting is NOT Supported UTF8 to ANSI please some help me out on this.........Let me... (1 Reply)
Discussion started by: rajreddy
1 Replies
Login or Register to Ask a Question