Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to clean a field

Dear all,

how can I clean my addresses from unwanted characters ?

Into my addresses I have substrings like  "(some characters)"

Example:   MUNCHEN   (string to remove)

I would remove the "(string to remove)"  from  my addresses

Is it possible ?

Thanks in advance

3 Replies
alexandros17
Partner - Champion III
Partner - Champion III

There are a lot of string functions (search in help);

to clean unwanted characters you have to define a rule, for example clear the character after the 10th or the character after the first '-' or '/'

To apply this rule you may use MID or LEFT function, otherwise it is hard to to ...

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

You can use the purgechar function to remove specific characters, not strings, from fields. You can use the replace function to replace strings from fields (or other strings). By replacing a string with an empty string '' you effectively remove the string.


talk is cheap, supply exceeds demand
qv_testing
Specialist II
Specialist II

Hi,

You can use Purgechar function to remove specific characters.

Example:

Load * Inline

{Name

Qlik--view];

Purgechar(Name,'-')

It returns Qlikview

Hope this helps You.....