Thread
:
Need Help Importing Text File Using Two or More Spaces as the Delimiter
View Single Post
#
11
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
[email protected]
Posts: n/a
Need Help Importing Text File Using Two or More Spaces as the
Jessi,
It looks like your data could be wrapping due to page constraints.
Does the program exporting from allow you change / use landscape
orientation rather than letter?
Mark
Systems Administrator
wrote:
The sample that I posted was a "simplified" version so that everyone
could get a general idea of what I'm working with. The actual file
has more columns, and the column headers with two words in them (ie.,
SAL No) are split into separate columns when I import the data using
"space" as a delimiter. I thought it would be too confusing to paste
the sample "as is," but I have done so below so you can see the actual
file.
So... I think your template idea with the headers was a good idea... I
just need to figure out 1) how to capture the date and page number
information from the original file; and 2) how to import the data into
same worksheet as my template headers. What do you think?
Thanks!
Jessi
P.S. Here is the actual file:
BENTLEY AREA
AUTHORITY
Service Work Log
Report 05/04/2006 2:45pm Page 1
Staff ID Name SAL No Date Payroll
-------Reported Hours-------- % Lines Comp Comp
Hrs Total
Direct Non Dir Prep Earned Taken
432498 BROWN 748334 05/04/2006 8:00 5:00 5:00
0:00 0:0 62.5 8 0:00 0:00
399003 JACKSON 444321 05/03/2006 8:00 4:45 4:45
0:00 0:0 59.3 5 0:00 0:00
887790 SMITH 023445 05/02/2006 8:00 2:00 0:00
2:00 0:0 25.0 5 0:00 0:00
223456 CUNNINGHAM 665433 05/03/2006 8:00 4:50 3:50
1:00 0:0 60.4 9 0:00 0:00
333456 DENNY 055432 05/03/2006 10:00 4:30 2:45
1:45 0:0 45.0 9 0:00 0:00
********** Total ********** 42.0 21.0
16.3 4.7 0.0 50.1 36
Reply With Quote