Can you send us a few lines of the file? I can write the code to split the file.
Paul > >From: pankaj gmail account <pankaji...@gmail.com> >To: excel-macros@googlegroups.com >Sent: Wed, October 6, 2010 1:27:29 AM >Subject: Re: $$Excel-Macros$$ pipe (|) delimited text file filtered country wise > > >Please help > >Pankaj > > >On Sun, Sep 19, 2010 at 5:25 PM, pankaj gmail account <pankaji...@gmail.com> >wrote: > > >> >>Hi to the forum, >> >>Please help me it is very urgent for me >>i have a text file which is (|) delimited in which it contains all countries >>files, what i want to do is to create country wise files in .TXT same format. >>so there will be >>singapore.txt >>india.txt >>etc. >> >>i tried but i was not able to complete what i did i imported this file in >>excel >>sheet after then was able to export but i was not able to create country >>wise multiple text files >> >> >> >>file is attached please view it and give response >>-- >>Pankaj Kumar >>-- >>---------------------------------------------------------------------------------- >> >>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 >> >><><><><><><><><><><><><><><><><><><><><><><> >>HELP US GROW !! >> >>We reach over 7000 subscribers worldwide and receive many nice notes about >>the >>learning and support from the group.Let friends and co-workers know they can >>subscribe to group at http://groups.google.com/group/excel-macros/subscribe >> > > >-- >Pankaj Kumar >-- >---------------------------------------------------------------------------------- > >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
