Chuyển File Log Sang Excel ) (Trực Tuyến Miễn Phí) — Convertio

excel text
Share
Improve this question
Follow
asked Jan 31 “13 at 4:10

*

ChanChowChanChow
1,20866 gold badges2424 silver badges5252 bronze badges
4
Add a comment |

4 Answers 4

Active Oldest Votes
5
If it”s not too frequent task:

Copy-paste the text to Excel (will occupy one column)Data – Text to Columns (Excel 2003) Delimiters: Comma and Other: >After completing the operations, insert a column after the remaining non-splitted fragment (358920045121212<0.75) and repeat Text to Columns for this column only with Other delimiter as <.
Share
Improve this answer
Follow
answered Jan 31 “13 at 6:54

*

Jüri RuutJüri Ruut
2,3901515 silver badges1919 bronze badges
Add a comment |
2
1) Copy the data into a text file, like Notepad.

Đang xem: Chuyển file log sang excel

2) Use find and replace to replace bracket characters with a tab character.You can not directly type a tab character into the replace field, because it will just move your cursor to the next field. To get around this:Open another Notepad window and press tab, then copy the tab into the replace field of the original Notepad window. Hit replace and repeat this process with space and comma characters.

3) Save and close the notepad file.

4) Open the notepad file in Excel. (choose file, open, and don”t forget to change the file type in the open dialog from “All Excel Files” to “All Files”

5) This will open the Text Import Wizard. Hit next, next and finished, and the data should show up in separate columns

Share
Improve this answer
Follow
answered Jan 31 “13 at 4:29

*

zcotterzcotter
20711 silver badge88 bronze badges
Add a comment |
2
If you want to do it strictly in Excel, you will have to extract the individual data elements from each string using a combination of text functions, including SEARCH or FIND, LEFT, MID and RIGHT. The following formulas show one wqy to extract each element from one of the strings, which I have assumed is in A1.

=MID(A1,2,SEARCH(“,”,A1)-2) =MID(A1,SEARCH(“,”,A1)+1,SEARCH(“>”,A1)-SEARCH(“,”,A1)-1) =MID(A1,SEARCH(“>”,A1)+1,SEARCH(“>”,A1)+SEARCH(“<",MID(A1,SEARCH(">“,A1),99))-SEARCH(“>”,A1)-2) =MID(A1,SEARCH(“<",A1,2)+1,SEARCH(">“,MID(A1,SEARCH(“<",A1,2)+1,99))-1) =MID(A1,SEARCH("????-??-??",A1),10) =RIGHT(A1,8)You would enter these formulas horizontally to the right of A1, then copy them down.

Share
Improve this answer
Follow
answered Jan 31 “13 at 4:37

*

chuffchuff
5,70611 gold badge1818 silver badges2626 bronze badges
2
Add a comment |
0
There is a much simpler way – use a third party piece of software.

The one I used costs me very little for the year, but means i don”t need to mess around with trying to get it right.

Xem thêm: Top 200+ Game Offline Pc Full crack Hay Mới Nhất Cập Nhật 2020

Its the only tool i found which isn”t a monthly subscription as well.

Its a desktop based application.

https://onpage.rocks/product/server-log-tool/

Share
Improve this answer
Follow
answered Jan 26 “19 at 15:11

*

Andy HallidayAndy Halliday
1
Add a comment |

Your Answer

Thanks for contributing an answer to Stack Overflow!

Please be sure to answer the question. Provide details and share your research!

But avoid

Asking for help, clarification, or responding to other answers.Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

Xem thêm: Đăng Nhập Game Center Bằng Gmail, Google Product Forums

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Submit

Post as a guest

Name
Email Required, but never shown

Post as a guest

Name
Email

Required, but never shown

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged excel text or ask your own question.

The Overflow Blog
Featured on Meta
Linked
1
How to split string into separate cells
Related
1984
How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?
64
Import Excel spreadsheet columns into SQL Server database
91
How to import an excel file in to a MySQL database
737
Print string to text file
510
Is it possible to force Excel recognize UTF-8 CSV files automatically?
490
'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
5899
How do I find all files containing specific text on Linux?
193
How to correctly display .csv files within Excel 2013?
646
How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops
Hot Network Questions more hot questions

Question feed
Subscribe to RSS
Question feed To subscribe to this RSS feed, copy and paste this URL into your RSS reader.

Stack Overflow
Products
Company
Stack Exchange Network
site design / logo © 2021 Stack Exchange Inc; user contributions licensed under cc by-sa. rev2021.4.12.39055

Stack Overflow works best with JavaScript enabled

*

Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.

Xem thêm bài viết thuộc chuyên mục: Chuyển file

Khuyễn Mãi Hot