Re: [libreoffice-users] Re: How to do this in Calc

At 18:16 07/02/2015 -0700, Jerry Van Brimmer wrote:
> Yes, I believe the data is text, since it is in a .csv file.

The CSV file will contain just text, of course - but that could be 
interpreted as numbers, dates, times or whatever when opened in Calc. 
So that's no guarantee.

> Column A is precisely like this:
>
>    2015-01-22 00:00:00to 2015-01-22 01:00:00  2015-01-22 01:00:00to 
> 2015-01-22 02:00:00 ...

I'm hoping this isn't all in one cell! And do you now mean that each 
value is preceded by two spaces? That will throw out the suggested 
solution, of course.

> > If you data is regular, it might be easier to construct the values directly.
>
> You lost me here.

This suggestion might have been helpful if you were constructing the 
data yourself - but probably not if you are importing data as you now clarify.

At 17:28 07/02/2015 -0800, Jerry Van Brimmer wrote:
> On Sat, Feb 7, 2015 at 4:43 PM, Brian Barker wrote:
> > Try:
> > =MID(A1;12;5)&" - "&MID(A1;34;5)
>
> When I tried that I get in column B:
> e lnf -

In that case, the five characters picked up at position 12 must be 
ee-space-ell-en-eff and there must be nothing at position 34: that's 
probably off the end of whatever is there. Are you sure that A1 
contains your first data and not some sort of heading? Have you 
transcribed that wrongly and the lower case ell is actually a capital 
I? Does A1 says something like "Hourly Usage Information"? That would 
produce the effect you describe. You won't be able to harvest any 
times out of that heading! You will need to make intelligent 
adjustments to the formula to fit your actual row numbers.

I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscribe@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