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

FoxPro DefaultExt function

Using DefaultExt() to correct file extensions in a FoxPro program.

FoxPro ForceExt function

Using ForceExt() to correct file extensions in a FoxPro program.

FoxPro JustExt function

Using JustExt() to get the extension from a file name.

May 2013

Very frustrated with Access at the moment. It can append data from an email into a table but it only seems to work with Outlook.

Access and FoxPro development from Alvechurch Data

Database development and training for Birmingham and the midlands

Specialists in Microsoft Access and Visual Foxpro database training and development

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