Re: [libreoffice-users] How to import a txt file into an existing Calc sheet?

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