How to extract info from csv files to excel
Solved/Closed
Related:
- How to extract info from csv files to excel
- How to clear recent files in windows 11 - Guide
- Number to words in excel - Guide
- How to take screenshot in excel - Guide
- How to open msi files on android - Guide
- How to download audio file from messenger - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Dec 27, 2011 at 03:22 PM
Dec 27, 2011 at 03:22 PM
for #1, the file needs to be opened by code in order to read data
for #2, since the name seem to have color attached just after the last _, one can extract that information to goto to right tab
for #2, since the name seem to have color attached just after the last _, one can extract that information to goto to right tab
I understand opening and getting info I need and I think it might be easier to calculate my forecast formula on each fiile I open then copy the exact cells I need which would be 7 specific cells. I will not be needing to save the files just close them out even though I am calculating a formula from data which I then will pull off values into my worksheet. But now How do do this on a loop?
I am still confused on how to go about opening 74,00 csv files in a loop. An example of the files names are as follows:
Pmuck_pac.2011.12.09_13.53.04_PinkA.csv
Pmuck_pac.2011.12.09_13.53.04_PinkB.csv
Pmuck_pac.2011.12.09_13.53.04_PinkC.csv
Pmuck_pac.2011.12.09_13.53.04_BlueA.csv
Pmuck_pac.2011.12.09_13.53.04_BlueB.csv
Pmuck_pac.2011.12.09_13.53.04_BlueC.csv
Pmuck_pac.2011.12.09_13.53.04_YellowA.csv
Pmuck_pac.2011.12.09_13.53.04_YellowB.csv
Pmuck_pac.2011.12.09_13.53.04_YellowC.csv
Pmuck_pac.2011.12.09_13.53.04_RedA.csv
Pmuck_pac.2011.12.09_13.53.04_RedB.csv
Pmuck_pac.2011.12.09_13.53.04_RedC.csv
Pmuck_pac.2011.12.09_13.53.04_PurpleA.csv
Pmuck_pac.2011.12.09_13.53.04_PurpleB.csv
Pmuck_pac.2011.12.09_13.53.04_GreenA.csv
What does change is the date & military time eveything else is repeated in 15x blocks of:
Pmuck_pac...................._ColorsA,B,C.csv
Not sure what is an easy method to opening up files in 15x blocks or all PinkA then Pink B, etc thatt way the system does not crash trying to open so many files (74,000). Any help with the code would be helpful. I have code to insert my FORECAST function into the csv file then pulling data from those cells and copy to a workbook but now How do I tackle the mountain of opening csv files 74,000 times besides manually 74,000 times.
Thanks,
Weenie
I am still confused on how to go about opening 74,00 csv files in a loop. An example of the files names are as follows:
Pmuck_pac.2011.12.09_13.53.04_PinkA.csv
Pmuck_pac.2011.12.09_13.53.04_PinkB.csv
Pmuck_pac.2011.12.09_13.53.04_PinkC.csv
Pmuck_pac.2011.12.09_13.53.04_BlueA.csv
Pmuck_pac.2011.12.09_13.53.04_BlueB.csv
Pmuck_pac.2011.12.09_13.53.04_BlueC.csv
Pmuck_pac.2011.12.09_13.53.04_YellowA.csv
Pmuck_pac.2011.12.09_13.53.04_YellowB.csv
Pmuck_pac.2011.12.09_13.53.04_YellowC.csv
Pmuck_pac.2011.12.09_13.53.04_RedA.csv
Pmuck_pac.2011.12.09_13.53.04_RedB.csv
Pmuck_pac.2011.12.09_13.53.04_RedC.csv
Pmuck_pac.2011.12.09_13.53.04_PurpleA.csv
Pmuck_pac.2011.12.09_13.53.04_PurpleB.csv
Pmuck_pac.2011.12.09_13.53.04_GreenA.csv
What does change is the date & military time eveything else is repeated in 15x blocks of:
Pmuck_pac...................._ColorsA,B,C.csv
Not sure what is an easy method to opening up files in 15x blocks or all PinkA then Pink B, etc thatt way the system does not crash trying to open so many files (74,000). Any help with the code would be helpful. I have code to insert my FORECAST function into the csv file then pulling data from those cells and copy to a workbook but now How do I tackle the mountain of opening csv files 74,000 times besides manually 74,000 times.
Thanks,
Weenie
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jan 1, 2012 at 07:53 AM
Jan 1, 2012 at 07:53 AM
Is there a reason to loop in that way? Depending on reason and data, one can construct a loop that will go thru files in order you want.