Removing spaces in VBA and VFP

VBA

Trim(), LTrim(), RTrim()

VFP

Trim(), LTrim(), RTrim(), AllTrim()

Notes

The languages appear to be very similar but there is a difference in the behaviour of Trim() In VBA Trim() removes leading and trailing spaces; in VFP Trim removes trailing spaces only and is the same as RTrim(). Use AllTrim() to remove leading and trailing spaces.

SubStrings  |  Text functions  |  Finding characters

Access Tips

FoxPro Tips

General Tips

 

Related Items

VFP and VBA.

The Visual FoxPro and Visual Basic for Applications languages are similar but there are annoying differences between them.

Read More

Text delimiters in VBA and VFP.

Visual FoxPro and Visual Basic for Applications both use quotes to delimit strings but FoxPro has alternative methods.

Read More

Text concatenation in VBA and VFP

Concatenating text strings in Visual FoxPro and Visual Basic for Applications.

Read More

Text substrings in VBA and VFP

Both Visual FoxPro and Visual Basic for Applications let you extract substrings from within a string of text

Read More

Finding characters in VBA and VFP

Both Visual FoxPro and Visual Basic for Applications let you find the position of one character inside another string.

Read More