![精通Neo4j](https://wfqqreader-1252317822.image.myqcloud.com/cover/113/47216113/b_47216113.jpg)
3.4.5 字符串函数
下面的函数都是只针对字符串表达式。如果用于处理其他值,将返回错误。有个例外就是toString(),它还接受数字值和布尔值。
字符串函数图例如图3-27所示。
![](https://epubservercos.yuewen.com/84FE89/26581284601284906/epubprivate/OEBPS/Images/Figure-P227_93354.jpg?sign=1738970424-5QqsQKtlXKxPlBOTL8ojz24XN0fCaC1w-0-1e314bcb80d0ec963caf957ef7c2f4c5)
图3-27 字符串函数图例
(1)replace():replace()返回被替换字符串替换后的字符串,它会替换所有出现过的字符串。
语法:replace(original, search, replace)
参数:
● original:原字符串。
● search:期望被替换的字符串。
● replace:用于替换的字符串。
查询:
![](https://epubservercos.yuewen.com/84FE89/26581284601284906/epubprivate/OEBPS/Images/Figure-P227_93365.jpg?sign=1738970424-RnnspBWVM2eLEJ1483y0dWsLJKs1xo6t-0-672117695b5dc9a94bf686b875e72569)
结果:
![](https://epubservercos.yuewen.com/84FE89/26581284601284906/epubprivate/OEBPS/Images/Figure-P227_102955.jpg?sign=1738970424-rXIswt87Ewe2XsUSmcL0UkJQJdReaRVa-0-0612fae9a83f256e6a9904154b91456e)
(2)substring():substring()返回原字符串的子串。它带有一个0为开始的索引值和长度作为参数。如果长度省略了,那么它返回从索引开始到结束的子字符串。
语法:substring(original, start [, length])
参数:
● original:原字符串。
● start:子串的开始位置。
● length:子串的长度。
查询:
![](https://epubservercos.yuewen.com/84FE89/26581284601284906/epubprivate/OEBPS/Images/Figure-P227_93372.jpg?sign=1738970424-o6KXcCKNkqISNk24tTljMiXJwlB5qDFl-0-481d72ca13e4336e2a02d7433cdaf866)
结果:
![](https://epubservercos.yuewen.com/84FE89/26581284601284906/epubprivate/OEBPS/Images/Figure-P228_102956.jpg?sign=1738970424-ZzgljZJVkDyehKBOPgrpznFWYFx6XTY0-0-639ad593b44ff69453d73f9f42ba1cef)
(3)left():left()返回原字符串左边指定长度的子串。
语法:left(original, length)
参数:
● original:原字符串。
● length:左边子字符串的长度。
查询:
![](https://epubservercos.yuewen.com/84FE89/26581284601284906/epubprivate/OEBPS/Images/Figure-P228_93383.jpg?sign=1738970424-yXSzmCz8jf5Owfg8prBU9nn7CH5WUkay-0-9d4434c4da97f4a20e2f396ff1245345)
结果:
![](https://epubservercos.yuewen.com/84FE89/26581284601284906/epubprivate/OEBPS/Images/Figure-P228_102957.jpg?sign=1738970424-pE9BImkf6TutLxU9h1rlgN8tlzVBgo1Q-0-cd46c094182bd8559c07b668405d0ef6)
(4)right():right()返回原字符串右边的指定长度的子字符串。
语法:right(original, length)
参数:
● original:原字符串。
● length:右边子字符串的长度。
查询:
![](https://epubservercos.yuewen.com/84FE89/26581284601284906/epubprivate/OEBPS/Images/Figure-P228_93390.jpg?sign=1738970424-BkW4ZGV9E6K3FXnoNFpOsDdfhb7R5yR6-0-cb115ede5c5770ffb9b07d584218a6be)
结果:
![](https://epubservercos.yuewen.com/84FE89/26581284601284906/epubprivate/OEBPS/Images/Figure-P228_102958.jpg?sign=1738970424-79t0ptg08swlrIN7sbwRcqXIKLx2NJMW-0-b3df8bb2d27472ee55d1c1a8d6fe96a3)
(5)ltrim():ltrim()返回原字符串移除左侧的空白字符后的字符串。
语法:ltrim(original)
参数:
● original:原字符串。
查询:
![](https://epubservercos.yuewen.com/84FE89/26581284601284906/epubprivate/OEBPS/Images/Figure-P229_93401.jpg?sign=1738970424-QauUufXaqwCnfruXx4sfTvPgTXP5NnLL-0-0ec85ad5684218eeab5749c50e4c673d)
结果:
![](https://epubservercos.yuewen.com/84FE89/26581284601284906/epubprivate/OEBPS/Images/Figure-P229_102959.jpg?sign=1738970424-k4L9CJ7SOIKtpkuUJmSLsOwGMnKZET29-0-24fe08cdd0539ff7c4b6030f680f7c29)
(6)rtrim():rtrim()返回原字符串移除右侧空白字符后的字符串。
语法:rtrim(original)
参数:
● original:原字符串。
查询:
![](https://epubservercos.yuewen.com/84FE89/26581284601284906/epubprivate/OEBPS/Images/Figure-P229_93408.jpg?sign=1738970424-k8Om6FnCBCMdINcFEorZlI0CbTAorhqp-0-4b92459817a8147c4605937aee7058a7)
结果:
![](https://epubservercos.yuewen.com/84FE89/26581284601284906/epubprivate/OEBPS/Images/Figure-P229_102960.jpg?sign=1738970424-7nwhHWXh53CCAfPAdXXAqfZghJxB0OLI-0-e5b61a1c7fd21f252f4d16fea19c8e3b)
(7)trim():trim()返回原字符串移除两侧的空白字符之后的字符串。
语法:trim(original)
参数:
● original:原字符串。
查询:
![](https://epubservercos.yuewen.com/84FE89/26581284601284906/epubprivate/OEBPS/Images/Figure-P229_93415.jpg?sign=1738970424-ogSq6ZRi55EkvYcLwClIiwf9jhtDEePE-0-57a2a40f435ce724ee4f2834642c7b2f)
结果:
![](https://epubservercos.yuewen.com/84FE89/26581284601284906/epubprivate/OEBPS/Images/Figure-P229_102173.jpg?sign=1738970424-mt74VfPjqUSAVF7VPGRjpFb6Yx0kET1U-0-e3128319dc5c383e9019a49f6f32ff94)
(8)lower():lower()以小写的形式返回原字符串。
语法:lower(original)
参数:
● original:原字符串。
查询:
![](https://epubservercos.yuewen.com/84FE89/26581284601284906/epubprivate/OEBPS/Images/Figure-P230_93426.jpg?sign=1738970424-nzEvTSL4fGWNZdBsVe6Q8OTnpQwzOtje-0-9b4c790e3818514c20dc943fcb9a98da)
结果:
![](https://epubservercos.yuewen.com/84FE89/26581284601284906/epubprivate/OEBPS/Images/Figure-P230_102961.jpg?sign=1738970424-wMF0qXSywLjG7XftE0yiyDYaZ89RzJGy-0-b807f197ca76b78608c3a9f60c96b3bb)
(9)upper():uppper()以大写的形式返回原字符串。
语法:upper(original)
参数:
● original:原字符串。
查询:
![](https://epubservercos.yuewen.com/84FE89/26581284601284906/epubprivate/OEBPS/Images/Figure-P230_93433.jpg?sign=1738970424-T44yAzn22eSdAJbEby1giufauaK7SetL-0-8fad6e3fd4fe16493754e65ebaa02c70)
结果:
![](https://epubservercos.yuewen.com/84FE89/26581284601284906/epubprivate/OEBPS/Images/Figure-P230_102962.jpg?sign=1738970424-0o2SEL8oK0aWNFf0ldJg4uB5iVPOI4C3-0-f0bf4e13a65d9e41dc453b784a5af58a)
(10)split():split()返回以指定模式分隔后的字符串序列。
语法:split(original, splitPattern)
参数:
● original:原字符串。
● splitPattern:分割字符串。
查询:
![](https://epubservercos.yuewen.com/84FE89/26581284601284906/epubprivate/OEBPS/Images/Figure-P230_93440.jpg?sign=1738970424-ISxAU9xTMylFh2crPlfxR3TQKCkTwAmL-0-68bf3dd7cb5216ef2fb2e78f868ab1cb)
结果:
![](https://epubservercos.yuewen.com/84FE89/26581284601284906/epubprivate/OEBPS/Images/Figure-P230_102185.jpg?sign=1738970424-zKDkd3mZHBRyAolTSQeFEFRIROITCvPz-0-b4dae2a45161f2ef7fbe410f6d4783d1)
(11)reverse():reverse()返回原字符串的倒序字符串。
语法:reverse(original)
参数:
● original:原字符串。
查询:
![](https://epubservercos.yuewen.com/84FE89/26581284601284906/epubprivate/OEBPS/Images/Figure-P231_93451.jpg?sign=1738970424-k79O3zvALFwiFUhUOeHWpyRvJcIzFqKH-0-fd05e011c85cd73ad307ab8b103eb21f)
结果:
![](https://epubservercos.yuewen.com/84FE89/26581284601284906/epubprivate/OEBPS/Images/Figure-P231_102964.jpg?sign=1738970424-rGh7Uc5pUzZIkXK1qwsuQabXTgoUqj0t-0-6b9cc0c40b8a8eec9828d30c333b357f)
(12)toString():toString()将实参转换为字符串。它将整型、浮点型和布尔型转换为字符串。如果实参为字符串,则按原样返回。
语法:toString(expression)
参数:
● expression:返回数值、布尔或者字符串的表达式。
查询:
![](https://epubservercos.yuewen.com/84FE89/26581284601284906/epubprivate/OEBPS/Images/Figure-P231_93458.jpg?sign=1738970424-EVmvN0tCWnJKvF2CTvQuv2RDs9nqkAgU-0-7101bb87020e606096be5b1a659039b1)
结果:
![](https://epubservercos.yuewen.com/84FE89/26581284601284906/epubprivate/OEBPS/Images/Figure-P231_102193.jpg?sign=1738970424-ECLuqYh2srp8DyGGJPHv8L6m7nP7AGFF-0-1450c29c4409b58a8f5cf10e5c26b19e)