Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Need to pick a .dat file dynamically

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Need to pick a .dat file dynamically
# 8  
Old 05-25-2009
Quote:
Originally Posted by panyam
How ?

how you will get the last created or modified .dat file in the directory by above command ??? if so ???
The OP stated that a valid file name would be like "abcd_20090524_193545.dat".
This name has in itself the timestamp, and it happens to be in a format that when the filenames are ASCII-ordered by the shell (when it expands *) they are in the same order as the timestamps.

Depending on how the files arrive, it may even be the case that relying to the local time of creation is wrong.
# 9  
Old 05-25-2009
Ohh...good ...i was not sure of OP 's file format ."abcd....." ..

goood work "colemar".
# 10  
Old 05-26-2009
Hi Everybody,

Thanks aaaaaaaaaaaa loooooooooooooootttttttttttttttttttttttt
for ur input.I will try and let u know.

Thanks again for ur time

Thanks

-----Post Update-----

Hi,

Yes abcd_20090524_193545.dat is just and example.20090524 is the DATE Format and 193545 is the TIMESTAMP.This Timestamp and date are the time and date of that day,so 'abcd' is constant which dosent change only the date and timestamp changes.Only one .dat file will be exsisting in the directory.How can i refer a standard name to that .dat file and again refering that standard name in the control file.

Can u please elobarate.

Thanks
# 11  
Old 05-26-2009
both
Code:
echo *.dat | awk '{print $NF}'

and
Code:
ls -lrt *.dat | awk '{ print $9}'`

will not work if file names have spaces.
Code:
awk '{print FILENAME}' *.dat > controlfile

Code:
for file in *dat
do
 echo "$file"
done > control_file
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to use 'ls' command to list files like *.dat, not *.*.dat?

How to use 'ls' command to list files like *.dat, not *.*.dat (5 Replies)
Discussion started by: pmcginni777
5 Replies

2. UNIX for Beginners Questions & Answers

Convert EBCDIC(.DAT) FILE into ASCII FILE

Hi Team, I am having 100 EBCDIC files (i.e. DAT extension) and need to convert them into ASCII File by unix shell script. I tried with DD Command but its not providing output as expected. Sample Text: ------------------ âäàáãåçñ@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ Expected Output:... (2 Replies)
Discussion started by: JSM
2 Replies

3. Shell Programming and Scripting

Execution of loop :Splitting a single file into multiple .dat file

hdr=$(cut -c1 $path$file|head -1)#extract header”H” trl=$(cut -c|path$file|tail -1)#extract trailer “T” SplitFile=$(cut -c 50-250 $path 1$newfile |sed'$/ *$//' head -1')# to trim white space and extract table name If; then # start loop if it is a header While read I #read file Do... (4 Replies)
Discussion started by: SwagatikaP1
4 Replies

4. Shell Programming and Scripting

FASTEN count line of dat file and compare with the CTRL file

Hi All, I thinking on how to accelerate the speed on calculate the dat file against the number of records CTRL file. There are about 300 to 400 folder directories that contains both DAT and CTL files. DAT contain all the flat files records CTL is the reference check file for the... (3 Replies)
Discussion started by: ckwan
3 Replies

5. UNIX for Dummies Questions & Answers

ID incorrect field values in dat file and output to new file

Hi All I have a .dat file, the values are seperated by ". I wish to identify all field values in field 14 that are not '01-APR-2013' band then copy those records to a new file. Can anyone suggest the UNIX command required. Thanks in advance Andy (2 Replies)
Discussion started by: aurum1313
2 Replies

6. UNIX for Advanced & Expert Users

Search in .dat file

How to perform search for a particular text in .dat file in UNIX (2 Replies)
Discussion started by: Deeptanshu
2 Replies

7. Red Hat

How to view .dat file?

What is the command that can be used to open or view the .dat file in linux? Unable to read the contents of .dat file. (7 Replies)
Discussion started by: Rupaa
7 Replies

8. Shell Programming and Scripting

Pick one file from each subdirectory

Hi, I have a problem I am trying to solve with bash. I need to search in a file system (data base) with hundreds of directories and thousands of subdirectories and millions of files. The files have a specific format with a header that gives the properties. Directories are organized so... (1 Reply)
Discussion started by: majest
1 Replies

9. Shell Programming and Scripting

Performance issue in UNIX while generating .dat file from large text file

Hello Gurus, We are facing some performance issue in UNIX. If someone had faced such kind of issue in past please provide your suggestions on this . Problem Definition: /Few of load processes of our Finance Application are facing issue in UNIX when they uses a shell script having below... (19 Replies)
Discussion started by: KRAMA
19 Replies

10. Shell Programming and Scripting

How to attach an excel file/ dat file thru unix mails

Hi. I want to attach a .xls or .dat file while sending mail thru unix. I have come across diff attachments sending options, but allthose embeds the content in the mail. I want the attachement to be send as such. Please help me out. regards Diwakar (1 Reply)
Discussion started by: diwakar82
1 Replies
Login or Register to Ask a Question