Hello forum,
I have output from a database and need to correct the "changed" column to correct format and also extract the year and its quarter.
Column changed has "YYMMDDHHMM" the "0" disapears when open csv file in excel for years before 2010. I need to get full "YYYYMMDDHHMM" and also the year together with the quarter.
Need to run this in a vba solution.
Attached is some samples from the database. Column B and C is the output (wanted result)
Last edited by soreno; 09-20-2018 at 07:01 AM.
Here is the second part. Still working on the first part.
Please Login or Register to view this content.
Last edited by alansidman; 09-20-2018 at 04:57 AM.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Here's the first part
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by AlphaFrog; 09-20-2018 at 05:21 AM.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Or try:
Please Login or Register to view this content.
@AlphaFrog,
Excellent!! It works pretty fast too on my test of 900 000 rows, but if I have column "changed" at "F" and I want the output on "K" and "L", how would I change the code for that to work. I have a hard time to see where the actual output goes in your code...
Thanks
You're welcome.
Please Login or Register to view this content.
@AlphaFrog,
Lovely, it crunch thru almost a million rows in less then 10 seconds, very impressive
You're welcome. Thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks