topic Re: Text Format in QlikView

Text Format

Fri, 06 Feb 2015 12:52:54 GMT

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.

Re: Text Format

Anonymous — Fri, 06 Feb 2015 12:55:36 GMT

Hello,

You can try subfield() function.

Serhan

Re: Text Format

Anonymous — Fri, 06 Feb 2015 12:56:41 GMT

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

or if <467> is the Problem you can use

purgechar(yourstring,'<>1234567890')

Re: Text Format

prma7799 — Fri, 06 Feb 2015 13:06:00 GMT

use keepchar

Re: Text Format

Fri, 06 Feb 2015 13:06:31 GMT

Hi Rudolf,

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

Re: Text Format

giakoum — Fri, 06 Feb 2015 13:07:58 GMT

PurgeChar(Field, '123456789<>')

use Trim also :

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

Re: Text Format

Fri, 06 Feb 2015 13:08:42 GMT

Selam Serhan

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

Thanks.

Re: Text Format

prma7799 — Fri, 06 Feb 2015 13:09:23 GMT

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

Re: Text Format

Fri, 06 Feb 2015 13:14:09 GMT

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

Murat Altay

Altay Murat

05368352161

03658652156

Like this..

Re: Text Format

Fri, 06 Feb 2015 13:15:27 GMT

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

Re: Text Format

Fri, 06 Feb 2015 13:25:56 GMT

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.

Re: Text Format

Fri, 06 Feb 2015 13:35:56 GMT

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

Re: Text Format

Fri, 06 Feb 2015 13:42:00 GMT

Joe

Thanks your interest,

My data details in attach.

Re: Text Format

giakoum — Fri, 06 Feb 2015 13:47:54 GMT

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

adjust the characters as needed

Re: Text Format

Fri, 06 Feb 2015 13:53:15 GMT

Thank you Ioannis

Re: Text Format

Fri, 06 Feb 2015 13:56:54 GMT

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?

Re: Text Format

Fri, 06 Feb 2015 14:16:18 GMT

JoeSimmons

Some numbers not between <>. just simple number

I need all of them number and text but not coplicated

Re: Text Format

Fri, 06 Feb 2015 14:50:12 GMT

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?

Re: Text Format

Fri, 06 Feb 2015 15:30:13 GMT

Joe,

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