I am writing a series of tokens to text box. I want the text to be columized. How can I use token formating or regular expressions to make each token a fixed length to get the text in columns.
Are you trying to display text in a table-like way within a textbox? If so, that's going to present a challenge because character pixel widths are inconsistent.
For example, each of the following is 10 characters (5 letters, 5 whitespace) but the visible "length" varies significantly.
TESTA |
TestB |
TESTW |
Brian, I think your best option is to use a Script Activity.
Protected Overrides Sub Execute()
'Write your code here.
Dim sPhrase As String = GetTokenValue("StringToPad")
Dim sLen As String = GetTokenValue("OutputLength")
Dim iLen As Integer
If Integer.TryParse(sLen,iLen) Then
If sPhrase.Length < iLen Then
SetTokenValue("PaddedPhrase", sPhrase.PadRight(iLen))
Else
' To return truncated to iLen
SetTokenValue("PaddedPhrase", sPhrase.Substring(0, iLen))
' To return whole string
' SetTokenValue("PaddedPhrase",sPhrase)
End If
End If
End Sub