4.80 regexlen - Match Length of Character String

Format 1: regexlen( $str$ ,regular expression)

Format 2: regexlenw( $str$ ,regular expression)

Returns the length of substring where the defined regular expression matches the string $str$ . The function returns 0 if no match is found, in other words, 0 character match.

Use regexlenw function if $str$ or regular expression contain multibyte characters.

Examples

Example 1: Basic Example

Find out the length of the longest substring that matches with the regular expression c.*a. Since the same input data is used for matching substring in the regexstr function, it is easier to compare the results.

$ more dat1.csv
id,str
1,xcbbbayy
2,xxcbaay
3,
4,bacabbca
$ mcal c='regexlen($s{str},"c.*a")' a=rsl i=dat1.csv o=rsl1.csv
#END# kgcal a=rsl c=regexlen($s{str},"c.*a") i=dat1.csv o=rsl1.csv
$ more rsl1.csv
id,str,rsl
1,xcbbbayy,5
2,xxcbaay,4
3,,0
4,bacabbca,6

Example 2: Multibyte characters

Find out the length of the longest substring that matches "い.*あ". However, since regexlen function do not support multibyte character, it returns the number of bytes instead of number of characters.

$ more dat2.csv
id,str
1,漢漢あbbbいyy
2,漢あbいいy
3,
4,bあいあbbいあ
$ mcal c='regexlen($s{str},"あ.*い")' a=rsl i=dat2.csv o=rsl2.csv
#END# kgcal a=rsl c=regexlen($s{str},"あ.*い") i=dat2.csv o=rsl2.csv
$ more rsl2.csv
id,str,rsl
1,漢漢あbbbいyy,9
2,漢あbいいy,10
3,,0
4,bあいあbbいあ,14

Example 3: Multibyte characters 2

Find out the length of the longest substring that matches "い.*あ". The regexlenw function is able to process multibyte characters to count the number of characters.

$ mcal c='regexlenw($s{str},"あ.*い")' a=rsl i=dat2.csv o=rsl3.csv
#END# kgcal a=rsl c=regexlenw($s{str},"あ.*い") i=dat2.csv o=rsl3.csv
$ more rsl3.csv
id,str,rsl
1,漢漢あbbbいyy,9
2,漢あbいいy,10
3,,0
4,bあいあbbいあ,14