Text file to Excel Conversion Macro

Hi,

I'm trying to Parse a txt file using VBA. I have successfully retrieved 2 columns from text file but having problems extracting other 4 columns.

I have attached the dummy text file with all the data and Excel file with sheet demonstrating the after upload output I need.

So, what I want is that the text file has multiple "61:" and "86:" fields in a single transaction which needs to retrieved in different columns as shown in Excel file attached. Also I want to replicate the results of "Sender:" and "26:" Column until it gets another "Sender:" because a transaction has only one "Sender:" and "26:" field but it has multiple "61:" and "86:" fields. So either we have to replicate the results of "Sender:" and "26:" or leave the others empty until we get another "Sender:" and "26:" field data.

Please assist and also tell me it's possible or not.

Thanks in advance.

Here is a modified macro that seems to do exactly what you want.
I also attached your workbook with the modified macro in it.

Please Login or Register  to view this content.

I hope this will help you
Regards