topic Re: Help need with string generation in QlikView

Help need with string generation

Wed, 22 Jul 2015 10:53:18 GMT

Hi,

I have a string/name say Xavier, Saritha. I need to only the part Xavier, S. How can we achieve this in Qlikview. Someone please help me.

Thanks

Saritha Xavier

Re: Help need with string generation

Ralf-Narfeldt — Wed, 22 Jul 2015 10:55:45 GMT

If you have the name in a field called Name:

Left(Name, Index(Name, ',')+2)

Re: Help need with string generation

qumniusomnius — Wed, 22 Jul 2015 11:00:10 GMT

you can format strings with these functions: left, mid ,right and subfield

depends on what your data looks like choose the most suitable

in your case it would probably be subfield:

subfield(FieldName, ',', 1) for left of comma

subfield(FieldName, ',', 2) for left of comma

Re: Help need with string generation

Kushal_Chawda — Wed, 22 Jul 2015 11:02:08 GMT

Try,

=Mid(Name,1,Index(Name,',',1)+2)

Re: Help need with string generation

Wed, 22 Jul 2015 11:02:09 GMT

Hi Saritha,

something like the below should work for you.

Subfield(field,',',1) & ', ' & Left(Trim(Subfield(field,',',2)),1) & '.' As newfield

hope that helps

Joe

Re: Help need with string generation

sasiparupudi1 — Wed, 22 Jul 2015 11:02:27 GMT

=SubField('Xavier, Saritha',',',1)&','& mid(trim(SubField(' Xavier, Saritha',',',2)),1,1)

Re: Help need with string generation

Wed, 22 Jul 2015 11:23:56 GMT

Thanks Joe , Subfield(field,',',1) & ', ' & Left(Trim(Subfield(field,',',2)),1) & '.' As newfield gave me the solution. even if space is there after ',' the result is correct. Thank you .

Re: Help need with string generation

Wed, 22 Jul 2015 12:06:17 GMT

no worries glad to help