File Date

 
Thread Tools Search this Thread
Top Forums UNIX for Beginners Questions & Answers File Date
# 1  
Old 04-24-2017
Facebook File Date

Hi Team ,

My query is I have generate the two flat file swift_frontoffice_party20170413.csv.swift_trans_fofc_party20170413.csv
with business date on daily bases and the Zip the Two flat file and written script to sent mail
The date value in the flat file will be changed according to the Business date.

How can the pass business date to the script and the Zip the two files .

The script I have written
Code:
set -x
echo "Sending mail "
FILE_DATE=$(date +"%Y%m%d")------this is system date ...but I need the business date as a parameter file
cd /app/informatica/data/GC_AML_MTSDM_DEV01/TgtFiles
zip EMAIL_TRANS_TRANP.zip swift_frontoffice_party$FILE_DATE.csv swift_trans_fofc_party$FILE_DATE.csv
echo "zip completed"
mailx -s " testing " XXXXXX@gmail.com << EOM
`uuencode EMAIL_TRANS_TRANP.zip EMAIL_TRANS_TRANP.zip`
echo "mail completed"

Could u pls help in writing the script .


Moderator's Comments:
Mod Comment Please use CODE tags as required by forum rules!
Please post in an adequate forum!

Last edited by RudiC; 04-24-2017 at 01:11 PM.. Reason: Added CODE tags. Moved thread.
# 2  
Old 04-24-2017
If you told people in here what the "business date" is, how it is created, and where it can be found (in a parameter file (name? location?) maybe?), you might find some decent help.

EDIT: Or, reading your post again, should it be that data part of the respective file names?
# 3  
Old 04-24-2017
We are Using ETL tool to generate the business date like 20170708 along with flatfile swift_frontoffice_party20170413.csv
Code:
 -rw-rw----+ 1 mtsdsdev mtsdsd  18918303 Apr 24 06:27 swift_frontoffice_party20170413.csv
-rw-rw----+ 1 mtsdsdev mtsdsd      1940 Apr 24 06:27 swift_trans_fofc_party20170413.csv

I have written script without date for the flatfile it is working fine with script I have written
Code:
 -rw-rw----+ 1 mtsdsdev mtsdsd   4734570 Apr 24 06:23 swift_trans_fofc_party.csv
-rw-rw----+ 1 mtsdsdev mtsdsd  12621265 Apr 24 06:23 swift_frontoffice_party.csv

When I am using the business date with the flatfile which will be changing on daily bases

My Query is the I have to sent the two flatfile in a mail the with attached in a Zip file .
the Flafile like these
Code:
 -rw-rw----+ 1 mtsdsdev mtsdsd  18918303 Apr 24 06:27 swift_frontoffice_party20170413.csv
-rw-rw----+ 1 mtsdsdev mtsdsd      1940 Apr 24 06:27 swift_trans_fofc_party20170413.csv




Moderator's Comments:
Mod Comment
Please stop pasting coloured plain text into your post when showing code etc.
Please wrap all code, files, input & output/errors in CODE tags.
It makes it far easier to read and preserves multiple spaces for indented or fixed-width text.

Last edited by rbatte1; 04-24-2017 at 01:58 PM.. Reason: Code tags again.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

“sed” replace date in text file with current date

We want to call a parameter file (.txt) where my application read dynamic values when the job is triggered, one of such values are below: abc.txt ------------------ Code: line1 line2 line3 $$EDWS_DATE_INSERT=08-27-2019 line4 $$EDWS_PREV_DATE_INSERT=08-26-2019 I am trying to write a... (3 Replies)
Discussion started by: pradeepp
3 Replies

2. Shell Programming and Scripting

Script to determine Date,TotalFile,total size of file based on date

I have file listed like below -rw-r--r--+ 1 test test 17M Nov 26 14:43 test1.gz -rw-r--r--+ 1 test test 0 Nov 26 14:44 test2.gz -rw-r--r--+ 1 test test 0 Nov 27 10:41 test3.gz -rw-r--r--+ 1 test test 244K Nov 27 10:41 test4.gz -rw-r--r--+ 1 test test 17M Nov 27 10:41 test5.gz I... (5 Replies)
Discussion started by: krish2014
5 Replies

3. UNIX for Dummies Questions & Answers

How to pick the latest file with date as one among the file name.( not exactly present date.)?

i have files like 1)20131112_abc_01.csv and 2)20131113_abc_01.csv and 3)20131113_abc_02.csv when i try to fetch the file in the next day. it shud pick the third file.. plz help me.. and i use `date +"%Y%m%d"` command to fetch..it fetches the current date... (2 Replies)
Discussion started by: applepie
2 Replies

4. Shell Programming and Scripting

Searching for unknown date inside the file and replace to new date

Hello, Iam a newbies to Shell scripting. Iam trying to replace the date inside the file to new date. is there anyway that we can just use the pattern to search as "..." I have many files want to replace with the same date, and each file contains different date. Thanks for your help. ... (2 Replies)
Discussion started by: Daro
2 Replies

5. Shell Programming and Scripting

finding date numeral from file and check the validity of date format

hi there I have file names in different format as below triss_20111117_fxcb.csv triss_fxcb_20111117.csv xpnl_hypo_reu_miplvdone_11172011.csv xpnl_hypo_reu_miplvdone_11-17-2011.csv xpnl_hypo_reu_miplvdone_20111117.csv xpnl_hypo_reu_miplvdone_20111117xfb.csv... (10 Replies)
Discussion started by: manas_ranjan
10 Replies

6. Shell Programming and Scripting

ksh compare dates INSIDE a file (ie date A is > date B)

In KSH, I am pasting 2 almost identical files together and each one has a date and time on each line. I need to determine if the first instance of the date/time is greater than the 2nd instance of the date/time. If the first instance is greater, I just need to echo that line. I thought I would... (4 Replies)
Discussion started by: right_coaster
4 Replies

7. UNIX for Dummies Questions & Answers

Delete a row from a file if one column containing a date is greater than the current system date

Hello gurus, I am hoping someone can help me with the required code/script to make this work. I have the following file with records starting at line 4: NETW~US60~000000000013220694~002~~IT~USD~2.24~20110201~99991231~01~01~20101104~... (4 Replies)
Discussion started by: chumsky
4 Replies

8. Shell Programming and Scripting

finding the previous day date and creating a file with date

Hi guys, I had a scenario... 1. I had to get the previous days date in yyyymmdd format 2. i had to create a file with Date inthe format yyyymmdd.txt format both are different thanks guys in advance.. (4 Replies)
Discussion started by: apple2685
4 Replies

9. UNIX for Dummies Questions & Answers

Move A File With Same Date,don't Change The Desitination Dir Date

Assume, I created one file three years back and I like to move the file to some other directory with the old date (Creation date)? Is it possible? Explain? (1 Reply)
Discussion started by: jee.ku2
1 Replies

10. UNIX for Dummies Questions & Answers

Changing Creation Date to a Prespecified Date of a File In Unix

Dear Expert, Is there a command to do that in Unix? In such a way that we don't need to actually "write" or modified the content. -- monkfan (4 Replies)
Discussion started by: monkfan
4 Replies
Login or Register to Ask a Question