Notion 公式大全 正则表达式inside Formular
2021-08-03 15:05:10 1 举报AI智能生成
Notion database Formular(functions)cheat shit
作者其他创作
大纲/内容
+
concat()
1origin string2index begins at 03[optional]index end
slice()
1delimiter:stringremaining:string
join()
1string2string
re:boolean
contains()
1string2regEx
test()
re:string
format()
re:number
length()
1origin string2regEx3replacement string
replace()
replaceAll()
外框
Text Functions
toNumber()
unaryPlus()
add()
-
subtract()
*
multiply()
/
divide()
^
pow()
%
mod()
round()
ceil()
floor()
ln()
log10()
log2()
cbrt()
sqrt()
max()
min()
Euler's constant(2.718...)
exp()
abs()
1or-1or0
sign()
[number]*-1
unaryMinus()
Numeric Fuctions
!=
<=
==
>
<
>=
Comparison Operators
Arithmetic Operators
Operators
e
false
true
pi
Constants
https://www.notion.vip/formulas/
reference
1boolean2boolean
and()
or()
not()
empty()
if()
equal()
larger()
largerEq()
smaller()
smallerEq()
unequal()
Logic Functions
YY13
YYYY2013
Year
Q1...4
Qo1st...4th
Quater
M1...12
Mo1st...12th
MM01...12
MMMJan
MMMMJanuary
Month
w1...53
wo1st...53rd
ww01...53
Week of year
DDD1...365
DDDo1st...365th
DDDD001...365
Day of year
D1...31
Do1st...31st
DD01...31
Day
d0...6
ddSu
dddSun
ddddSunday
Weekday
H0...23
HH00...23
24h hour
h1...12
hh01...12
12h hour
m0...59
mm00...59
Minutes
s0...59
ss00...59
Seconds
aam
AAM
AM/PM
Z=+07:00
ZZ=+0730
Timezone offset
S0...9
SS00...99
Dciseconds
SSS000...999
Milliseconds
X1581483600
Unix timestamp
x1581483600000
Milisecond Unix timestamp
Date Formats
1date2amount3unit
dateAdd()
dateSubtract()
1later date2earlier date3unit of the returned value
dateBetween()
re:date
start()
end()
formatDate()
timestamp()
1timestamp
fromTimestamp()
year()
re:0~12
month()
re:1~31
date()
re:0~23
hour()
re:0~59
minute()
Sunday is 0Monday is 1
day()
now()
Date&Time Fuctions
.
[A-Za-z0-9]
\\w
[ \\f\\\\t\\v\\u00a0\\u1680\\u2000-\\u200a\\u2028\\u2029\\u202f\\u205f\\u3000\\ufeff]
\\s
[0-9]
\\d
backspace
[\\b]
returen
\
new line
vertical Tab
\\v
form feed
\\f
NUL character
\\0
\\cX
\\xhh
\\uhhhh
\\u{hhhh} or \\u{hhhhh}
special or not (escaped)
\\
Character classes
0 or more
x*
1 or more
x+
0 or 1
x?
{n}
eg:given a string like \"some <foo> <bar> new </bar> </foo> thing\":/<.*>/ will match \"<foo> <bar> new </bar> </foo>\"/<.*?>/ will match \"<foo>\"
non-greedy
Quantifiers
$
word boundary
eg:/\\bm/ matches the \"m\" in \"moon\"
\\b
non-word boundary
\\B
Boundary-type assertions
Lookahead
eg:/Jack(?=Sprat|Frost)/ matches \"Jack\" only if it is followed by \"Sprat\" or \"Frost\".
x(?=pattern)
Negative lookahead
x(?!pattern)
Negative lookbehind
(?<!pattern)x
(?<=pattern)x
Other assertions
Assertions
or
x|y
any one of
eg:[\\w-] is same as [A-Za-z0-9_-]
[xyz][z-c]
not
[^xyz][^a-c]
Capturing group
\ \"n\" is a positive integer
\\k<Name>
(?<Name>x)
Non-capturing group
(?:x)
(x)
Groups and ranges
https://regexper.com/
https://regexr.com/
https://developer.mozilla.org/en-US/docs/Web/JavaScript/Guide/Regular_Expressions/Cheatsheet
Regular Expression
Notion Formular
职业：sk
0 条评论
下一页
