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

VFP and VBA.

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

Text delimiters in VBA and VFP.

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

Text concatenation in VBA and VFP

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

Text substrings in VBA and VFP

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

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.

August 2008

The end of an era. Our last PC with a 5 1/4 inch disk drive has just failed. We've kept the drive on a shelf in the office just in case somebody turns up with a disk full of old data.