Reorder text in a field

[david_pearson]

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

[dplr-rn · Accepted solution]

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

[pradosh_thakur]

try below

Capitalize(subfield(MM_CURR_SERV_OWNER,2)) & ' ' &  Capitalize(subfield(MM_CURR_SERV_OWNER,1)) as  MM_CURR_SERV_OWNER

[david_pearson]

thank you for this. it's almost there. with your example code i now get Smith, Paul Smith, Paul

any further suggestions?

[pradosh_thakur]

@david_pearson  whose code did you try? It's not clear.

-Pradosh

[david_pearson]

Capitalize(subfield(MM_CURR_SERV_OWNER,2)) & ' ' & Capitalize(subfield(MM_CURR_SERV_OWNER,1)) as MM_CURR_SERV_OWNER

[pradosh_thakur · Accepted solution]

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

[david_pearson]

works great. thanks. i tried the other users solution and this also worked. thanks for your help