Reverse Switch Text by Delimitator
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
A few of our clients send reports with last name, first name and I have used the below formula in the past and I used switch to achieve the same result but can't get it to work. What part of the syntax am I getting wrong or missing?? Attached sample data and screenshot
with Power Q:
Text.Combine(List.Reverse(Text.Split([Resident],",")), " ")
Using below and creating new column:
SWITCH([Resident],",")), " ")
Thank you in advance for the assistance. SS
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@atcodedog05 Thank you for the quick response and help. This solved the issue.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Happy to help : ) @sslattery17
Cheers and have a nice day!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @CoG
I agree with you on often forgotten part 😅 and also agree with you that its really powerful 😎
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@CoG thank you. I like the trim option.
Sometimes the data I bring in has a combination of last name, first name and a second tenant so last name, first name last name, first name. Sometimes if it is just a simple two tenant without last name first; then I can text to column by delimitator but when they are reserved this option makes it difficult. Any suggestions for two tenant reverse case?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@sslattery17 wrote:
@CoG thank you. I like the trim option.
Sometimes the data I bring in has a combination of last name, first name and a second tenant so last name, first name last name, first name. Sometimes if it is just a simple two tenant without last name first; then I can text to column by delimitator but when they are reserved this option makes it difficult. Any suggestions for two tenant reverse case?
Hi @sslattery17 ,
Can you provide sample data for this? Does tenant names have a different separator?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Can you share some sample data for all of the different cases that may exist for this more complex case, regarding how multiple tenants can be combined? This would help make sure any help is comprehensive for you. Depending on the variability, Regex Tool: Tokenize may be a better option for you compared to the Text to Column tool.
