How do I pad a field with a given character?
Say I have an account number with varying length, and I need to pad the first few characters in the field with 0 so I always have 10 digits, how can I accomplish that in the fixed file destination?
How do I pad a field with a given character?
Say I have an account number with varying length, and I need to pad the first few characters in the field with 0 so I always have 10 digits, how can I accomplish that in the fixed file destination?
Try the PadLeft function found under the String category.