Forum Discussion

SHAKEDALROY's avatar
SHAKEDALROY
Icon for Helper I rankHelper I
5 years ago
Solved

CONVERT DATA TYPE TEXT TO TIME

HI

I have a text column in an existing table. I want to remove the seconds so that it will relate to a Time table column that is in hh:mm format (with am/pm) . I know this is likely easy, but I cannot figure out the m code in order to do this. Help will be greatly appreciated.

 
 

T

Need Help
  • Payeras_BI's avatar
    Payeras_BI
    5 years ago

    Hi SHAKEDALROY ,

     

    On your Violation time column:

    1. Replace values --> A by AM and P by PM

    2. Split the column in 3 by Number of Characters (2) with the option "Repeatedly"

    3. Combine the two first columns with a ":" as separator

    4. Combine the resulting column with the one left containing AM/PM with a space as separator

    5. In your Ribbon > Transform > Date & Time Column > Hour > Analize

     

    Regards


     

2 Replies

  • Payeras_BI's avatar
    Payeras_BI
    Icon for Solution Sage rankSolution Sage
    5 years ago

    Hi SHAKEDALROY ,

     

    On your Violation time column:

    1. Replace values --> A by AM and P by PM

    2. Split the column in 3 by Number of Characters (2) with the option "Repeatedly"

    3. Combine the two first columns with a ":" as separator

    4. Combine the resulting column with the one left containing AM/PM with a space as separator

    5. In your Ribbon > Transform > Date & Time Column > Hour > Analize

     

    Regards