if you want to work with csv files closed, please open the csv file with Notepad, copy and paste the contents here. regards r
2010/10/21 CAN <cdelano...@gmail.com> > I have a .CSV file see sample below which I need macro to convert > to .txt file in an specific format. > > Orginal file will be like this. > > PropertyID Account# Date Time Net Funded > 1212178 2 10/10/2010 11:02 481 > 1212CAS 311 10/10/2010 20:23 75 > 1212CAS 312 10/10/2010 8:30 158.43 > 1212CCP 5951B4 10/10/2010 7:51 209.94 > 1212CCP 5951B4 10/10/2010 8:30 43.7 > 1212CWG 401 10/10/2010 20:45 748.72 > 1212EWP 1152535L 10/10/2010 12:16 67.22 > 1212EWP 1331716C 10/10/2010 16:48 67.22 > 1212EWP 1332412C 10/10/2010 9:48 69 > 1212EWP 1332812C 10/10/2010 11:08 84.25 > 1212EWP 1352215P 10/10/2010 19:36 134.44 > 1212GWC 306 10/10/2010 9:15 275 > 1212GWC 604 10/10/2010 8:34 265.16 > 1212POR 107 10/10/2010 9:14 666 > 1212SSN 205 10/10/2010 18:21 124.15 > 1212SSN 205 10/10/2010 9:00 249.07 > 1212VSM 103 10/10/2010 9:57 185 > 1212VSM NC 10/10/2010 10:14 393 > 1212LP3 1490023 10/10/2010 15:57 50 > 1212LP3 1503023 10/10/2010 12:57 162.61 > > For fields in the order listed above > PropertyID, Account#, Date Time ,Net Funded > > Notice that third field has date and time combined in the same cell. > (sorry but that's how it is generated). For the output file I only > need the date. > > The outfile needs to be in .txt as follows > > 1212178 0000000000002101020echeck 00048100 > 1212CAS 0000000000311101020echeck 00007500 > 1212CAS 0000000000312101020echeck 00158643 > 1212CCP 00000005951B4101020echeck 00020994 > 1212CCP 00000005951B4101020echeck 00004370 > 1212CWG 0000000000401101020echeck 00074872 > 1212EWP 000001152535L101020echeck 00006722 > 1212EWP 000001331716C101020echeck 00006722 > 1212EWP 000001332412C101020echeck 00006900 > 1212EWP 000001332812C101020echeck 00008425 > 1212EWP 000001352215P101020echeck 00013444 > 1212GWC 0000000000306101020echeck 00027500 > 1212GWC 0000000000604101020echeck 00026516 > 1212POR 0000000000107101020echeck 00066600 > 1212SSN 0000000000205101020echeck 00012415 > 1212SSN 0000000000205101020echeck 00024907 > 1212VSM 0000000000103101020echeck 00018500 > 1212VSM 00000000000NC101020echeck 00039300 > 1212LP3 0000001490023101020echeck 00005000 > 1212LP3 0000001503023101020echeck 00016261 > > The format is as follows: > > Property ID follow by 6 blank spaces > Beginning in location 13 it will have the Account #. Field must is > alphanumeric with a total of 13 digits. (zero filled to the left ) > > After Account #, goes the date in format YYMMDD (notice that no spaces > will be required between field 2 (Account #) and field 3 (Date). > > After Date the words "echeck" (standard for all records). > > After the word echeck there are 4 blank spaces. > > The last field after the 4 blank spaces is Net Funded (numeric, 8 > digits, no decimals ) > > I would really, really be greatful and super happy to anyone that can > do this macro as explained. > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
