Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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
Hi,
you could try in this way:
Replace(Column2,'T','T0000')
'T' & Num(Keepchar(Column2,'0123456789'),'0000000')