If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Delimiting Field Containing - Character
I need to turn the following types of number strings into a date
field: 03-1-12345 98-12-12345 Where, the strings would represent: January 2003 December 1998 In Excel, I could just use the function Text to Columns, and delimit on the character "-" and then put the string back together. Unfortunately, I am accessing this table using ODBC, and the values for this field are constantly updated. Any help would be most appreciated. |
Thread Tools | |
Display Modes | |
|
|