I need to check a flatfile for various parameters like length of the record, format of record, any tab character present in the record etc.,
for checking presence of tab character, i'm trying to use the following code and i'm not sure if the same is right. Pls Help.
I check for Record to start with 'D' and total record length to be equal to 3168 and if tab is present in the record.
Thanks in Advance.
Regards,
Aravind. C
Last edited by aravindc; 04-17-2008 at 04:03 AM..
Reason: Meaningful subjectline
I have a file which is fixed width columns. This is an offset buffer - rather than space or tab delimited. There are upto about 8 columns and I need to get all of the column 5's values into another file.
The problem is that because the delimiter is a space - and some fields are blank - the 5th... (3 Replies)
Hi,
I am new to unix. I have a flat file that needs to be pgp encyrpted in ASCII format and ftped in Ascii format to remote location.
Can any one tell me the steps involved in the pgp encryption of the unix file. I will really appreciate if any one can help me with the pgp encryption shell... (1 Reply)
I'm posting the line I just added to my crontab because it's my first and I want to be sure it's doing what I'm intending it to do.
59 23 0 * 1-5 /export/<many_directories_later...>/scripts/get_clientkpi.sh
Supposed to do: Run script at 11:59pm every night, except weekends.
Question: If I wish... (4 Replies)
Sorry guys, busy working on a new project these days so I am not able to keep this topic update frequently.
Few days earlier I talked to some of my friends in China and understand more about the current situation of China's IT industry. From what they told me and considering my experience and... (6 Replies)
I have a set of flatfiles which have columns delimited by #. How can a particular column be deleted in all the flatfiles. All flatfiles have same number of columns. (5 Replies)
Hi,
I have the below script to check the count of delimeters for a file (here is File : test.csv Delimeter is ",")
awk '{gsub(/"*"/,x);print gsub(/,/,x)}' test.csv
And it return the output for each line as:
2
2
cat test.csv:
abc,xyz
"abc,zxyz",1
I need help one the below things:
- IS... (8 Replies)
Hi,
I am writing one unix script to get row count of few tables into one sequential file
my script is like this
$ORACLE_HOME/bin/sqlplus -s <<EOF >output.txt
userid/password@databasename
set verify off
set heading off
set feedback off
select count(*) count from tablel where ;
select... (4 Replies)
Hi all,
I am trying to generate an XML file from a flatfile in ksh/bash (could also use perl at a pinch, but out of my depth there!).
I have found several good solutions on this very forum for cases where the header line in the file forms the XML tags, however my flatfile is as follows:... (5 Replies)
I want to check for "errors" or "ORA-" in Y.if there is an error then exit
Y=`sqlplus -s user/passwd<< EOF
exec test_Proc;
exit;
EOF`
if ; then
exit 1
fi
but this doesnt work (6 Replies)
hello everyone,
I am new to linux and got this deliverable to write a script that should check for error in multiple log file (count is approx 2500 log files on single server) and once error is found, it should mail that error
My logic says:
we can put all log files path/location in one... (2 Replies)