10 More Discussions You Might Find Interesting
1. UNIX for Beginners Questions & Answers
Hi Team
there is a requirement to do validate on Flat files using Shell Scripting.
Suppose we have two flat files ( F1, F2).
Validation
1. Row count between F1 and F2
a) Write it in a file with results of count of each file and differences if any
2. Apply checksum or any... (1 Reply)
Discussion started by: shlearner
1 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 am new to unix script.
i have two xml files. one is orderinfo.xml and another one is xsd file(EmailMessage.xml).
we need to compare the both file for poper nodes exists are not.
for example: <xsd:element name="EmailMessage"> tag in the EmailMessage.xml file(xsd sheet),this tag... (2 Replies)
Discussion started by: bmk
2 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. Shell Programming and Scripting
Hello,
I am working on an interface between a legacy system and an ERP system.The format of the data extracted into the staging folder from the legacy system is a follows.
One control file named ExtractDataControl.txt
Multiple entity files eg R1001.txt, R1002.txt, R1020.txt
The control... (5 Replies)
Discussion started by: Savio_Saldanha
5 Replies
7. Shell Programming and Scripting
Hi Gurus,
I used unix long time back. I need help for writing a unix script which can be automated and execute every day on specific time.
1.) This is the actual functional requirement.
Informatica should reject incoming files that have invalid filenames or file formats
2.) My File... (6 Replies)
Discussion started by: vsmeruga
6 Replies
8. 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
9. UNIX for Advanced & Expert Users
Hi All,
I got a file with 3 fields delimited by hyphen "-". I have to validate & cleanse the data before i begine the processing
Requirements
1. No record should contain more than 2 delimiters
2. No record should even contain less than 2 delimiters
3. Any records that matches rule 1 &... (3 Replies)
Discussion started by: minnuverma
3 Replies
10. Shell Programming and Scripting
My user is ftp a CSV file from window. There is possiblity to doing FTP through different mode.
This file is then picked by another program, but I want to make sure the FTP file would be always ascii format, bu releasing a commaon File <file name>
Can any one provide input , abut how to put a... (2 Replies)
Discussion started by: u263066
2 Replies