Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

replace " double quotes with space

Hi,

i need to replace " double quotes with space in my data in many number of fields in my application.

i can use REPLACE function, but there are so many places(columns/fields) i have to apply that.

so, is there any easy way to do that like in Application level?

please help me.

Thanks.

2 Replies
vijay_iitkgp
Valued Contributor

replace " double quotes with space

Hi You can use replace function at script level to cleanse your data.

Regards

Vijay

jason_michaelid
Honored Contributor II

replace " double quotes with space

MapSubstring() might be a little easier.

Community Browser