Lots of ways to do it:
1) A set fields off a small table with AUG in one column and 08 in
another (can be enhanced easily to handle locales)
2) A guide (a general rule is to always use guides for discrete
functions) that has a bunch of filters (or ALs if that is what you are
thinking) with specific qualifications such as 'x' = "AUG" and actions set
fields, goto end of guide
3) Use a set fields with the STRSTR f() as in STRSTR("JANFEBMAR.", 'x')
then a second filter to throw an error if -1 else divide the number by 3 and
add 1 yielding the month - the strstr f() will return 0 for JAN, 3 for FEB
etc.
There are other ways that are harder to develop or more expensive for ARS
and so I am not mentioning them here.
The small table idea is a single filter to do the set fields and the filters
to set the rest of the date and can be enhanced easily to handle other
strings such as August.
The guide is more filters (12 with no other language support) but no table;
Remember that once a string is found (ie in every filter) skip to the bottom
so filters are not evaluated needlessly. Think:
F1: 'x' = "JAN" set y=1 goto lQuit
F2: 'x' = "FEB"
lQuit:
The function is probably the easiest with three filters, no table.
F1: no qual x=strstr.
F2: x = -1 error
F3 no qual x=x/3+1
x now holds the month
You are only limited by your imagination when solving problems of this sort
but do consider performance and ease of development (ie time to completion,
cost of maintenance, doc, etc)
Cheers
Ben Chernys
Senior Software Architect
Software Tool House Inc.
Canada / Deutschland / Germany
Mobile: +49 171 380 2329 GMT + 1 + [ DST ]
Email: <mailto:[email protected]> Ben.Chernys _AT_
softwaretoolhouse.com
Web: <http://www.softwaretoolhouse.com> www.softwaretoolhouse.com
Check out Software Tool House's free Diary Editor.
Meta-Update, our premium ARS Data tool, lets you automate
your imports, migrations, in no time at all, without programming,
without staging forms, without merge workflow.
<http://www.softwaretoolhouse.com/> http://www.softwaretoolhouse.com/
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Kemes, Lisa
Sent: May-19-11 21:26
To: [email protected]
Subject: String to Date Function
**
I have a date (i.e. 29-AUG-11) that I would like to convert to 8/29/2011. I
can't find any functions in AR to do this automatically.
I don't mind parsing it out and putting the DD, MMM, and YY into separate
fields and then putting them all back together in one field, but is there
any function that can turn "AUG" into "8" or "08"?
I've been looking at all the functions and it looks like there are a lot of
options to get the Weekday, Year and Month from this format 8/29/2011, but
how would I get it from this format? (29-AUG-11)
Lisa Kemes
AR System Developer
TE Information Systems
Global Infrastructure and Ops
+01 717 810 2408 tel
+01 717 602 9460 mobile
[email protected]
MS 161-43
P.O. Box 3608
Harrisburg, PA 17105-3608
<http://www.te.com/> Description:
http://www.tycoelectronics.com/images/socialmedia/smallTElogo.gif
www.te.com <http://www.te.com/>
<http://twitter.com/teconnectivity> Description:
http://www.tycoelectronics.com/images/socialmedia/twitter.png
<http://www.facebook.com/teconnectivity> Description:
http://www.tycoelectronics.com/images/socialmedia/facebook.png
<http://www.flickr.com/photos/teconnectivity/> Description:
http://www.tycoelectronics.com/images/socialmedia/flickr.png
<http://www.linkedin.com/groups?gid=1591657> Description:
http://www.tycoelectronics.com/images/socialmedia/linkedin.png
<http://www.youtube.com/teconnectivity> Description:
http://www.tycoelectronics.com/images/socialmedia/youtube.png
_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
<<image001.gif>>
<<image002.png>>
<<image003.png>>
<<image004.png>>
<<image005.png>>
<<image006.png>>
