Search Results

What operating system are you using?

What shell are you using?

What have you tried to solve this problem on your own?

Given that you have two "TPLD Starting" events at the start of your log...

I think this may work for ksh:
case $- in
*l*) stty ... ;;
*) echo ;; # Do nothing
esac

bash would have *i* instead of *l*

I suspect the difference arises from the remote ftp code's rename command being implemented two different ways on the remote servers:

system 1
call the equivalent of C: system ("mv oldfilename...

See date --help for your system specific date options.

On my RedHat based system Fedora, i could use either one of these two lines to get your 'now' time:
NOW=$(date +%F%T|sed s,-,,g|sed s,:,,g)...

Try

awk -F'|' '{ for (i=1;i<=NF;i++) if ($i=="") $i="FK"}1' OFS='|' infile

you can do all 6 in a loop

for file in file1,file2,file3,file4,file5,file6
done
awk -F'|' '{ for...

Is this really corruption or is it due to the file having been written using the wrong language settings or UTF settings?

A lot of Linux systems have the iconv command to convert from one NLS...

Assuming that all of the records for a given table are on adjacent lines in your input file (as in your sample input), the following seems to do what you want:
awk -F"|" '
function prtable() {...

Here is one way of doing it.

Define an array with all Teradata supported data types, match and print:
awk '
BEGIN {
DT["BYTEINT"]
DT["DECIMAL"]
...

You mean the 3rd and 4th field?
Using GNU awk


awk -F\| '
NR>1{
t1=$3; t2=$4
gsub(/[-:]/," ", t1); gsub(/[-:]/," ", t2)
if(mktime(t2) < mktime(t1))
$4=0
}1
' OFS=\|...

I thought I had tested that as well. Rats! Try this:awk '{gsub (/CHAR\(([^1]|[12][0-9])\)/,"VAR&")}1' file
cur_rev_stage_cd VARCHAR(15) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,...

$ cat file
Tue Jun 18 05:00:02 EEST 2013 | file_check.sh| Message:script has files to process.
Thu Jun 20 05:00:02 EEST 2013 | file_check.sh| Message:script has files to process.
Fri Jun 21...

Or try:
find * -name aaa.txt -print