Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
what up more details of what your data looks like, as I'm not sure what you end result should be
Joe
Thanks your interest,
My data details in attach.
purgeChar([Caller ID], '1234567890<>') & ' ' & KeepChar([Caller ID], '1234567890')
adjust the characters as needed
Thank you Ioannis
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?
Some numbers not between <>. just simple number
I need all of them number and text but not coplicated
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?
Joe,
if can be 2129 and 800-BRILLANT better than me but other is enough for now