Ask Your Question

Please find me easy way convert date string into data [closed]

asked 2014-03-05 05:00:32 +0200

jiero gravatar image

updated 2014-03-06 05:08:18 +0200

I need an easy way to convert csv-like or web string into calc data for chart creation.

If this do not exist yet, make report as a bug.

Thanks, ROSt52. I have to specify my needs.

I have no access to an ebay store and grabbed info from their online sales history like following link:

I grabbed all these private listing -- buyers' identities protected AU $7.97 1 06-Mar-14 14:36:38 AEDST and needed quantity, date and time as elements to analyze sales. Then I shall create a chart for as a proof that this sells well and more budget is needed. Its ok to say about relevant&inrelevant information here. ^.^

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-20 08:11:04.554697

5 Answers

Sort by » oldest newest most voted

answered 2014-03-06 11:20:23 +0200

m.a.riosv gravatar image

Hi @jiero, selecting the column type to D-M-Y for the column of dates, in the import windows, works for me. (I did it pasting as unformatted text, copying directly from web page)

image description

edit flag offensive delete link more


Thank you, this reminds me what i used to do with csv generated by ebay, why I forgot it? Maybe because this isn't my data, I don't have access to csv, which lead to my attempt doing the same but ingoring import function. Anyway, I shall try import.

jiero gravatar imagejiero ( 2014-03-07 01:47:20 +0200 )edit

answered 2014-03-05 17:19:09 +0200

kumiponi gravatar image

You can use the functions DATEVALUE and TIMEVALUE. DATEVALUE ignores time information and TIMEVALUE ignores date information, so you may have to add them together to get a specific point in time.

For example: =DATEVALUE("2014-05-03")

Normally, if you paste in a time or date string that Calc understands, it is automatically converted into a number and formatted as a time or date. The above mentioned functions don't cause this automatic formatting so you may want to select the appropriate number format for the cell.

The underlying format for times and dates is a floating-point number. The integer part is the date and the fractional part is the time. If you want to convert such a number into a string in Calc, use the function TEXT,

For example: =TEXT(A1; "YYYY-MM-DD")

edit flag offensive delete link more

answered 2014-03-06 13:54:48 +0200

Tinkerer gravatar image

updated 2014-03-06 19:01:43 +0200

All you need to do is highlight the area and then Format > Clear Direct Formatting.


edit flag offensive delete link more

answered 2014-03-19 10:35:11 +0200

jiero gravatar image

Find myself the way, work like import but more flexible - select column and proceed "Menu Entry Data -> Text to Columns... " and do same as in import window

edit flag offensive delete link more

answered 2014-03-05 11:15:42 +0200

ROSt52 gravatar image

@jiero - What kind of data do you have and what kind of data do you need and what kind of charts do you need?

edit flag offensive delete link more



Please post only answers as answers. If you want to ask something from the asker, do so in comments. This way we know which questions have been answered. :)

kumiponi gravatar imagekumiponi ( 2014-03-05 17:21:48 +0200 )edit

Question Tools



Asked: 2014-03-05 05:00:32 +0200

Seen: 13,396 times

Last updated: Mar 19 '14