Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Escape character supported in FORMAT mask?
Message
 
 
To
10/12/2005 07:26:21
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
01076855
Message ID:
01076863
Views:
11
>>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

Thanks... that's what I'm going to do too.
Previous
Reply
Map
View

Click here to load this message in the networking platform