10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a sourcefile which contains data as below.I want to check whether datatype,structure and date format looks good as mentioned.
Data is delemited by cydila .
Source file-Emp.txt
sno name phoneno dept joineddate
1 vivek 0861 CSE 2013-05-29 00:00:00
2 dinesh 123456 ECE ... (2 Replies)
Discussion started by: katakamvivek
2 Replies
2. Shell Programming and Scripting
Hi there,
As a part of file validation, I needed to check for delimiter count in the file.
My aim is to find, how many records have failed to have predefined numbers of delimiters in the file.
My code looks like below
i=`awk -F '|' 'NF != 2 {print NR, $0} ' ${pinb_fldr}/${pfile}DAT |... (3 Replies)
Discussion started by: anandapani
3 Replies
3. Shell Programming and Scripting
Hi !!
I'm rather new both to the UNIX and scripting worlds, and I'm learning the ropes of scripting. Having said this, please excuse me if you notice certain basic errors.
I'm working on a script that implements .jar and .war files for a WAS environment and I need to perform certain... (4 Replies)
Discussion started by: levaldez
4 Replies
4. Shell Programming and Scripting
Hello,
File contains 1,3 and 5 are required columns. it's working use this command.
awk -F\| '$1 && $3 && $5' test1.txt > test2.txt
How can use this unix programming.while using runnign this scirpt,it's raising the error.
awk: ^ syntax error
#!/usr/bin/ksh
`awk -F\| '$1 &&... (3 Replies)
Discussion started by: bammidi
3 Replies
5. Shell Programming and Scripting
Hi All,
I am trying to validate the file name against the naming convention mentioned in configuration file. In the configuration file, the file name convention is mentioned as:
Myfile_SQ<NN>_<NN>_YYYYMMDD_HHMMSS.xml
The actual file received is Myfile_SQ10_30_20110423_073002.xml
How do... (1 Reply)
Discussion started by: angshuman
1 Replies
6. UNIX for Dummies Questions & Answers
Hi ,
I am trying to write a shell script which will validate all .csv file names in a directory , my file name format is as below.
CDR_SCAN_Report_YYYYMMDDHHMI.csv
1. I need to validate the name should start with CDR_SCAN_Report.
2. And the time stamp part is a valid time stamp,if it is... (1 Reply)
Discussion started by: shruthidwh
1 Replies
7. Shell Programming and Scripting
Hi All,
We need to use & execute some several scripts before loading the data successfully using Informatica.
Can you help me the below scenario:
We will be receiving the files from different countries, and using ftp all the files will be placed onto the server. The file structure will be (.csv... (6 Replies)
Discussion started by: psr2009
6 Replies
8. Shell Programming and Scripting
Hi all,
I have a list of xml file. I need to split the files to a different files when see the <ko> tag.
The list of filename are
B20090908.1100-20090908.1200_CDMA=1,NO=2,SITE=3.xml
B20090908.1200-20090908.1300_CDMA=1,NO=2,SITE=3.xml
B20090908.1300-20090908.1400_CDMA=1,NO=2,SITE=3.xml
... (3 Replies)
Discussion started by: natalie23
3 Replies
9. UNIX for Dummies Questions & Answers
Hi All,
I am new to UNIX scripting.
I need to validate a file. I need to check whether the file has a header , detail records and footer.
If all the file is good I need to create a status file with the status 'Y' else 'N'.
I have pasted the an example of the file below:
... (5 Replies)
Discussion started by: kumar66
5 Replies
10. UNIX for Advanced & Expert Users
I'm going through a script someone wrote and has left the company.
I've a file_name -> s31-d173-lookup-20060502111140-sr
In the ksh this is a validation :
if |)-(*)-(*)---(|-)-sr)) ]];
The validation for the above file_name fails. Any idea why and what is file
naming convention the... (2 Replies)
Discussion started by: F-1
2 Replies