I am having the Special Character as '-' and i need to replace it with the word in qlik View

[Anonymous]

I am having the Special Character as '-' and i need to replace it with the 'Sample' in qlik View in script level

[suryaa30]

Replace('abccde','cc','xyz')

Returns 'abxyzde'

Qlik example   cc is replaced by xyz

Replcae('-','Word')

[sunny_talwar]

May be this

Replace(FieldName, '-', 'Sample') as FieldName

[Anonymous]

Hi ,

I am having the Field Name Ext in that i am having some value as '-' , so i need to replace it with 'No Ext'

[vishsaggi]

Did you try Sunny's Expr?

Replace 'sample' with 'No Ext'

[suryaa30]

You can use null handling if that's a null value. You can do it at script

level using null to value or by checking the length = 0.

In chart you go to presentation tab to show null as NoEXt

On Fri, 8 Sep 2017 at 1:11 AM, lakshminarayanan jaganathan <

[Anonymous]

  Current Field Value :    

Extension
-
201
202
222
200
-
-
-
-

  Expected Field Values:

Extension
No Ext
201
202
222
200
No Ext
No Ext
No Ext
No Ext

[vishsaggi]

Yes did you try Sunny's expr like

LOAD yourfieldnames,

           Replace(Extension, '-', 'No Ext') AS Extension

FROM Yoursource;

[Anonymous]

I need to change the value within the field not in new field

[Anonymous]

hi sunny,

if i want to replace a single record then what should i do?

because i tried  Replace(name,'_','r') as new and it works but it changes entire column of data.

Thank you