String manipulation

[Gary96]

Hi,

I need to replace the 9th and 10th character in a string with 00

1112223334 - Test
1112223300 - Result

111222333 Test
1112223300 - Result

 

[sahil_raina_91]

Hi,

I need to replace the 9th and 10th character in a string with 00

1112223334 - Test
1112223300 - Result

111222333 Test
1112223300 - Result

Left([Data Item],8)&"00"