Fill required empty spaces before a string with 0

[haneeshmarella]

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.

[jwjackso · Accepted solution]

Try =Num([Original Time Strin],'000000')

[vishsaggi]

Try this?

TimeChar:

LOAD *, Repeat(0, 6-Len(OrigTimeStr))&OrigTimeStr AS Len INLINE [

OrigTimeStr

108

236

4436

34523

];

[shiveshsingh]

Try Num function

Num(Field,'000000')

[haneeshmarella]

Awesome. Thank you Jerry.

[haneeshmarella]

The below  one worked, Nagaraju. Thank you for your response.

Num([Original Time Strin],'000000')

[haneeshmarella]

Thank you.