Solved

# Padding a field with a space

Posted on 2009-03-29
Medium Priority
3,159 Views
Last Modified: 2012-05-06
Hi All,

This should be an easy one.

I have a field that is two (2) characters in length. Sometimes the field will only have 1 character in it and most times it will be two,

I'm trying to add a space (" ") at the end of the data output so that it looks as follows:

Record #1 field has "AB" output 'AB'
Record #2 field has "A" output 'A ' (space after the A)

I think it something to do with the 'space' syntax and I can get it to work but it is adding it left of the field not right (i,e  ' A'

``````trimleft({HISMAST.CUSTOMER_ALPHA})+ right (space (2) + {HISMAST.STOCK_CATEGORY},2)+{HISMAST.STOCK_CODE}

// Customer_Alpha ="Arro"
// Stock_Category =W " - there is a space after the W field length 2
// Stock Code = "Multi"
``````
0
Question by:logonlarry
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• Learn & ask questions
2 Comments

Author Comment

ID: 24015491
Hi All,

I have found the solution on Web.

You have to create a custom function and insert the following :

Function (stringvar InString, numbervar StrLength)
// PadExact - make a string field an exact length, (FoxPro PADR)
// Input: InString, the string to be trimmed or padded
// StrLength, the desired length
// Example: PadExact(City,10)+State
// Antioch TN
// Nashville TN
left(trim(InString)+ space(StrLength),StrLength) ;

Then I simply went

trimleft({HISMAST.CUSTOMER_ALPHA})+ PadExact({HISMAST.STOCK_CATEGORY},2)+{HISMAST.STOCK_CODE}

and Bingo all is good

Hope this helps others
0

LVL 35

Accepted Solution

James0628 earned 2000 total points
ID: 24017470
The function is a bit much.  All you needed to do was change how you added the space.

right (space (2) + {HISMAST.STOCK_CATEGORY},2)

should be

Left ({HISMAST.STOCK_CATEGORY} + space (2), 2)

You were converting "A" to "  A" and the taking the rightmost 2 characters - " A".
The second version converts "A" to "A  " and takes the leftmost 2 characters - "A ".

James
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
###### Suggested Courses
Course of the Month14 days, 16 hours left to enroll

#### 771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.