Help need with string generation

[#1]

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

[Ralf-Narfeldt]

If you have the name in a field called Name:

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

[qumniusomnius]

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

[Kushal_Chawda]

Try,

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

[#5 · Accepted solution]

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

[sasiparupudi1]

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

[#7]

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 .

[#8]

no worries glad to help