Text Format

[#1]

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.

[Anonymous]

Hello,

You can try subfield() function.

BR

Serhan

[Anonymous]

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

or if <467> is the Problem you can use

purgechar(yourstring,'<>1234567890')

[prma7799]

use keepchar

[#5]

Hi Rudolf,

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

[giakoum]

PurgeChar(Field, '123456789<>')

use Trim also :

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

[#7]

Selam Serhan

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

Thanks.

[prma7799]

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

[#9]

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

Murat Altay

Altay Murat

05368352161

03658652156

Like this..

[#10]

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