Search Results

thanks for your help

The letters YYYYMMDD are actually going to be a date 20070531. So that will not work.

I have a file name in this format

ABC_WIRE_TRANS_YYYYMMDD_00.DAT

I need to cut out the _00 out of the file name everytime. It could be _00, _01,_02, etc ....

How do I cut it out to look as...

awk 'BEGIN{FS="|"}{$19="USD";$0=$0;print}' file is giving me an error

$ awk 'BEGIN{FS="|"}{$19="USD";$0=$0;print}' US_RETAIL_WIRE_TRANS_20070504_00.TST
awk: can't set $0
record number 1

...

I have a pipe delimited file. I want to replace the contents of field 19 with the value USD. Does anyone know the command for this?

I have a shell script that executes and sends out an email. Currently I cat out a report into the body of the email.

mailx -s "My Report: ${ORACLE_SID} ($FILEDATE)" \
myemail@us.com < ...

We have started to us the su option on our production server. We log in with our own id and then su into a special id to perform various tasks. This allows our actions to be monitored.

I need to...

Thank you.

I don't have the sample file yet but it would be something like

Header Record
Indicator 'HR'
Date 'YYYYMMDD'
Version 1

Record Layout
acct no varchar2(10)
indicator...

I get a transaction file and I need to sum two of the columns. I each record I get a debit(D) or credit(C) indicator. Then I get an amount field. I need to sum the total dollar value of debits and...

I have a record in a file that ends with the new line character "\n". How dio I determine the hexadecimal value for that?

I have a file that I want to grep and identify all of the illegal characters. I have a list of legal ascii characters

\11\12\40-\176,\0-\255

so i try a grep -v to exclude these but my syntax...

Is there a way not to display the password in the sys out when your korn shell script logs into sqlplus?

Does anyone have an example of a korn shell scripts kicking of multiple background processes and then using the wait command to get the return code from those processes?

I want to write a program...

I am Solaris korn shell. I want to create a symbolic link. I have a directory

/u01/ftp01/db


I want to reference it as

/u05/swe/my (this is not a real directory)

I tried a symbolic link...

How do I substitute a word throughout a file? For example change all instances of the word John to Mark. This would be in vi for korn shell.

/mydir>#!/bin/ksh
/mydir>echo $ORACLE_HOME

/mydir>./.myvars
/mydir>echo $ORACLE_HOME



I get nothing before or after?

.myvars contents (I changed the dir names for this post)
...

The profile of the user is empty. Then before I run the script I want I run a parameter file that populates the variables for oracle.

ORACLE_HOME
ORACLE_BASE
ORACLE_SID
PATH

etc ...


But...

thank you

I am having problems loading a file into my database and I think it is the new line character. Is there a way to have unix identify the new line character? I have two files one that loads and one...

thank you.

Once a file is ftped to a server is there a way that you can prevent that file from being overwritten if the same process tries to ftp a file with the same name again?

That worked. Thanks

I have a large file that I am grepping to find a certain string.


grep 'C:\Data\Directory\Test.txt' test.txt


It can not find it even though I know it is in there . I know that there is a...

thanks for your help