replace('X', <field>, '0') not working

[gizzel123]

Hi All,

I want to replace the 3rd char  'X'   from <field>,   to '0'.

thanks.

[alexandros17]

Try with:

Replace(field, 'X', '0')

let me know

[fvelascog72]

Hi,

Try this:

Replace(FIELD,mid(FIELD,3,1),0)

[qlikmsg4u]

This should work

=Replace('FIELD',mid('FIELD',3,1),0)

[jagan]

Hi,

Try like this

Mid(FIELDNAME, 1,2) & '0' & Mid('FIELDNAME', 4)

Hope it helps you.

Regards,

Jagan.

[sujeetsingh]

=left(Field,2) &'0'& right(Field,len(Field)-3)

TRY this