Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Text Format

Hello,

I have this format ="Murat Altay" <467>

How can i change this format for--> Murat Altay

I want to see in listview  this type  Murat Altay

Thanks.

1 Solution

Accepted Solutions
Partner
Partner

Re: Text Format

purgeChar([Caller ID], '1234567890<>') & ' ' & KeepChar([Caller ID], '1234567890')

adjust the characters as needed

18 Replies
Highlighted
Partner
Partner

Re: Text Format

Hello,

You can try subfield() function.

BR

Serhan

Partner
Partner

Re: Text Format

you can use left(yourstring, 11) but lenght must be fix

or if <467> is the Problem you can use

purgechar(yourstring,'<>1234567890')

prma7799
Honored Contributor III

Re: Text Format

use keepchar

Not applicable

Re: Text Format

Hi Rudolf,

Thank you for your answer. But I have "Murat Altay" <467> and  "05326841235 "



Partner
Partner

Re: Text Format

PurgeChar(Field, '123456789<>')

use Trim also :

Trim(PurgeChar(Field, '123456789<>'))

Not applicable

Re: Text Format

Selam Serhan

I didnt use subfield() function but I  will search.

Thanks.

prma7799
Honored Contributor III

Re: Text Format

=KeepChar('Murat Altay','Murat Altay" <467>05326841235 ')

Not applicable

Re: Text Format

All of them true but I need text and number form in one list view.

Murat Altay

Altay Murat

05368352161

03658652156

Like this..

Not applicable

Re: Text Format

Hi Murat,

just use Textbetween([Field],'"','"') as your first set of double quotes is the text you want

I should add Textbetween([Field],'"','"',2) would then give you the number element you want

Up to you have you combine or split at that point

hope that helps

Joe