alasql parses time from excel but I need only string

Question

I'm using alaSQL to parse data from excel. in excel, I have field named: "text" and output field is "word", here I have 3 row, abc test 11:30 third is time but I need to parse as string, now it parses directly and result is: 0.479166666666667 please, give me advice, how to parse as string?

this is my query: select text word from xlsx('path/to/excel' ,{ headers:true })

Please add the code you are using – mathiasrw Sep 30 '16 at 10:10 — mathiasrw, Sep 30 '16 at 10:10

score 0 · Answer 1 · answered Aug 25 '16 at 18:12

Where is the code/snippet for this project? It would help alot to better answer your question.

Before:

select text word from xlsx('path/to/excel' ,{ headers:true })

After:

SELECT text from xlsx('path/to/excel',{headers:true});

I would assume your trying to get the field/column "text" and get the table row "word".

score 0 · Answer 2 · edited Oct 10 '17 at 08:27

0

You need to parse the date and time first. Take a look at this link. Parse date and time form excel

edited Oct 10 '17 at 08:27

Rohman HM

2,539
3
25
40

answered Nov 17 '16 at 10:53

André Bueno

89
1
3

Link-only answers are not good, better to include parts of the solution here – Alexander Farber Nov 17 '16 at 11:17

alasql parses time from excel but I need only string

2 Answers2