Hi,
I've created a VC job that executes an Oracle script, which inserts messages into an Oracle table. The VC job then retrieves these messages from the Oracle table, and I want it to email me the results. The results actually look like this:
Checking: Store [0280], Pkt Ctrl Nbr [728570]
Carton Header: Expected [ 10], Actual [ 10]
Carton Detail: Expected [ 61], Actual [ 61]
Pickticket Header: Expected [ 1], Actual [ 1]
Pickticket Detail: Expected [ 58], Actual [ 58]
Outbound Stop: Expected [ 1], Actual [ 1]
Outbound Load: Expected [ 1], Actual [ 1]
Checking: Store [0281], Pkt Ctrl Nbr [728571]
Carton Header: Expected [ 6], Actual [ 6]
Carton Detail: Expected [ 33], Actual [ 33]
Pickticket Header: Expected [ 1], Actual [ 1]
Pickticket Detail: Expected [ 33], Actual [ 33]
Outbound Stop: Expected [ 1], Actual [ 1]
Outbound Load: Expected [ 1], Actual [ 1]
But what's getting emailed is this:
Checking: Store [0280], Pkt Ctrl Nbr [728570]
Carton Header: Expected [ 10], Actual [ 10]
Carton Detail: Expected [ 61], Actual [ 61]
Pickticket Header: Expected [ 1], Actual [ 1]
Pickticket Detail: Expected [ 58], Actual [ 58]
Outbound Stop: Expected [ 1], Actual [ 1]
Outbound Load: Expected [ 1], Actual [ 1]
Checking: Store [0281], Pkt Ctrl Nbr [728571]
Carton Header: Expected [ 6], Actual [ 6]
Carton Detail: Expected [ 33], Actual [ 33]
Pickticket Header: Expected [ 1], Actual [ 1]
Pickticket Detail: Expected [ 33], Actual [ 33]
Outbound Stop: Expected [ 1], Actual [ 1]
Outbound Load: Expected [ 1], Actual [ 1]
So it looks like VC is taking everything that contains multiple spaces side-by-side and assuming that I meant to only use a single space. I have no idea why it's doing this, or how to stop it. It seems to me that it should be taking each line of output exactly as it appears in the first block above, and doing absolutely nothing to it other than what I tell it to do. In this case, I don't believe I've told it to replace any text.
I've tried a variety of things, although I'd think that simply inserting the StdOut variable from my SQL task into the email HTML body should be fine. I've also tried looping through each line in the results and updating a job variable to insert the appropriate HTML tags (<br>, <p>, etc). I've also tried exporting the results to a text file (that part retained the formatting), and then inserting a FileContent variable in the email's HTML body (that part removed the formatting).
Any thoughts?
Thanks.