Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi people,
The original time string showing up is in a string format. The left column showing up 'Original Time String' has 108, 236, 4456, 34523 which as the last 3,4,5 digits of the time format hhmmss which is also string. How can I get them in the desired time string of hhmmss where the blanks are filled with 0's to meet the hhmmss format.
For clear understanding, Ex. 108 means 00:01:08 which is 12:01:08 AM.
Please help.
Try =Num([Original Time Strin],'000000')
Try =Num([Original Time Strin],'000000')
Try this?
TimeChar:
LOAD *, Repeat(0, 6-Len(OrigTimeStr))&OrigTimeStr AS Len INLINE [
OrigTimeStr
108
236
4436
34523
];
Try Num function
Num(Field,'000000')
Awesome. Thank you Jerry.
The below one worked, Nagaraju. Thank you for your response.
Num([Original Time Strin],'000000')
Thank you.