Any method equivalent to PadLeft/PadRight?

by

I don’t believe there are any explicit PADLEFT or PADRIGHT functions, but you can use a combination of SPACE and LEFT or RIGHT to prepend spaces to your string, and then grab the right X number of characters.

PADLEFT

strOrdNo = RIGHT(Space(8) & strOrdNo, 8)

If you want a character instead of spaces, you can use STRING instead of space (the example below left-pads with X):

strOrdNo = RIGHT(String(8, "X") & strOrdNo, 8)

PADRIGHT

strOrdNo = LEFT(strOrdNo & Space(8), 8)

strOrdNo = LEFT(strOrdNo & String(8, "X"), 8)

More Related Contents:

  1. How to extract file name from path?
  2. How to find numbers from a string?
  3. Check if a string contains another string
  4. Split string into array of characters?
  5. Implementing String.Format() in VB6
  6. Matching similar but not exact text strings in Excel VBA projects
  7. Build a Comma Delimited String
  8. Excel VBA like operator [closed]
  9. How to compare strings in Bash
  10. Convert Int to String in Swift
  11. What are the differences between Rust’s `String` and `str`?
  12. How do I remove the file suffix and path portion from a path string in Bash?
  13. Get string after character [duplicate]
  14. How to generate a random string of a fixed length in Go?
  15. In Perl, how can I read an entire file into a string?
  16. How can I compare a string to multiple correct values in Bash?
  17. Convert string to integer type in Go?
  18. Finding the ranking of a word (permutations) with duplicate letters
  19. How to concatenate strings with padding in sqlite
  20. Extract numeric part of strings of mixed numbers and characters in R
  21. How can I sort a list of strings in Dart?
  22. Unicode string literals in VBA
  23. Delete certain lines in a txt file via a batch file
  24. Integer PadLeft function in T-SQL
  25. When using the MOV mnemonic to load/copy a string to a memory register in MASM, are the characters stored in reverse order?
  26. Convert specified column in a multi-line string into single comma-separated line
  27. Convert time.Time to string
  28. Swift – Split string over multiple lines
  29. Groovy String to Date
  30. What is the difference between VBScript’s + and & operator?

Leave a Comment