In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!
community Alteryx IO MyAlteryx
alteryx Community
Search
This Board
  • Global Community
  • This Category
  • This Board
  • Knowledge
  • Users
 cancel
Turn on suggestions
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Name reformatting

JanaZ
7 - Meteor
‎02-15-2023 05:13 PM

Hi There

Could you please help me find the best way to reformat the name?

 

NameNew Name
Zhang JanaZhang,Jana
Zhang Sheng JanaZhang Sheng,Jana
Labels:
Reply
0 Likes
2 REPLIES 2
flying008
15 - Aurora
‎02-15-2023 06:54 PM

Hi, @JanaZ 

 

Just for you:

ReverseString(ReplaceFirst(ReverseString(Trim([Name]))," ", ","))

flying008_0-1676516046418.png

******

If it can help you , please mark it as a solution and give a like for more share.

 

 

Reply
grazitti_sapna
17 - Castor
‎02-15-2023 08:31 PM

@JanaZ , Here are 2 other ways to achive your results using regex and GetWord functions:

grazitti_sapna_0-1676521840352.png

 

Sapna Gupta
Word_Replace.yxmd
Reply
Find a local User Group
designer new user guide
Labels
Top Solution Authors
View All