Combine multiple csv files and output one single csv file sorted by date

try

Please Login or Register  to view this content.

Thank you for the quick reply.
I tried your solution on the sample csv files that i attached but I am getting only 1 record and the same is repeated again.

you said

Please Login or Register  to view this content.

What do you mean by this?

oh.. it was a communication error
if you see ABC csv file, it has two dates 20-03-2023 10:00 and 19-03-2023 10:00. In this case, I want all records of 20-03 because that is the max date and delete the other record 19-03.

For example, if it had records, the output should have first 3 records because that is the max date
20-03-2023 10:00
20-03-2023 09:50
20-03-2023 09:40
19-03-2023 10:00
19-03-2023 09:50
18-03-2023 10:00

hope i have conveyed it properly

Hi,

still unclear and as you forgot to attach the exact final expected csv text file !
Do you want to keep only the max date whatever the source file or the max date for each file ?

change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

@Marc L sorry for not attaching the final expected CSV. I am attaching in this post
@jindon I tried your last change and it worked as per my expectation but i lost 1 feature

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

If you see these lines in the initial code I posted, I use to get the stock name from the file name in the last column. This is missing. I am trying to integrate this in your code but since your approach is different, I am facing difficulty.

Can you try to answer to post #6 question ?

Originally Posted by Marc L

Hi,

still unclear and as you forgot to attach the exact final expected csv text file !
Do you want to keep only the max date whatever the source file or the max date for each file ?

max date for each file. Sorry to not have answered your query.

Please Login or Register  to view this content.

Cool.... this is exactly what I wanted. Thank you so much

I marked this post as solved but there is one problem that needs attention.
The code works just fine with the sample csv files but when I placed my actual csv files, I got error the below error

Please Login or Register  to view this content.

I understood the reason, it was happening because of the dot symbol (2000.00) in the file name. I removed the dot and it worked but in the last column, I got big name "ABC 27 JUL 2023 2000.00 PE" that is because of the underscore split whereas I just wanted "ABC"
so I played with the following line without success.

Please Login or Register  to view this content.

I dont want to remove the dot in the filename. Without changing the filename, how can I avoid the error?

Also let me know what changes I would need if I want to put the result in active worksheet instead of dumping it to a new csv file.

Thank you

It's what happens when the attachment does very not well reflect the real files, even if it's only the filename …
So you need to add a Split for the space.

Originally Posted by Marc L

It's what happens when the attachment does very not well reflect the real files, even if it's only the filename …
So you need to add a Split for the space.

Sorry about that. It wasn't done intentionally. I thought sharing small sample files would be easy to share and understand. But now I think, it is important to share the actual data.

@jindon Thanks once again. God bless !