Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
looking for some help at displaying a field in a different order. im sure it will be a combination of left and right functions but cant work it out.
i have a field called MM_CURR_SERV_OWNER which shows the owners name as SMITH, PAUL
i want an expression that shows the MM_CURR_SERV_OWNER as PAUL SMITH or even better Paul Smith.
can you help please
thanks
In you load script add another column
Capitalize(
right(MM_CURR_SERV_OWNER,len(MM_CURR_SERV_OWNER)-Index( MM_CURR_SERV_OWNER, ',' )) & ' '& left(MM_CURR_SERV_OWNER,Index( MM_CURR_SERV_OWNER, ',' )-1)
) as MM_CURR_SERV_OWNER_FORMATTED
e.g.
Capitalize(
right('SMITH, PAUL',len('SMITH, PAUL')-Index( 'SMITH, PAUL', ',' )) & ' '& left('SMITH, PAUL',Index( 'SMITH, PAUL', ',' )-1)
)
returns Paul Smith
I am sorry. My bad. Missed to specify the delimitter
Capitalize(subfield(MM_CURR_SERV_OWNER,',',2)) & ' ' & Capitalize(subfield(MM_CURR_SERV_OWNER,',',1)) as MM_CURR_SERV_OWNER
In you load script add another column
Capitalize(
right(MM_CURR_SERV_OWNER,len(MM_CURR_SERV_OWNER)-Index( MM_CURR_SERV_OWNER, ',' )) & ' '& left(MM_CURR_SERV_OWNER,Index( MM_CURR_SERV_OWNER, ',' )-1)
) as MM_CURR_SERV_OWNER_FORMATTED
e.g.
Capitalize(
right('SMITH, PAUL',len('SMITH, PAUL')-Index( 'SMITH, PAUL', ',' )) & ' '& left('SMITH, PAUL',Index( 'SMITH, PAUL', ',' )-1)
)
returns Paul Smith
try below
Capitalize(subfield(MM_CURR_SERV_OWNER,2)) & ' ' & Capitalize(subfield(MM_CURR_SERV_OWNER,1)) as MM_CURR_SERV_OWNER
thank you for this. it's almost there. with your example code i now get Smith, Paul Smith, Paul
any further suggestions?
I am sorry. My bad. Missed to specify the delimitter
Capitalize(subfield(MM_CURR_SERV_OWNER,',',2)) & ' ' & Capitalize(subfield(MM_CURR_SERV_OWNER,',',1)) as MM_CURR_SERV_OWNER