SOLVED
Compare two strings and get new word
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Ahmediqbal
7 - Meteor
‎10-11-2022
11:59 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
I want to compare the spending categories for a list of vendors for two fiscal years. If any new value is present in column 2023 after comparing it to 2022, we should extract that value from the string to a new column. Please let me know if you need further explanation. Thank you!
Solved! Go to Solution.
Labels:
- Labels:
- Expression
3 REPLIES 3
flying008
15 - Aurora
‎10-12-2022
12:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, @Ahmediqbal
It's so eay.
Formula:
Trim(Replace([Y2023], [Y2022], ""),",")
******
If is can help you get want output, please mark it as s solution and give me a like for more share.
21 - Polaris
‎10-12-2022
12:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Ahmediqbal
Can you provide a bigger dataset so we can observe the pattern?
Emmanuel_G
13 - Pulsar
‎10-12-2022
02:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
