Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


Using your data, I used
Edit > "paste special"
then chose "unformatted text" from the dialog. The dialog then wanted to know what the separator was. I tried "space" and it inserted data into cells but your data has a number spaces so I got many blank cells.

I tried to replace multiple spaces with a comma, and that worked, but your data doesn't have a consistent number of separating spaces so that did not appear to be useful. I played with it, and I believe if you separate the data items with a single space, a tab, or something that Calc likes for a separator you may have some luck with "paste special".

Hope this helps.

--David Teague


On 7/23/2011 8:48 AM, George R. Kasica wrote:
Hello:

I have a currently existing Excel 2007 sheet that I can do a (In
Excel) Refresh All for \\APOLLO\e\WeatherLink\JACW3\download.txt which
is a test file in the format of:

                   Temp     Hi    Low   Out         Wind        Wind Hi
Hi   Wind   Heat          THSW                Rain  Solar Solar Hi
Solar         UV    Hi     Heat    Cool    In     In    In In     In
In Air          Soil 1   Soil    Leaf  Wind  Wind    ISS Arc.
   Date    Time     Out   Temp   Temp   Hum    Dew Speed   Dir   Run
Speed   Dir  Chill  Index    THW  Index   Bar    Rain  Rate   Rad.
Energy    Rad.    UV   Dose   UV     D-D     D-D    Temp   Hum    Dew
Heat    EMC Density     ET   Moist.  Temp 1  Wet 1  Samp   Tx   Recept
Int.
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  7/22/11   0:01   75.6   75.6   75.6    69   64.7   1.0   WNW  0.02
1.0   WNW   75.6   77.3   77.3   75.1  1009.5  0.00  0.00     0 0.00
0     0.0  0.00   0.0   0.000   0.007   79.5    46   56.9 79.3   8.46
.0722    0.000    153    69.0     15      9    1     39.1 1
  7/22/11   0:02   75.6   75.6   75.6    69   64.7   2.0   WNW  0.03
3.0   WNW   75.6   77.3   77.3   75.1  1009.5  0.00  0.00     0 0.00
0     0.0  0.00   0.0   0.000   0.007   79.5    47   57.5 79.3   8.66
.0722    0.000    153    69.0     15     20    1     87.0 1
  7/22/11   0:03   75.6   75.6   75.6    69   64.7   1.0   WNW  0.02
2.0   WNW   75.6   77.3   77.3   75.1  1009.5  0.00  0.00     0 0.00
0     0.0  0.00   0.0   0.000   0.007   79.5    47   57.5 79.3   8.66
.0722    0.000    153    69.0     15     22    1     95.7 1
  7/22/11   0:04   75.6   75.6   75.6    69   64.7   1.0   WNW  0.02
3.0   WNW   75.6   77.3   77.3   75.1  1009.5  0.00  0.00     0 0.00
0     0.0  0.00   0.0   0.000   0.007   79.5    48   58.1 79.4   8.86
.0721    0.000    153    69.0     15     21    1     91.3 1
  7/22/11   0:05   75.6   75.6   75.6    69   64.7   1.0   WNW  0.02
3.0   WNW   75.6   77.3   77.3   75.1  1009.5  0.00  0.00     0 0.00
0     0.0  0.00   0.0   0.000   0.007   79.5    48   58.1 79.4   8.86
.0721    0.000    153    69.0     15     21    1     91.3 1

and is properly formatted automatically by a Text-To Colums setup
already in the MS Excel sheet so all I need to do each day is Refresh
All and select the filename and it pulls in the data in the proper
column.

For the life of me I cannot see how to do this in Calc...and opening
the existing sheet gets the right format, but I'm at a loss of how to
get new data into it without redoing the whole text to columns every
time (not an option due to time constraints here each day when this
has to happen...data is available at 59 past the hour and needs to jut
come in to be used by 15 past the next hour.

Can anyone help with this? As of right now its the one thing keeping
me from dumping the Office 2007 suite.

 7/22/11   0:01   75.6   75.6   75.6    69   64.7   1.0   WNW  0.02
1.0   WNW   75.6   77.3   77.3   75.1  1009.5  0.00  0.00     0 0.00
0     0.0  0.00   0.0   0.000   0.007   79.5    46   56.9 79.3   8.46
.0722    0.000    153    69.0     15      9    1     39.1 1
 7/22/11   0:02   75.6   75.6   75.6    69   64.7   2.0   WNW  0.03
3.0   WNW   75.6   77.3   77.3   75.1  1009.5  0.00  0.00     0 0.00
0     0.0  0.00   0.0   0.000   0.007   79.5    47   57.5 79.3   8.66
.0722    0.000    153    69.0     15     20    1     87.0 1
 7/22/11   0:03   75.6   75.6   75.6    69   64.7   1.0   WNW  0.02
2.0   WNW   75.6   77.3   77.3   75.1  1009.5  0.00  0.00     0 0.00
0     0.0  0.00   0.0   0.000   0.007   79.5    47   57.5 79.3   8.66
.0722    0.000    153    69.0     15     22    1     95.7 1
 7/22/11   0:04   75.6   75.6   75.6    69   64.7   1.0   WNW  0.02
3.0   WNW   75.6   77.3   77.3   75.1  1009.5  0.00  0.00     0 0.00
0     0.0  0.00   0.0   0.000   0.007   79.5    48   58.1 79.4   8.86
.0721    0.000    153    69.0     15     21    1     91.3 1
 7/22/11   0:05   75.6   75.6   75.6    69   64.7   1.0   WNW  0.02
3.0   WNW   75.6   77.3   77.3   75.1  1009.5  0.00  0.00     0 0.00
0     0.0  0.00   0.0   0.000   0.007   79.5    48   58.1 79.4   8.86
.0721    0.000    153    69.0     15     21    1     91.3 1


--
nil significat nisi oscillat



--
Unsubscribe instructions: E-mail to users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.