You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Web Gen2 Pad Field with Spaces

in Warehouse Management 1 comment

Summary:

A question for Web Gen2 experts!

We need to export a csv file with fixed length fields. Item descriptions vary in length so I want to pad the right side of the field with spaces to achieve a fixed length. If the description is greater than 100 I want just the left most characters (I know how to do this with LEFT).

If the description is less than 100 I want to pad right so that the exported csv file has the field equal to a length of 100 like this:

Is there any combination of string functions that can do this?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!