ITsolutions
New Member
- Joined
- Sep 10, 2013
- Messages
- 1
Greetings -
I am attempting to convert a source TXT file to a destination CSV and have it properly formatted as it is in the destination CSV below. If you open the "Destination" text below as a csv, you can see the desired CSV format. I have an .EXE which accomplishes this in Windows XP x86, but does not work in Windows 7 x64. The problem is that we do not have the source macro that was used in compiling the exe. I was hoping that someone on here can help because we cannot figure out how this conversion was accomplished. This is a similar request to this post http://www.mrexcel.com/forum/excel-questions/509264-macro-convert-txt-csv-files.html but the information provided in that post does not solve our issue.
We would prefer this to work with Office 2010, but any recent Office version (2010 or 2013) will do.
I would highly appreciate some assistance on this issue. Thank you in advance.
Source:
Destination:
I am attempting to convert a source TXT file to a destination CSV and have it properly formatted as it is in the destination CSV below. If you open the "Destination" text below as a csv, you can see the desired CSV format. I have an .EXE which accomplishes this in Windows XP x86, but does not work in Windows 7 x64. The problem is that we do not have the source macro that was used in compiling the exe. I was hoping that someone on here can help because we cannot figure out how this conversion was accomplished. This is a similar request to this post http://www.mrexcel.com/forum/excel-questions/509264-macro-convert-txt-csv-files.html but the information provided in that post does not solve our issue.
We would prefer this to work with Office 2010, but any recent Office version (2010 or 2013) will do.
I would highly appreciate some assistance on this issue. Thank you in advance.
Source:
Code:
Former Attorney General of Krypton and XYZ Law Firm Announces Investigation On Behalf Of Investors In Widgets, Inc.
83 words
5 November 2008
Company1 Significant Developments
MULTI
English
Copyright 2009 Company1. All Rights Reserved.
Date Announced: 20081105
Former Attorney General of Krypton, Joe Jones, Esq. and the law firm of House One & Two, LLC announced that it has commenced an investigation into Widgets, Inc to determine whether it has violated federal securities laws by issuing false and misleading statements to its shareholders between the dates of June 16, 2008 to November 3, 2008.
Significant Development ID Number 1234567
Document MULTI00020091107e5c80233l
Law Offices of Joseph G. Evert Announces Investigation On Behalf of Shareholders of Widgets, Inc.
283 words
5 November 2008
17:30
Business Three
BWR
English
(c) 2009 Business Three. All Rights Reserved.
Sometown, Ga. - (BUSINESS WIRE) - Law Offices of Joseph G. Evert announces that it is investigating potential claims against Widgets, Inc. (“Widgets” or the “Company”) (Nasdaq: Widgets), concerning possible securities violations in relation to public statements made by the Company between August 3, 2009 and November 3, 2009. The investigation focuses on allegations that statements made by the Company during that period regarding Widgets’s business, operations, and prospects, were false and misleading.
On November 3, 2009, the Company announced that one of its largest customers, which accounts for 90 percent of Widgets’s Four IOPS SSD business and which had placed a $180 million order for the second half of 2009, would carry 2009 inventory into 2010, placing Widgets’s 2010 first quarter results at risk. On this news, shares of Widgets declined $9.01 per share, nearly 39%, to close on November 4, 2009, at $14.14 per share, on unusually heavy volume.
If you purchased Widgets common stock between August 3, 2009 and November 3, 2009, or if you have information or would like to learn more about these claims, or if you wish to discuss these matters or have any questions concerning this announcement or your rights or interests with respect to these matters, please contact Joseph G. Evert, Esquire, of Law Offices of Joseph G. Evert, 8888 Bristol Pike, Suite 114, OtherTown, Pennsylvania 01234 by telephone at (555) 555-4847, Toll Free at (555) 555-4847, or by email to BlahBlah@SomeSite.com.
Document BWR0000020091106e5b6234p2
Destination:
Code:
"Former Attorney General of Krypton and XYZ Law Firm Announces Investigation On Behalf Of Investors In Widgets Inc.",83 words,5 November 2008,,"Company1 Significant Developments",English,"Copyright 2008 Company1. All Rights Reserved. ","Date Announced: 20081105 Former Attorney General of Krypton, Joe Jones, Esq. and the law firm of House One & Two, LLC announced that it has commenced an investigation into Widgets, Inc to determine whether it has violated federal securities laws by issuing false and misleading statements to its shareholders between the dates of June 16, 2008 to November 3, 2008. Significant Development ID Number 1234567 "
"Law Offices of Joseph G. Evert Announces Investigation On Behalf of Shareholders of Widgets Inc.",283 words,5 November 2008,17:30,"Business Three",English,"(c) 2008 Business Three. All Rights Reserved. ","Sometown, Ga. - (BUSINESS WIRE) - Law Offices of Joseph G. Evert announces that it is investigating potential claims against Widgets, Inc. (“Widgets” or the “Company”) (Nasdaq: Widgets), concerning possible securities violations in relation to public statements made by the Company between August 3, 2008 and November 3, 2008. The investigation focuses on allegations that statements made by the Company during that period regarding Widgets’s business, operations, and prospects, were false and misleading. On November 3, 2008, the Company announced that one of its largest customers, which accounts for 90 percent of Widgets’s Four IOPS SSD business and which had placed a $180 million order for the second half of 2008, would carry 2008 inventory into 2010, placing Widgets’s 2010 first quarter results at risk. On this news, shares of Widgets declined $9.01 per share, nearly 39%, to close on November 4, 2008, at $14.14 per share, on unusually heavy volume. If you purchased Widgets common stock between August 3, 2008 and November 3, 2008, or if you have information or would like to learn more about these claims, or if you wish to discuss these matters or have any questions concerning this announcement or your rights or interests with respect to these matters, please contact Joseph G. Evert, Esquire, of Law Offices of Joseph G. Evert, 8888 Maple Pike, Suite 114, OtherTown, Pennsylvania 01234 by telephone at (555) 555-4847, Toll Free at (888) 555-4847, or by email to BlahBlah@SomeSite.com. "