Code

ThisElement = @Left(ThisElement, 12) 

Code

// ========== BEGIN Custom Text Padding/Trimming Function ==========
// @cuPad(X, N, J)
// Type: Text/String
// Parameters: X as String, N as Integer, J as Integer
// Returns: String

// Returns X padded with N spaces and J justified.
// 1 = Left-Justified
// 2 = Right-Justified
// 3 = Center-Justified

// Examples of usage:

// @cuPad(Name, 32, 1)
// Returns the contents of the Name LE plus enough spaces to make a total of 32 characters,
// and it will be left-justified (i.e. the spaces will be added to the right side).

// @cuPad(@cuDecimals(Amount, 2), 8, 2)
// Returns the string value of Amount plus enough spaces to make a total of 8 characters,
// and it will be right-justified so that the decimals line up.

FUNCTION @cuPad(vStr as String, N as Int, J as Int) as String

Var vA as String
Var vSpcs as Double
Var vLt as Double
Var vRt as Double

If @Len(vStr) <= N
{
	If J = 1
		vA = vStr + @Text(N - @Len(vStr), " ")

	If J = 2
		vA = @Text(N - @Len(vStr), " ") + vStr

	If j = 3
	{
		vSpcs = ( N - @Len(vStr) ) / 2
		vLt = @Int(vSpcs)
		vRt = N - ( vLt + @Len(vStr) )
		vA = @Text(vLt, " ") + vStr + @Text(vRt, " ")
	}
}
Else
	vA = @Left(vStr, N - 2) + ".."

Return vA

END FUNCTION
// ========== END Custom Text Padding/Trimming Function ==========