Search Results

Hi All,

We have a HTML source which will be processed using a informatica workflow. In between these two we have a Unix script which transforms the file.

We are getting an error from past week...

EX:000256 in abc.csv becomes 256 when i open the mail attachement.

I do not get an option to open the attachement using notepad using outlook

it comes in as an attachement.Double click

Hi Rudi,

This unix script mails the .csv file which is already created by a informatica process.I am not seeing leading zeros when the script mails the .csv file and when we open the mail...

Hi All,

I am using a informatica job to create a csv file and a unix script the mail the generated file.Everything is working fine but I am not seeing leading zeros in the csv file sent in the...

Thanks for the suggestion joeyg : ) I used CSV file instead of xls and it worked

Hi All,

I have created a unix script to mail the xls file.This is being done using mailx command


fdate=`tail -1 abc.xls | cut -c1-8`
SUBJECT="CARD GL Exceptions : ${ENV} for ${fdate}"...

Sorry for the inconvienece RudiC.I will take care of it in future.Both the solutions provided by you is working fine ...Thanks a lot for the help!:b::b:

Hello All,


I have developed a script which selects a particular filed from a file ,trims it,searches for a particular pattern and then mail it when found.


cat test_file.txt |sed -n...

Hi,


I need to capture the error code before exiting the program.


if [ $data_file_cnt -ne $trg_file_cnt ]
then
echo "Actual count between $data_file and $trigger_file not matching [fail...

Hello Everyone,

I have written a file validation script in unix to compare the data and trigger file.My requirement is if the file validation fails,I need to upate the error details in a table
...

Thanks for the reply...here is the snippet

#!/bin/sh
#Two input parameters USER_ID and Password
DB_USER=$1
DB_PWD=$2
result=`sqlplus -s $DB_USER@D1TFDDS/$DB_PWD<<EOF
spool sample.txt
sql...

Hello Everyone,


I have developed a shell script which takes schema id and password as parameter to login into database using sqlplus,runs a query and mails the result.


My requirement is...

there are 3703 rows..please find the attachment

Hello,

I am facing issue in summing up a column in unix.I am displaying a column sum up to 4 decimal places and below is the code snippet



sed '1d' abc.csv | cut -d',' -f7 | awk...

Thanks Anbu ..its working fine..i am facing a starnge issue now:)

command given by you works fine if there is no control m appended at the end of the line or else it will display 0.0000 ....is...

Hi Andu23,

Thanks for the reply..

I am not able to display any result with the command.



cat test.txt
01/31/2014,3702,-170552450514.86

cib-sokay2{}:awk -F"," ' NR > 1 {...

Hello everyone,

I am comparing two floating point numbers by storing them in seperate files and then using difference command to verify,it is working fine.

But I want to compare two values...

Hi,

Could you please help me out with this requirement


awk -F, 'FNR==NR{X[$1 FS $2]=$1 FS $2;next} ($0 in X){print X[$0] " entry from file1 is present in file2.";delete X[$0]} END{for(i in...

Thanks a lot Ravinder and Akshay..its working :b:

Thanks Ravindra for the solution.

I am getting syntax error when trying to execute the same.

cib-sokay2{u384283}167:awk -F, 'FNR==NR{X[$1 FS $2]=$1 FS $2;next} ($0 in X){print X[$0] " entry...

Hi Everyone,
I am comparing results of two environments using unix files.

I am writing two different csv file using spool and merging both the files using paste command

paste -d, file1.csv...

Hi Everyone,
I am facing problems in sending html mail with attachemnt.
I will able to send mail with attachment (plain text ) using mailx -s and uuencode command and
also html mail without...