Re: Right Justify amounts

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 04/09/04 

Date: Fri, 9 Apr 2004 08:26:16 +0100

In addition to Sue's comments I would add that because you are using FW text
files then maybe you can pad the strings as they go to text file so

Source val = 1234
Destination val needs to be 1234

I would convert to string and then pad the length at the start with " "
until I reached the length of my column 

-- 
-- 
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
news:dbrb70hi5acpc3re0cnuv85r12td6ub83k@4ax.com...
> Jim,
> Basically, you don't. Justification of data is a controlled
> through whatever client tool you use to view the data. You
> would control display behavior through a client app, not on
> a transformation.
>
> -Sue
>
> On Thu, 8 Apr 2004 16:22:28 -0500, "Jim Covington"
> <jim@firstbankms.com> wrote:
>
> >I am using DTS in SQL 2000 to download data to a text file.  (Fixed Width
> >Columns)
> >
> >All works well but the numbers are all left justified.
> >
> >How to I right justify in Transformations?
> >
> >Jim
> >
>

Relevant Pages

  • Re: Rich Koerner, guitar strings and WD-40
    ... I personally don't use chemicals on the strings. ... Lastly I go over the tops of the strings with the pad. ... my Les Pauls look and feel after cleaning them (very lightly, ... cleaning the frets, and at the same time getting the gunk off the ...
    (alt.guitar.amps)
  • Re: Wondering if you guys can help with my Awk homework
    ... information for each partition table on my vm that starts with /dev. ... incorporate the string format and the right justification? ... which include a single quote inthe strings to be printed but you can't put a ' in a command-line awk script so that's not the simplest of examples - just get rid of any 's you see within strings in those examples as I did above. ...
    (comp.lang.awk)
  • Re: Williams plays Satie
    ... I used to have an Italian made guitar with what you describe. ... the chrome bar on the thing and it would press a felt pad under the ... individual stops for strings, operated by foot pedal - no less! ...
    (rec.music.classical.guitar)
  • Re: padding a string with characters
    ... I suppose you want to pad the strings to a fixed size. ... function in vbscript, but you can write your own, .e.g ... If Len< nWidth Then ...
    (microsoft.public.scripting.vbscript)
  • Re: padding a string with characters
    ... I suppose you want to pad the strings to a fixed size. ... function in vbscript, but you can write your own, .e.g ... If Len< nWidth Then ...
    (microsoft.public.scripting.vbscript)