Removing extra blanks in a memo field

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Removing extra blanks in a memo field

Message

From

04/04/2000 16:00:23

Josh Assing
Jassing Consulting
Anderson Island, Washington, United States

04/04/2000 15:45:04

Claude Goldman
Brown University
Providence, Rhode Island, United States

General information

Forum:

Visual FoxPro

Category:

Reports & Report designer

Title:

Re: Removing extra blanks in a memo field

Miscellaneous

Thread ID:

00355212

Message ID:

00355224

Views:

>I am using a sql select statement to retreive data from several tables. At

How about using a UDF?

FUNC reducememo
PARAM tcData
LOCAL tcResult
tcResult=reduce(CHRTRAN(CHRTRAN(tcData, CHR(13),''), CHR(10),''), SPACE(1))
RETURN tcResult
ENDFUNC

Map

View

Click here to load this message in the networking platform