How to clean a field

[Anonymous]

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

[alexandros17]

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]

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.

[qv_testing]

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.....