Dear All
I have a text file file test.txt, test01.jpg and I intend to put it a workbook and automatically change into 3 coumns like this file "manual.xlsx"that I've made manually using "Text to Columns" menu
any idea to make it
Dear All
I have a text file file test.txt, test01.jpg and I intend to put it a workbook and automatically change into 3 coumns like this file "manual.xlsx"that I've made manually using "Text to Columns" menu
any idea to make it
Last edited by azbi; 09-26-2014 at 10:44 PM. Reason: comand from moderator
Nevermind
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Could you help?
I'll look at it tomorrow - I may be able to help, if no one gives a solution in the interim - Thanks for the rep!
I just read at the bottom, then I think I should give it
I just need this text when I paste inside automatically change into 3 column as a picture below
RESULT.jpg
Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff)
Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Dear FDibbins
I've re-upload it again above
I'm confused The data you uploaded in your workbook (which looks like it only contains the result, not the raw data?) does not match the .txt file or the .jpg you uploaded?
Dear FDibbins
the txt data has been delete for some data inside due to the size was too big, therefor I delete it, but the point is the result, I mean the final column like in manual.xlsx
I know you know.
OK, I can understand that
But what did the raw data look like that was used for the manual.txt? I need to see the raw data so that I can put a formula together to extract what you need
Dear FDibbins
The raw data have put, please check my first request on the top (#1) named " file test.txt"
Hi Azbi,
Try this:
Please Login or Register to view this content.
Dear xladept
How does it work?
Owh My God....you make it complicated
Oke I'll change and make it same with the raw
ok never mind. Hopefully another member can assist you further, good luck
Directions for running the routine(s) just supplied
Copy the code to the clipboard
Open your Workbook
Press ALT + F11 to open the Visual Basic Editor.
Select “Module” as directed above from the Insert menu
Type "Option Explicit" then paste the code into the white space on the right
With the cursor between Sub and End Sub press F5 (F8 to Single Step)
OR
Press ALT + Q to close the code window.
Press ALT + F8 then double click on the macro name
*When the dialog comes up choose your text file (you may need to use the dropdown)
and that should be it
Dear xladept
Its work, I appreciate, but there's another question again
When I Run, then there's a dialog box appear to choose the source file, but there's no option type file except ".txt", could you make it for all file extension?
And is it possible for your formula to running in the same workbook without make a new work book?
could it use button for running?
Dear xladept
Its work, I appreciate, but there's another question again
When I Run, then there's a dialog box appear to choose the source file, but there's no option type file except ".txt", could you make it for all file extension?
And is it possible for your formula to running in the same workbook without make a new work book?
could it use button for running?
Dear FDibbins
Do not be sulk, I need a help from a person like you, I know you know
Here's the same file that I made special for your request, please help me
This is the source ARHB345ASIN.txt, it could be .txt or .ASC
And the result must be like this RESULT1.xlsx
The routine is written for a text file, we would need a different routine for other kinds of files.
Thanks for the rep!
Dear xladept
So, could it be made?
By the way, the result in Column 2 is different, only 3 character appear, meanwhile there should be 4 characters
Hi Azbi,
It could be made but the routine with this program is designed specifically for the text file you uploaded - what would be the new requirements?
Here's a four character version:
Please Login or Register to view this content.
Dear xladept
Still error in result, column A empty, and column B and Column C are correct
But the contain of column A appeared in a new workbook, and in this workbook for Column B is wrong
The file that I use .ASC File, it couldn't put here, I don't know how?
But the content of the file same like I send you in txt, because I save it into txt in order the file could be uploaded here
You say you have a different file extension .ASC but you can't upload it here - I can't imagine what the problem is - you need to meet me halfway
Dear xladept
I meant the upload menu in this forum rejected this file, I've tried to change into ZIP or RAR, but still reject by this WEB
Dear xladept
I meant the upload menu in this forum rejected this file, I've tried to change into ZIP or RAR, but still reject by this WEB
Is there any way to upload such a file
Maybe without the filter:
Please Login or Register to view this content.
Dear xladept
There has "All File" option in open dialog, but when I click and choose one file (*.ASC File) nothings happend
Try changing this line:with the extension in capsPlease Login or Register to view this content.
Dear xladept
Its work, but the result automatically create a new workbook.
The original workbook missing first column but the contain put in the new work book
Could it be changed into one workbook...without appear a new one?
Dear xladept
I think, its correct, but could the result appear in the origin workbook without make a new workbook?
I wish that you could send me a sample - the code doesn't call for another workbook
Dear xladept
Here's the workbook that I put your formula
Book5.xlsx
And this is the file that I would make a column
ARHB345ASIN.txt
the result should be in Book5, but it make new workbook with titled same with source name
Am I wrong?
Dear xladept
Here's the workbook that I put your formula
Book5.xlsx
And this is the file that I would make a column
ARHB345ASIN.txt
the result should be in Book5, but it make new workbook with titled same with source name ARHB345ASIN.xlsx
Am I wrong?
Hi Azbi,
Thanks for the rep!
If you want to name the book something else then see the red code at the bottom - but we can't force it to write on a workbook that you created in advance.
Please Login or Register to view this content.
Dear xladept
Thanks for your answer, how about like this, make a button in this file and when I press the button will choose a source file, then the result appear in this workbook also. Is it possible?
If that's what you want to do, I don't see howwe can't force it to write on a workbook that you created in advance.
Dear xladept
I can understand, thanks a lot for your ideas. Its solve now
You're welcome and thanks for the rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks