- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
How to match number in parentheses?
The task is quite simple: extract number from a pair of parentheses in a string.
For example: "3" from "Abc_Def_Gh(3)_Ijk"
But I get "(3)" with formula Regex(:String_Column, "\(([0-9])\)").
So the questions is that how can I specify where the match start. Any pointer to more detailed JMP Regex document are welcome.
Thanks,
Dong
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to match number in parentheses?
You need a second argument with a replace pattern. Otherwise Regex() returns the result of the search.
Try something like this. Should retrieve integer of any length but only if inside parantheses.
my_string = "Abc_Def_Gh(12)_Ijk_45";
Num( Regex( my_string, "\((\d+)\)", "\1" ) );
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to match number in parentheses?
You need a second argument with a replace pattern. Otherwise Regex() returns the result of the search.
Try something like this. Should retrieve integer of any length but only if inside parantheses.
my_string = "Abc_Def_Gh(12)_Ijk_45";
Num( Regex( my_string, "\((\d+)\)", "\1" ) );
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to match number in parentheses?
Many thanks! I missed the optional <format>.
Regex(source, regular expression, <format>, <IGNORECASE>);
Dong