SOLVED
Change the data in one field based upon the first 5 letters of a different field
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
eabonacci22
5 - Atom
‎02-17-2022
02:21 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
If my Matter # begins with VWXYZ then the Location should be "Israel" instead of Great Britain. How would I write that formula?
Solved! Go to Solution.
Labels:
- Labels:
- Expression
5 REPLIES 5
21 - Polaris
‎02-17-2022
02:39 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@eabonacci22
There is a String function "StartWith", maybe we can use.
‎02-17-2022
02:46 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you so much! I am a rank beginner with this software and greatly appreciate the help! Worked like a charm.
‎02-18-2022
12:05 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It seems I still have a problem. When I use the script you provided the following happens:
What I need is the following:
How should I revise the script such that the location doesn't change except when the Matter # begins with "VWXYX"?
I appreciate the help!
22 - Nova
‎02-18-2022
12:08 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
22 - Nova
‎02-18-2022
12:10 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
![](/skins/images/18F3BF3EB54AD3C2739B5AA9B77A7F97/responsive_peak/images/icon_anonymous_message.png)