topic Re: how to format the name in QlikView

how to format the name

Tue, 13 Aug 2013 20:08:30 GMT

This might be a easy pick, but i am having hard time using string functions.

How can i make the name from Aaron, Jacobs to Aaron Jacobs all it needs to be done is get rid of the comma between last name and first name assuming the column name is Name(field)?

Re: how to format the name

shree909 — Tue, 13 Aug 2013 20:27:07 GMT

Hi ir ur are using in the script Try this

Load

FirstName,

Lastname,

FirstName &' '&Lastname AS FullName

from ....

or you can use the replace function

Replace(Name,',',' ') As FullName

Re: how to format the name

sushil353 — Tue, 13 Aug 2013 20:34:52 GMT

try to use purgechar function:

purgechar(Name,',') as FullName

HTH

Sushil