IxiRancid Posted August 11, 2005 Posted August 11, 2005 Hi y'all is there a way I could force spaces into a string? I have a specification where the Address must be 25 charrs long (if blank charrs then blank it is...). This is the SQL sentence left(trim(b00ca2), 25) where I clearely specify the lenght of the field to 25 charrs. In vb.net I made this logical loop :rolleyes: like this myLenght = Len(datareaderBMBB10(1)) spcs = 25 - myLenght string = datareaderBMBB10(1) & Space(spcs) & ..... Is there a better way? Quote
Administrators PlausiblyDamp Posted August 11, 2005 Administrators Posted August 11, 2005 something like Dim s As String s = "test string" s = s.PadLeft(25) Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
IxiRancid Posted August 11, 2005 Author Posted August 11, 2005 works... where in the dust of MSDN did you find that one :) thanks! Quote
IngisKahn Posted August 11, 2005 Posted August 11, 2005 Object Browser is your friend :) Quote "Who is John Galt?"
Joe Mamma Posted August 11, 2005 Posted August 11, 2005 Object Browser is your friend :) "when in doubt. . . right click!!!" Quote Joe Mamma Amendment 4: The right of the people to be secure in their persons, houses, papers, and effects, against unreasonable searches and seizures, shall not be violated, and no warrants shall issue, but upon probable cause, supported by oath or affirmation, and particularly describing the place to be searched, and the persons or things to be seized. Amendment 9: The enumeration in the Constitution, of certain rights, shall not be construed to deny or disparage others retained by the people.
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.