How do you remove blanks within a field

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

How do you remove blanks within a field

Message

01/09/1998 11:13:47

Edward Pikman
Independent
New York City, New York, États-Unis

01/09/1998 11:09:21

Timothy Bowen
Boston, Massachusetts, États-Unis

Information générale

Forum:

Visual FoxPro

Catégorie:

Codage, syntaxe et commandes

Titre:

Re: How do you remove blanks within a field

Divers

Thread ID:

00131900

Message ID:

00131902

Vues:

>Is there a quick way to remove blanks within a field? For example PART NUMBER = 'TRG 011 4TGH 77K' to become 'TRG0114TGH77K'
>Thanks.

REPLACE ALL partnumber WITH strtran(partnumber," ","")

Edward Pikman
Independent Consultant

Répondre

Fil

Voir

Click here to load this message in the networking platform