Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to replace the 3rd char 'X' from <field>, to '0'.
thanks.
Try with:
Replace(field, 'X', '0')
let me know
Hi,
Try this:
Replace(FIELD,mid(FIELD,3,1),0)
This should work
=Replace('FIELD',mid('FIELD',3,1),0)
Hi,
Try like this
Mid(FIELDNAME, 1,2) & '0' & Mid('FIELDNAME', 4)
Hope it helps you.
Regards,
Jagan.
=left(Field,2) &'0'& right(Field,len(Field)-3)
TRY this