Viewing 6 posts - 1 through 6 (of 6 total)
At this point and considering the last line in your example above, why is it that you need to converted dates embedded in a file name to a certain format?
Naming...
September 30, 2013 at 4:20 pm
I havent had much experience with Tally tables so do no know how to utilize them.
The "OR" x12 in the where clause it fine for now. Ill probs just create...
September 30, 2013 at 12:11 am
How or where would i add the below
Where [SourceData] like '%[0-9]%' + 'Jan' + '[0-9]%'
as lots of data gets messed up with dwains code, and want to limit it to...
September 30, 2013 at 12:06 am
Awesome guys thank you so much. Beats manually going through 200,000 rows in multiple excel files to change the date 🙂
September 29, 2013 at 9:44 pm
The following will work but only with the understanding that no other numeric digits can exist in the string as the current test data would have it.
Awesome, thanks for...
September 29, 2013 at 9:12 pm
Viewing 6 posts - 1 through 6 (of 6 total)