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.

[#2]

Hi JoeSimmons,

My data included very different style

if I'll keep two field and combine these field, so, first field include number and second field include text,

How can i this? 

Thanks.

[#3]

what up more details of what your data looks like, as I'm not sure what you end result should be

[#4]

Joe

Thanks your interest,

My data details in attach.

[giakoum · Accepted solution]

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

adjust the characters as needed

[#6]

Thank you Ioannis

[#7]

How do you want the data handled? You have some ID's that have numbers within the quotes as well as numbers between <>.

Should anything in quotes be treated as the 'text' element?

[#8]

JoeSimmons

Some numbers not between <>. just simple number

I need all of them number and text but not coplicated

[#9]

I was just trying to get an understanding what you would call the correct result for entries like this.

"2129" <902126330000>

would 2129902126330000 be what you expect?

"800-BRILLANT" <800>

would BRILLIANT 800800 be what you expect?

the purge and keep char options works really well if you just have text and number or just number. Not sure about these ones though?

[#10]

Joe,

if can be 2129 and 800-BRILLANT better than me but other is enough for now