Printable View
How do you Create your own user-defined string formats.
I need to take string variable of x number of characters and pad with spaces so its length is always 25 characters. I would like to use a Format command and according to the Help file I can use the "@" symbol to represent a character placeholder, but it wont work.
Thanks for the reply, but not quite what I'm after.
What I am trying to do is:
A$="abcdefghijkl" 'Test input string
B$=format (A$,"!@@@@@") ' Keep first five characters and discard remaining.
debug.print B$ 'Print result
Maybe I need to just read 5 characters fron left side then fill remaining 15 character positions with spaces.
Any sugestions?
Quote:
Originally posted by Buzby:
If you define the string fixed length;
eg
Dim MyString As String * 25
it will always be 25 characters long (padded with spaces).
The Format command should work
eg;
format("hello","!@@@@@@@@@@")
would return "hello" followed by 5 spaces - if you leave the ! out it would return 5 spaces followed by "hello".
Does this help?
Left$(A, 5) will give "abcde"
------------------
Marty
What did the fish say when it hit the concrete wall?
> > > > > "Dam!"
If you define the string fixed length;
eg
Dim MyString As String * 25
it will always be 25 characters long (padded with spaces).
The Format command should work
eg;
format("hello","!@@@@@@@@@@")
would return "hello" followed by 5 spaces - if you leave the ! out it would return 5 spaces followed by "hello".
Does this help?