Need to insert zero values in existing column

[shabarish0587]

Hi Friends,

            I need one help, i.e. i have two different tables. in table 1 column value is like this T0000451  and another table column value is like this T451. my question, is it possible to create a column from second table like this T0000451. that means i want to add zeros values in second table. i am giving sample inputs. Thanks in advance

Given Inputs:  

Column 1	Column 2
T0000451	T451
T0000452	T452
T0000442	T442
T0000453	T453
T0000531	T531
T0000532	T532
T0000533	T533

Expected Output:

Column 1	Column 2
T0000451	T0000451
T0000452	T0000452
T0000442	T0000442
T0000453	T0000453
T0000531	T0000531
T0000532	T0000532
T0000533	T0000533

[Frank_Hartmann]

in script something like this:

left(Column2,1)&'0000'&right(Column2,3) as NewField

left([Column 2],1)&'0000'&subfield([Column 2],'T',2) as NewField

hope this helps

[StarinieriG · Accepted solution]

Hi,

you could try in this way:

Replace(Column2,'T','T0000')

[barakovskikh]

'T' & Num(Keepchar(Column2,'0123456789'),'0000000')