Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Getting a date from .txt file or variable
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01329441
Message ID:
01329453
Views:
10
>The date is in DD/MM/YY format as text below
>
>I already have the line number
>
>I was thinking about something as:
>
>If line contains "2008" or "2009" or "2010", get the the year
>and also contents at its left side and then convert it to date with ctod ()
>
>Can anybody help me with this line, or is there a more smart solution ?
>
>Thanks
>
>
>
>piece of TXT file
>
>**********************************
>
>04/07/2008 10:54AC PRESIDENTE EPITACIO - PRESIDENTE EPITACIO/SPConferido
>
>******************************************************************************

Is it DD/MM/YY or DD/MM/YYYY because I see the full year here?
ldOldSet   = SET([DATE])
SET DATE BRITISH
lcDateStr  = LEFT(YourLine,8)
ldDate      =  CTOD(lcDateStr)
SET DATE &ldOldSet
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform