QV If a certain text exists in chart table, display as text

[#1]

Hi,

Please assist

I have a string of text that if it contains the word XYZ, need to display as ABC in a Chart Table

Please assist

Regards

Marcus

[Anonymous]

Hi

if(namefield=XYZ,ABC)

[buzzy996]

try this,

=If(FieldName='XYZ','ABC',FieldName)

[Anonymous]

Did you mean like this,

Load

replace(yourfield,'abc','xyz')  as yourfield ,

//

[Anonymous · Accepted solution]

sorry.. it should be the other way round,

Load

replace(yourfield,'xyz','abc')  as yourfield ,

//

[#6]

Thank you very much - worked like a charm

Could I please ask you a further question, Should I wish to replace any fields that contain XY* with ABC, how would I do this?

Thanks

[Anonymous]

Like this?

Load

F1 as from,

if(len(mid(F1,index(F1,'xy')))>2,mid(F1,1,(index(F1,'xy')-1))&'abc'&mid(F1,index(F1,'xy')+3),F1) as to

;

LOAD * INLINE [

    F1

    hi xyz

    hello xy

    xyz

    xyt qweqw

];

Thanks,