I am sending the results of an SQL in the body of an email, using a script task.
This is working great, but since the fields are of varying length, by tab deliminators aren't keeping everything lined up.
Is there another way to format the data? Is there a way to base the number of tabs on the length? (I am new to this, so actual code would be appreciated)
This is what's being sent:
Order # Part # Qty BO/Received
R101066254 DDE EA0034461002-CORE 0
X101253305 10R2602-CORE 0
X101253313 DDE R23535540-CORE 0
X101253315 3558045RX-CORE 0