Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
parsing text
Hi,
I hope you may help me. Please check the attached text file. Actually its a report file with some headers information and them report is in tabular format. I want to parse each row and get the values. I think strtok won't work here. There are no tabs in between the column values they are spaces. Column values them selves contain spaces but they are single spaces. Minimum two spaces are there between column values. can you suggest some algorithm in C or any other method to get each column value. In excel I try to create a delimited file but its unsuccessful. How to do it in excel. Thanks, lee following content is in a text file. Copy in a text file Keep wordwrap off ------------------------------------------------------------------------------- DATE: 04/07/2007 TMK MTC_PROC REPORT Area: KTO WRKPCK: KTO PROCESS PNAME FEANAME CEB MCO DPNUM NM_ITM ERROR TXT_GUI ERROID _______ ___________ _____________ ___ ___ ______ __________ ________________________________________________ __________________________________________________ __________ ______ RECKKON 206 DEVICE 007 997 532533 532533 Invalid source. BREAK needed. Count: 1501-1505 Source: -98 0201 RECKKON U206 DEVICE 007 997 532533 532533 Invalid source. BREAK needed. Count: 1421,1726-1730 Source: -98 0201 RECKKON F77 CROSS CNNCT 009 997 520624 520624 Feeder feature. Count: AM992,651-900 Source: 520619 7310 RECKKON F1727 X-MIC 009 997 521184 521184 Sourced Out. Count: SA5211,1-1800 Source: 0 0206 RECKKON F115 CROSS CNNCT 009 997 522306 522306 provide feed. Count: 1400,1001-1100 Source: 522333 7310 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
parsing text
When you open a text file in Excel the Text Import Wizard should pop up and
walk you through the process. The file is not delimited and I cannot tell if it's fixed width but that is the option you'll have to try. Use the wizard to indicate where the columns fall. If that does not result in a satisfactory result you'll have to write a macro or use an external process. As for saving a delimited file you might try File, Save As, CSV. -- Jim wrote in message oups.com... | Hi, | | I hope you may help me. | | Please check the attached text file. | Actually its a report file with some headers information | and them report is in tabular format. I want to parse each row | and get the values. | | I think strtok won't work here. | | There are no tabs in between the column values they are spaces. | Column values them selves contain spaces but they are single spaces. | Minimum two spaces are there between column values. | | can you suggest some algorithm in C or any other method to get each | column value. | | | | In excel I try to create a delimited file but its unsuccessful. How to | do it in excel. | | Thanks, | | lee | | | following content is in a text file. Copy in a text file | Keep wordwrap off | ------------------------------------------------------------------------------- | | | | | DATE: 04/07/2007 | | TMK | | MTC_PROC REPORT | | Area: KTO | WRKPCK: KTO | | | PROCESS PNAME FEANAME CEB MCO DPNUM NM_ITM | ERROR | TXT_GUI ERROID | _______ ___________ _____________ ___ ___ ______ __________ | ________________________________________________ | __________________________________________________ __________ ______ | | RECKKON 206 DEVICE 007 997 532533 532533 | Invalid source. BREAK needed. Count: 1501-1505 | Source: -98 0201 | | RECKKON U206 DEVICE 007 997 532533 532533 | Invalid source. BREAK needed. Count: | 1421,1726-1730 Source: -98 0201 | | RECKKON F77 CROSS CNNCT 009 997 520624 520624 | Feeder feature. Count: AM992,651-900 | Source: 520619 7310 | | RECKKON F1727 X-MIC 009 997 521184 521184 | Sourced Out. Count: SA5211,1-1800 | Source: 0 0206 | | RECKKON F115 CROSS CNNCT 009 997 522306 522306 | provide feed. Count: | 1400,1001-1100 Source: 522333 7310 | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Parsing Number from Text | Excel Discussion (Misc queries) | |||
Parsing text | Excel Discussion (Misc queries) | |||
help parsing multiple text sets from one cell | Excel Worksheet Functions | |||
Parsing Data with Formulas (vs Text-to-Columns) | Excel Worksheet Functions | |||
Parsing text in Excel | Excel Worksheet Functions |