|
|
10-30-2018, 06:25 AM
|
#16
|
what an easy game.
Join Date: Dec 2002
Posts: 43,096
|
is this what you want?
__________________
Peace on earth, good will to all
GOD BLESS AMERICA
" I pass with relief from the tossing sea of cause and theory to the firm ground of result and fact"
Winston Churchill
|
|
|
10-30-2018, 04:12 PM
|
#17
|
The Voice of Reason!
Join Date: Mar 2001
Location: Canandaigua, New york
Posts: 112,858
|
Quote:
Originally Posted by formula_2002
is this what you want?
|
Yes. I do not need the column with the numbers, just the other one, justified to the left,
__________________
Who does the Racing Form Detective like in this one?
|
|
|
10-30-2018, 04:46 PM
|
#18
|
@TimeformUSfigs
Join Date: Jan 2002
Location: Moore, OK
Posts: 46,828
|
Did my suggestion not work? If not the white space is something different than spaces. Email it to me and I'll figure it out pretty quick I hope.
|
|
|
10-30-2018, 05:25 PM
|
#19
|
The Voice of Reason!
Join Date: Mar 2001
Location: Canandaigua, New york
Posts: 112,858
|
Thanks, CJ.
I found a quick way to work around - sort the column then use text to columns on the segments with the same number of spaces and it works quick.
I will try your suggestion tonight.
I have a lot more files to fix up.
__________________
Who does the Racing Form Detective like in this one?
|
|
|
10-30-2018, 05:36 PM
|
#20
|
The Voice of Reason!
Join Date: Mar 2001
Location: Canandaigua, New york
Posts: 112,858
|
Yes! It worked.
Did a couple of files and they all came out good
Thank You!!!!!
__________________
Who does the Racing Form Detective like in this one?
|
|
|
10-30-2018, 06:28 PM
|
#21
|
what an easy game.
Join Date: Dec 2002
Posts: 43,096
|
Quote:
Originally Posted by formula_2002
is this what you want?
|
attained the results this way
DATA
HIGHLIGHT COLUMN
TEXT TO COLUMNS
DELIMITED
SPACE
FINISH
__________________
Peace on earth, good will to all
GOD BLESS AMERICA
" I pass with relief from the tossing sea of cause and theory to the firm ground of result and fact"
Winston Churchill
|
|
|
10-30-2018, 08:23 PM
|
#22
|
The Voice of Reason!
Join Date: Mar 2001
Location: Canandaigua, New york
Posts: 112,858
|
I tried that p it separates the data as well, ie, instead getting
[Md Sp Wt], I get [ md ][ sp ][ wt ] in 3 columns.
__________________
Who does the Racing Form Detective like in this one?
|
|
|
10-30-2018, 11:47 PM
|
#23
|
@TimeformUSfigs
Join Date: Jan 2002
Location: Moore, OK
Posts: 46,828
|
Quote:
Originally Posted by Tom
Yes! It worked.
Did a couple of files and they all came out good
Thank You!!!!!
|
Awesome!
|
|
|
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|