topic Re: How to clean a field in QlikView

How to clean a field

Anonymous — Thu, 22 Aug 2013 14:46:54 GMT

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

Re: How to clean a field

alexandros17 — Thu, 22 Aug 2013 14:57:43 GMT

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

Re: How to clean a field

Gysbert_Wassenaar — Thu, 22 Aug 2013 15:46:28 GMT

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.

Re: How to clean a field

Nagaraju_KCS — Thu, 22 Aug 2013 17:06:03 GMT

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