Visual Basic and Visual FoxPro functions to remove spaces

VBA

Trim(), LTrim(), RTrim()

VFP

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

Common Syntax Notes

The syntax of the languages appears to be very similar but there is a difference in the behaviour of the Trim() function. In VBA Trim() removes leading and trailing spaces; in Visual FoxPro Trim() removes trailing spaces only and performs the same function as RTrim(). Use AllTrim() in VFP 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 Basic for Applications and Visual FoxPro delimiters for strings.

Text concatenation in VBA and VFP

Visual Basic for Applications and Visual FoxPro operators to concatenate text.

Text substrings in VBA and VFP

Visual Basic for Applications and Visual FoxPro functions to extract substrings from within a string of text

Finding characters in VBA and VFP

Visual Basic for Applications and Visual FoxPro functions to find the position of one character inside another string.

April 2010

The nice thing about this work is the variety. At the moment I'm working on databases for an auctioneer's, an industrial maintenance company, a manufacturer of cleaning materials and a fashion house. There's never time to get bored.

Alvechurch Data

Alvechurch Data

Database development and training for Birmingham and the midlands

Specialists in Microsoft Access and Visual Foxpro training and development

Phone us on 0121 445 1300, email sales@alvechurchdata.co.uk , or use our contact page