How to replace existing text in different format in certain column with some standard text
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
Shaopingfu
7 - Meteor
03-20-2023
03:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I want to remove exiting text in column "Text", and input the formatted text with below conditions-
1) for line items having Offset vendor code started with "E", the test should be - "Pay T&E" + name in column- Offset vendor description + Year (yyyy) Month (mm) per column - Posting Date
2) for line items having Offset vendor code started with non- "E", the test should be "Pay” + code in column- Offset vendor
2 REPLIES 2
Zok
8 - Asteroid
03-20-2023
03:51 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello
One way of doing this
binuacs
21 - Polaris
03-20-2023
03:59 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Shaopingfu Another approach with STartsWith function()
IIF(StartsWith([Offset vendor], 'E'), "Pay T&E " + [Offset vendor description] + DateTimeFormat([Posting Date],'%Y%m') ,'Pay ' +[Offset vendor])
![](/skins/images/33644471E927638F516C93A75ADDEE18/responsive_peak/images/icon_anonymous_message.png)