Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Escape character supported in FORMAT mask?
Message
De
10/12/2005 07:26:21
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
01076855
Message ID:
01076858
Vues:
9
>Given: cTimeStamp="200512081545"
>Then TRANSFORM(cTimeStamp,"@R 9999/99/99 99:99") returns "2005/12/08 15:45" as expected.
>
>Let's say I want it to return "2005/12/08 at 15:45"
>This causes a problem.
>TRANSFORM(cTimeStamp,"@R 9999/99/99 at 99:99") uses the "a" in "at" as part of the format mask.
>
>Is there a way to specify an "escape" character so you can actually interpose an "a" or a "#" or a "!" as a fixed part of the output?
>
>THanks very much.

Mark,
Formerly I needed the same thing and couldn't find a direct solution. Instead I placed placeholder and replaced it. ie:

? Strtran(TRANSFORM(cTimeStamp,"@R 9999/99/99 --- 99:99"),'---','at')

Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform