Query Widget - Custom/Advanced Query

212
0
02-28-2019 07:45 AM
BrianCollins
Occasional Contributor

Is it possible to pass an advanced SQL query with this widget? I want to remove dashes "-" from a query of a string field. Users commonly paste the data in from another source which includes these additional characters. See example:

Pasted input: 1234 - 4567 - 6789

Value in field/cell: 123445676789

Is this possible? Can I pass a REPLACE operator or some such?

0 Kudos
0 Replies