Re: $$Excel-Macros$$ Excel Delimiter Help form text file excel file

2016-07-31 Thread V4 Informatics 
   1. Open Microsoft Excel.
   2. Click Data > Import External Data > Import Data.
   3. Open the file you created in Notepad. A wizard will display.
   4. Select Delimited and click Next.
   5. Uncheck Tab and select Space.
   6. Click Next.
   7. Click Finish and OK.
   8. On the Excel toolbar, select File > Save As. A dialog box pops up.









PRASAD VDK

 A TECHNICAL RECRUITER, A FREELANCE Talent Acquisition professional


On Sat, Jul 30, 2016 at 1:46 AM, Puttu *  wrote:

> Experts... please please help me on my requirements
>
> On Fri, Jul 29, 2016 at 4:13 PM, Puttu *  wrote:
>
>> Hi Experts,
>>
>> Need a help either in macro or formula anything is still fine. Below
>> format I receive a text file, but I need to all the fields to be updated in
>> excel. Please advise is there any easy way to do this and let me know if
>> you need more info from my end
>>
>> *Sample Records Input text File in the below format*
>>
>> May 9, 2014Dalcin J V gel...@alliedinfo.net Sandra Schuler 112
>> Bruce Road 1   Smooth Rock Falls ON
>>   5195281464 8908781912 Morning at 'Work
>> .43971 TX150472 V488581 0.043 1720 9.55
>>   Self Employed  8919454877
>>
>> February 1, 2014   morrison darrenpaul.msecr...@earthlink.net  JOHN
>> SCANLON 112 Burry AveHavelock ON
>>   7808882361 6651525797 Afternoon at Home
>> Z678071 TX668289v621966 0.055  2200 1.2
>>   Self Employed  9808782973
>>
>> September 1, 2014 Reid Roland klwatli...@aol.com JOAN B
>> ROARK   112 Burry Ave  Toronto ON
>>   7099447221 6198440169 Anytime
>> QA234304MA484290  FF514882 0.055 2200 1.2
>>   Self Employed  6243510114
>>
>> July 1, 2014   morrison david monalisachic...@hotmail.com JOSEPH
>> PARKER 112 Camli P1 Orangeville
>>   ON   4034603324 6177795117 Anytime Z677848
>> TX667768 V621868 0.067  2680 9.1
>>   Self Employed  8807122072
>>
>> July 8, 2014   morrison darwinpaule...@jellsouth.net   BRIAN
>> EARLEY   112 Camli P1   Barrie   ON
>>   7809393268 8281152822 Afternoon at Home
>> Z677969 TX667768v621899 0.04   1600 2.5
>>   Self Employed  6729199981
>>
>>
>> *Output Excel File should be in the below format*
>>
>>
>>
>> *SALES DATE*
>>
>> *CUSTOMER NAME*
>>
>> *E-MAIL ADDRESS*
>>
>> *DEALER NAME*
>>
>> *CUSTOMER ADDRESS*
>>
>> *CITY*
>>
>> *STATE*
>>
>> *CUSTOMER PHONE*
>>
>> *DEALER PHONE*
>>
>> *DELIVERY TIME*
>>
>> *INVOICE NO*
>>
>> *INSURANCE POLICY NO*
>>
>> *CHESIS NO*
>>
>> *BASIC AMOUNT*
>>
>> *INSURANCE AMOUNT*
>>
>> *DISCOUNT*
>>
>> *EMPLOYER*
>>
>> *CREDIT CARD NO*
>>
>> 05/09/2014
>>
>> Dakin J V
>>
>> gel...@alliedinfo.net
>>
>> Sandra Schuler
>>
>> 112 Bruce Road 1
>>
>> Smooth Rock Falls
>>
>> ON
>>
>> 5195281464
>>
>> 8908781912
>>
>> Morning at Work
>>
>> Z243971
>>
>> TX150472
>>
>> V488581
>>
>> 0.043
>>
>> 1720
>>
>> 9.55
>>
>> Self Employed
>>
>> 8919454877
>>
>> 02/01/2014
>>
>> morrison darren
>>
>> paul.msecr...@eathlink.net
>>
>> JOHN SCANLON
>>
>> 112 Burry Ave
>>
>> Havelock
>>
>> ON
>>
>> 7808882361
>>
>> 6651525797
>>
>> Afternoon at Home
>>
>> Z678071
>>
>> TX668289
>>
>> v621966
>>
>> 0.055
>>
>> 2200
>>
>> 1.2
>>
>> Self Employed
>>
>> 9808782973
>>
>> 09/01/2014
>>
>> Reid Roland
>>
>> klwatli...@aol.com
>>
>> JOAN B ROARK
>>
>> 112 Burry Ave
>>
>> Toronto
>>
>> ON
>>
>> 7099447221
>>
>> 6198440169
>>
>> Anytime
>>
>> QA234304
>>
>> MA484290
>>
>> FF514882
>>
>> 0.055
>>
>> 2200
>>
>> 1.2
>>
>> Self Employed
>>
>> 6243510114
>>
>> 07/01/2015
>>
>> morrison david
>>
>> monalisachic...@hotmail.com
>>
>> JOSEPH PARKER
>>
>> 112 Camli Pl
>>
>> Orangeville
>>
>> ON
>>
>> 4034603324
>>
>> 6177795117
>>
>> Anytime
>>
>> Z677848
>>
>> TX667768
>>
>> V621868
>>
>> 0.067
>>
>> 2680
>>
>> 9.1
>>
>> Self Employed
>>
>> 8807122072
>>
>> 07/08/2014
>>
>> morrison darwin
>>
>> paule...@jellsouth.net
>>
>> BRIAN EARLEY
>>
>> 112 Camli Pl
>>
>> Barrie
>>
>> ON
>>
>> 7809393268
>>
>> 8281152822
>>
>> Afternoon at Home
>>
>> Z677969
>>
>> TX667768
>>
>> v621899
>>
>> 0.04
>>
>> 1600
>>
>> 2.5
>>
>> Self Employed
>>
>> 6729199981
>>
>> --
>> Putta
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5)

Re: $$Excel-Macros$$ Excel Delimiter Help form text file excel file

2016-07-31 Thread Abhishek Jain 
Please send your sample txt file as attachment.

On Sun, Jul 31, 2016 at 6:46 PM, Puttu *  wrote:

> any help please :(
>
> On Sat, Jul 30, 2016 at 10:19 PM, Puttu *  wrote:
>
>> Some one look and help on this please
>>
>> On Sat, Jul 30, 2016 at 12:16 PM, Puttu *  wrote:
>>
>>> Experts... please please help me on my requirements
>>>
>>> On Fri, Jul 29, 2016 at 4:13 PM, Puttu *  wrote:
>>>
 Hi Experts,

 Need a help either in macro or formula anything is still fine. Below
 format I receive a text file, but I need to all the fields to be updated in
 excel. Please advise is there any easy way to do this and let me know if
 you need more info from my end

 *Sample Records Input text File in the below format*

 May 9, 2014Dalcin J V gel...@alliedinfo.net Sandra Schuler 112
 Bruce Road 1   Smooth Rock Falls ON
   5195281464 8908781912 Morning at 'Work
 .43971 TX150472 V488581 0.043 1720 9.55
   Self Employed  8919454877

 February 1, 2014   morrison darrenpaul.msecr...@earthlink.net
 JOHN SCANLON 112 Burry AveHavelock ON
   7808882361 6651525797 Afternoon at Home
 Z678071 TX668289v621966 0.055  2200 1.2
   Self Employed  9808782973

 September 1, 2014 Reid Roland klwatli...@aol.com JOAN B
 ROARK   112 Burry Ave  Toronto ON
   7099447221 6198440169 Anytime
 QA234304MA484290  FF514882 0.055 2200 1.2
   Self Employed  6243510114

 July 1, 2014   morrison david monalisachic...@hotmail.com
 JOSEPH PARKER 112 Camli P1 Orangeville
   ON   4034603324 6177795117 Anytime
 Z677848 TX667768 V621868 0.067  2680 9.1
   Self Employed  8807122072

 July 8, 2014   morrison darwinpaule...@jellsouth.net
 BRIAN EARLEY   112 Camli P1   Barrie   ON
   7809393268 8281152822 Afternoon at Home
 Z677969 TX667768v621899 0.04   1600 2.5
   Self Employed  6729199981


 *Output Excel File should be in the below format*



 *SALES DATE*

 *CUSTOMER NAME*

 *E-MAIL ADDRESS*

 *DEALER NAME*

 *CUSTOMER ADDRESS*

 *CITY*

 *STATE*

 *CUSTOMER PHONE*

 *DEALER PHONE*

 *DELIVERY TIME*

 *INVOICE NO*

 *INSURANCE POLICY NO*

 *CHESIS NO*

 *BASIC AMOUNT*

 *INSURANCE AMOUNT*

 *DISCOUNT*

 *EMPLOYER*

 *CREDIT CARD NO*

 05/09/2014

 Dakin J V

 gel...@alliedinfo.net

 Sandra Schuler

 112 Bruce Road 1

 Smooth Rock Falls

 ON

 5195281464

 8908781912

 Morning at Work

 Z243971

 TX150472

 V488581

 0.043

 1720

 9.55

 Self Employed

 8919454877

 02/01/2014

 morrison darren

 paul.msecr...@eathlink.net

 JOHN SCANLON

 112 Burry Ave

 Havelock

 ON

 7808882361

 6651525797

 Afternoon at Home

 Z678071

 TX668289

 v621966

 0.055

 2200

 1.2

 Self Employed

 9808782973

 09/01/2014

 Reid Roland

 klwatli...@aol.com

 JOAN B ROARK

 112 Burry Ave

 Toronto

 ON

 7099447221

 6198440169

 Anytime

 QA234304

 MA484290

 FF514882

 0.055

 2200

 1.2

 Self Employed

 6243510114

 07/01/2015

 morrison david

 monalisachic...@hotmail.com

 JOSEPH PARKER

 112 Camli Pl

 Orangeville

 ON

 4034603324

 6177795117

 Anytime

 Z677848

 TX667768

 V621868

 0.067

 2680

 9.1

 Self Employed

 8807122072

 07/08/2014

 morrison darwin

 paule...@jellsouth.net

 BRIAN EARLEY

 112 Camli Pl

 Barrie

 ON

 7809393268

 8281152822

 Afternoon at Home

 Z677969

 TX667768

 v621899

 0.04

 1600

 2.5

 Self Employed

 6729199981

 --
 Putta

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
 It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread

Re: $$Excel-Macros$$ Excel Delimiter Help form text file excel file

2016-07-31 Thread Puttu * 
any help please :(

On Sat, Jul 30, 2016 at 10:19 PM, Puttu *  wrote:

> Some one look and help on this please
>
> On Sat, Jul 30, 2016 at 12:16 PM, Puttu *  wrote:
>
>> Experts... please please help me on my requirements
>>
>> On Fri, Jul 29, 2016 at 4:13 PM, Puttu *  wrote:
>>
>>> Hi Experts,
>>>
>>> Need a help either in macro or formula anything is still fine. Below
>>> format I receive a text file, but I need to all the fields to be updated in
>>> excel. Please advise is there any easy way to do this and let me know if
>>> you need more info from my end
>>>
>>> *Sample Records Input text File in the below format*
>>>
>>> May 9, 2014Dalcin J V gel...@alliedinfo.net Sandra Schuler 112
>>> Bruce Road 1   Smooth Rock Falls ON
>>>   5195281464 8908781912 Morning at 'Work
>>> .43971 TX150472 V488581 0.043 1720 9.55
>>>   Self Employed  8919454877
>>>
>>> February 1, 2014   morrison darrenpaul.msecr...@earthlink.net  JOHN
>>> SCANLON 112 Burry AveHavelock ON
>>>   7808882361 6651525797 Afternoon at Home
>>> Z678071 TX668289v621966 0.055  2200 1.2
>>>   Self Employed  9808782973
>>>
>>> September 1, 2014 Reid Roland klwatli...@aol.com JOAN B
>>> ROARK   112 Burry Ave  Toronto ON
>>>   7099447221 6198440169 Anytime
>>> QA234304MA484290  FF514882 0.055 2200 1.2
>>>   Self Employed  6243510114
>>>
>>> July 1, 2014   morrison david monalisachic...@hotmail.com
>>> JOSEPH PARKER 112 Camli P1 Orangeville
>>>   ON   4034603324 6177795117 Anytime Z677848
>>> TX667768 V621868 0.067  2680 9.1
>>>   Self Employed  8807122072
>>>
>>> July 8, 2014   morrison darwinpaule...@jellsouth.net
>>> BRIAN EARLEY   112 Camli P1   Barrie   ON
>>>   7809393268 8281152822 Afternoon at Home
>>> Z677969 TX667768v621899 0.04   1600 2.5
>>>   Self Employed  6729199981
>>>
>>>
>>> *Output Excel File should be in the below format*
>>>
>>>
>>>
>>> *SALES DATE*
>>>
>>> *CUSTOMER NAME*
>>>
>>> *E-MAIL ADDRESS*
>>>
>>> *DEALER NAME*
>>>
>>> *CUSTOMER ADDRESS*
>>>
>>> *CITY*
>>>
>>> *STATE*
>>>
>>> *CUSTOMER PHONE*
>>>
>>> *DEALER PHONE*
>>>
>>> *DELIVERY TIME*
>>>
>>> *INVOICE NO*
>>>
>>> *INSURANCE POLICY NO*
>>>
>>> *CHESIS NO*
>>>
>>> *BASIC AMOUNT*
>>>
>>> *INSURANCE AMOUNT*
>>>
>>> *DISCOUNT*
>>>
>>> *EMPLOYER*
>>>
>>> *CREDIT CARD NO*
>>>
>>> 05/09/2014
>>>
>>> Dakin J V
>>>
>>> gel...@alliedinfo.net
>>>
>>> Sandra Schuler
>>>
>>> 112 Bruce Road 1
>>>
>>> Smooth Rock Falls
>>>
>>> ON
>>>
>>> 5195281464
>>>
>>> 8908781912
>>>
>>> Morning at Work
>>>
>>> Z243971
>>>
>>> TX150472
>>>
>>> V488581
>>>
>>> 0.043
>>>
>>> 1720
>>>
>>> 9.55
>>>
>>> Self Employed
>>>
>>> 8919454877
>>>
>>> 02/01/2014
>>>
>>> morrison darren
>>>
>>> paul.msecr...@eathlink.net
>>>
>>> JOHN SCANLON
>>>
>>> 112 Burry Ave
>>>
>>> Havelock
>>>
>>> ON
>>>
>>> 7808882361
>>>
>>> 6651525797
>>>
>>> Afternoon at Home
>>>
>>> Z678071
>>>
>>> TX668289
>>>
>>> v621966
>>>
>>> 0.055
>>>
>>> 2200
>>>
>>> 1.2
>>>
>>> Self Employed
>>>
>>> 9808782973
>>>
>>> 09/01/2014
>>>
>>> Reid Roland
>>>
>>> klwatli...@aol.com
>>>
>>> JOAN B ROARK
>>>
>>> 112 Burry Ave
>>>
>>> Toronto
>>>
>>> ON
>>>
>>> 7099447221
>>>
>>> 6198440169
>>>
>>> Anytime
>>>
>>> QA234304
>>>
>>> MA484290
>>>
>>> FF514882
>>>
>>> 0.055
>>>
>>> 2200
>>>
>>> 1.2
>>>
>>> Self Employed
>>>
>>> 6243510114
>>>
>>> 07/01/2015
>>>
>>> morrison david
>>>
>>> monalisachic...@hotmail.com
>>>
>>> JOSEPH PARKER
>>>
>>> 112 Camli Pl
>>>
>>> Orangeville
>>>
>>> ON
>>>
>>> 4034603324
>>>
>>> 6177795117
>>>
>>> Anytime
>>>
>>> Z677848
>>>
>>> TX667768
>>>
>>> V621868
>>>
>>> 0.067
>>>
>>> 2680
>>>
>>> 9.1
>>>
>>> Self Employed
>>>
>>> 8807122072
>>>
>>> 07/08/2014
>>>
>>> morrison darwin
>>>
>>> paule...@jellsouth.net
>>>
>>> BRIAN EARLEY
>>>
>>> 112 Camli Pl
>>>
>>> Barrie
>>>
>>> ON
>>>
>>> 7809393268
>>>
>>> 8281152822
>>>
>>> Afternoon at Home
>>>
>>> Z677969
>>>
>>> TX667768
>>>
>>> v621899
>>>
>>> 0.04
>>>
>>> 1600
>>>
>>> 2.5
>>>
>>> Self Employed
>>>
>>> 6729199981
>>>
>>> --
>>> Putta
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not