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

replace('X', , '0') not working

gizzel123 — Thu, 18 Jun 2015 08:32:17 GMT

Hi All,

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

thanks.

alexandros17 — Thu, 18 Jun 2015 08:35:18 GMT

Try with:

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

let me know

fvelascog72 — Thu, 18 Jun 2015 08:37:04 GMT

Hi,

Try this:

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

qlikmsg4u — Thu, 18 Jun 2015 08:39:34 GMT

This should work

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

jagan — Thu, 18 Jun 2015 08:43:43 GMT

Hi,

Try like this

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

Hope it helps you.

Regards,

Jagan.

sujeetsingh — Thu, 18 Jun 2015 08:58:32 GMT

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

TRY this