Home » Forums » Open Source Learning Center » Question and Answer

Info extracting

Submitted by michall2008 on 18 March, 2013 - 17:56

Hi all,

I'm looking for way to extract only the info i need from a given row:

This is what i have:

Paraguay;17/03/2013 @ 19:53;Binbit;Buzzcity;Pending;$0.7;Pack3;063593will2410f00257
Paraguay;17/03/2013 @ 19:33;Binbit;Buzzcity;Pending;$0.7;Text2;063bfc240c64256c
Paraguay;17/03/2013 @ 19:15;Binbit;Buzzcity;Pending;$0.7;Text2;063bfc23081a0c6d
Paraguay;17/03/2013 @ 18:04;Binbit;Buzzcity;Pending;$0.7;Text2;063bfc24f75af222
Paraguay;17/03/2013 @ 17:52;Binbit;Buzzcity;Pending;$0.7;Pack2;06357923f497133e
Paraguay;17/03/2013 @ 17:19;Binbit;Buzzcity;Pending;$0.7;Text3;063c0624ecdcebc5
Paraguay;17/03/2013 @ 17:07;Binbit;Buzzcity;Pending;$0.7;Text2;063bfc25ea0bd899
Paraguay;17/03/2013 @ 16:53;Binbit;Buzzcity;Pending;$0.7;Pack3;06359325e6df6f4a
Paraguay;17/03/2013 @ 15:17;Binbit;Buzzcity;Pending;$0.7;Text2;063bfc25d048e3dc
Paraguay;17/03/2013 @ 12:44;Binbit;Buzzcity;Pending;$0.7;Pack2;06357924ac89c7cb
Paraguay;17/03/2013 @ 11:43;Binbit;Buzzcity;Pending;$0.7;Text2;063bfc249e170855
Paraguay;17/03/2013 @ 04:26;Binbit;Buzzcity;Pending;$0.7;Pack2;0635792537b80d91
Paraguay;17/03/2013 @ 04:15;Binbit;Buzzcity;Pending;$0.7;Text2;063bfc2535454942
Paraguay;17/03/2013 @ 02:33;Binbit;Buzzcity;Pending;$0.7;Text1;063bf7251d36a455
Paraguay;17/03/2013 @ 00:31;Binbit;Buzzcity;Pending;$0.7;Pack3;06359324009c06b6

And I need only the time so it will look like this:

19:53
19:33
19:15
and so on....

Michal :)

‹ Using a Form to Populate a Table probably using Index/Lookup functions EE Solution Using a Form to Populate a Table ›
»

solution

Submitted by milind on 19 March, 2013 - 15:40.

=LEFT(A1,FIND("B",A1,1)-2)
=RIGHT(D1,5)

»

or

Submitted by AndyLitch on 19 March, 2013 - 17:40.

or even

=RIGHT(LEFT(A1,FIND("B",A1,1)-2),5)

»