topic Swap two strings separated by delimiter in QlikView

Swap two strings separated by delimiter

narband2778 — Thu, 05 Dec 2013 14:48:41 GMT

Hi guys,

I have a Field (Full Name).

All the names in that field are (first name, last name).

My requirement is to swap first and last name. For ex (John, Bell) to (Bell, John).

How to do it?

Waiting for your replays.

Thanks In Advance,

Naresh

hic — Thu, 05 Dec 2013 14:52:28 GMT

For example

Subfield(Name,',',2) & ' ' & Subfield(Name,',',1) as Name

HIC

rustyfishbones — Thu, 05 Dec 2013 14:57:38 GMT

try

SUBFIELD([Full Name],',',-1)& ' ' & SUBFIELD([Full Name],',',1) AS Name