Idea Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Notify Moderator
Replace functions should allow for non-constant arguments
Status:
New Idea
Submitted by
patrick_digan
on
‎08-15-2024
06:37 AM
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Notify Moderator
Replace, ReplaceFirst, ReplaceChar and Regex_Replace in the cloud all have a limitation where arguments must be constants. Any attempt to use a column returns an error. This would a nice enhancement to have parity with Desktop. The below functions currently error out in cloud but work in desktop.
Replace(Column1,Column2, Column3)
Regex_Replace(Column1,Column2,Column3)
Could doesn't like that Column2 and Column3 are references to fields. It only works if you hardcode a string like "text". Desktop doesn't have this limitation.
See more ideas labeled with:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.