str.match(/(?<=\. ).+(?= \(%\))/)[0]
// или
str.replace(/^.*?\. | \(%\).*$/g, '')
// или
str.split('. ').pop().split(' (%)').shift()
user@user-workstation:/tmp/test$ docker container run --rm -v ${PWD}:/tmp -u $(id -u ${USER}):$(id -g ${USER}) ubuntu:18.04 touch /tmp/it.is.my.file
user@user-workstation:/tmp/test$ ll
итого 20
drwxrwxr-x 2 user user 4096 янв 22 13:55 ./
drwxrwxrwt 23 root root 16384 янв 22 13:55 ../
-rw-r--r-- 1 user user 0 янв 22 13:55 it.is.my.file
user@user-workstation:/tmp/test$ rm it.is.my.file
user@user-workstation:/tmp/test$ docker container run --rm -v ${PWD}:/tmp ubuntu:18.04 touch /tmp/it.is.my.file
user@user-workstation:/tmp/test$ ll
итого 20
drwxrwxr-x 2 user user 4096 янв 22 14:01 ./
drwxrwxrwt 23 root root 16384 янв 22 14:01 ../
-rw-r--r-- 1 root root 0 янв 22 14:01 it.is.my.file
user@user-workstation:/tmp/test$
=SUMIF(T2:T13;"="&DATE(2020;1;25);S2:S13)
=ARRAYFORMULA(SUMIF(DATEVALUE(T2:T13);"="&DATE(2020;1;25);S2:S13))
=SUMIFS(S2:S13;T2:T13;">="&DATE(2020;1;25);T2:T13;"<"&DATE(2020;1;26))
UPDATE ....
WHERE
`id` IN (
SELECT `id` FROM (
SELECT `id` LIMIT 5
) as `t`
)