In Outlook spooled file data is not getting displayed properly

Shell Programming and Scripting
1

I am fetching a database table in spool file and send that details as a email.

The Spooled file content is properly being displayed in UNIX.

See Example below :

        ID|FILENAME         |ABCDEF_DT |PROCESSED_DT        |STATUS
----------|-----------------|----------|--------------------|----------
         1|FILENAME         |09-sep-2012|11-sep-2012 04:09:31|SUCCESS
         2|FILENAME         |02-jul-2012|11-sep-2012 04:09:58|SUCCESS
         3|FILENAME         |09-sep-2012|11-sep-2012 04:09:38|SUCCESS

However, when i send the same content as a email. The data is not displayed properly ("-----|---- '' this lines are getting repeated after the column name )

See example below which is being displayed in outlook:

        ID|FILENAME          |ABCDEF_DT |PROCESSED_DT        |STATUS
----------|------------------|----------|--------------------|--
----------|------------------|----------|--------------------|--
----------|------------------|----------|--------------------|--
----------|------------------|----------|--------------------|--
----------|------------------|----------|--------------------|--
----------|------------------|----------|--------------------|--
----------|------------------|----------|--------------------|--
----------|------------------|----------|--------------------|-
	 1|FILENAME         |09-sep-2012|11-sep-2012 04:09:31|SUCCESS
         2|FILENAME         |02-jul-2012|11-sep-2012 04:09:58|SUCCESS
         3|FILENAME         |09-sep-2012|11-sep-2012 04:09:38|SUCCESS

I am spooling the file and then using the below command to send an email.
Also, have set the below for the sool file:

set feedback off lines 32766 TERM OFF pagesize 32766 trimspool on colsep "|"

cat $spool_file_name | mailx -s "message" -r email_id

Can anyone help me out to resolve this issue and to get the output similar to the spool file generate in unix. (i.e. avoid repetition of "-------|-----" after column)

Thanks in Advance !!

2

There are plenty post on the subject in the forum, di you do a little search?
look here for a start, should give you clues on what is missing...

3

yah i did lot of searches here, but it dint resolved my issue.
:frowning:

---------- Post updated at 09:36 AM ---------- Previous update was at 04:14 AM ----------

The only option left with me is to delete the below pattern from the spool file and send it as an email .

"----------|------------------|----------|--------------------|--"

As a work around this works for me as of now.:wall:

If you guys have any other suggestions then please share.:slight_smile:

4

You didnt say if you tried with uuencode as in the link given above...

5

You want me to use the below way?

cat $spool_file_name | uuencode | mailx -s "message" -r email_id