SUBSTRINGREGEX function please... or similar
-
The SEARCHREGEX() function is very useful... but it only returns the position of the first character in the first found instance. This is useful in many cases, but often the entire substring discovered is what I'm looking for. Could we have a function which returns the entire first substring match for a RegEx? This would be supremely useful in a lot of data cleansing/matching/profiling work!!Atheon Analytics Ltd
w: www.atheonanalytics.com
e: guy.cuthbert@atheon.co.uk
t: +44 8444 145501
m: +44 7973 550528
s: guycuthbert -
2 Comments
-
REPLACEREGEX allows this.
http://www.visokio.com/kb/functions-guide#REPLACEREGEX
For example, this results in the first sequence of digits found:
REPLACEREGEX(text, `^.*?(\d+).*?$`, "$1")
This discussion has been closed.
← All Discussions Welcome!
It looks like you're new here. If you want to get involved, click one of these buttons!
Categories
- All Discussions2,595
- General680
- Blog126
- Support1,177
- Ideas527
- Demos11
- Power tips72
- 3.0 preview2
To send files privately to Visokio email support@visokio.com the files together with a brief description of the problem.