Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
giakoum
Partner - Master II
Partner - Master II

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

adjust the characters as needed

View solution in original post

18 Replies
darkhorse
Partner - Specialist
Partner - Specialist

Hello,

You can try subfield() function.

BR

Serhan

Anonymous
Not applicable
Author

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

or if <467> is the Problem you can use

purgechar(yourstring,'<>1234567890')

prma7799
Master III
Master III

use keepchar

Not applicable
Author

Hi Rudolf,

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



giakoum
Partner - Master II
Partner - Master II

PurgeChar(Field, '123456789<>')

use Trim also :

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

Not applicable
Author

Selam Serhan

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

Thanks.

prma7799
Master III
Master III

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

Not applicable
Author

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
Author

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