模板幫助價格博客社區
聯繫我們
登入
產品
登錄 & 註冊
模板中心
集成
API 文檔
支持
幫助中心
入門教程
產品路線圖
品牌資料
隱私政策
用戶條款
聯絡方式
社區
聯絡銷售
公司
聯盟計劃
關於
AItool-PRO
© 2025 Copyright Bika.ai
twitterLinkedInmedium
call to action

推薦閱讀

  • What Are AI Sales Agents and How Do They Work?
  • How to Use AI to Supercharge Your Brand Marketing Strategy
  • What’s the difference between an AI Agent and an LLM?
  • AI Agent Development Companies: What They Do and Why Your Business Needs One
  • AI Agent Platforms for Small Businesses: Which One Fits Your Needs?
將多個文本值串聯成單個文本值。(其效果等同於 &)

【text1..】是要串聯的多個值,可以輸入文本、數字、日期參數或者引用列數據。

請用雙引號將你要串聯的文本值引起來,數字和引用列除外。
特例:如果要串聯雙引號,你需要使用反斜線(\)作為轉義字符。

Concatenate

將多個文本值串聯成單個文本值。(其效果等同於 &) 【text1..】是要串聯的多個值,可以輸入文本、數字、日期參數或者引用列數據。 請用雙引號將你要串聯的文本值引起來,數字和引用列除外。 特例:如果要串聯雙引號,你需要使用反斜線(\)作為轉義字符。

輸入函數

選擇欄位或函數

數字

/assets/icons/formula/number.svg

Sum

/assets/icons/formula/number.svg

Average

/assets/icons/formula/number.svg

Max

/assets/icons/formula/number.svg

Min

/assets/icons/formula/number.svg

Round

/assets/icons/formula/number.svg

Round Up

/assets/icons/formula/number.svg

Round Down

/assets/icons/formula/number.svg

Ceiling

/assets/icons/formula/number.svg

Floor

/assets/icons/formula/number.svg

Even

/assets/icons/formula/number.svg

Odd

/assets/icons/formula/number.svg

Int

/assets/icons/formula/number.svg

Abs

/assets/icons/formula/number.svg

Sqrt

/assets/icons/formula/number.svg

Mod

/assets/icons/formula/number.svg

Power

/assets/icons/formula/number.svg

Exp

/assets/icons/formula/number.svg

Log

/assets/icons/formula/number.svg

Value

文本

/assets/icons/formula/text.svg

Concatenate

/assets/icons/formula/text.svg

Find

/assets/icons/formula/text.svg

Search

/assets/icons/formula/text.svg

Mid

/assets/icons/formula/text.svg

Replace

/assets/icons/formula/text.svg

Substitute

/assets/icons/formula/text.svg

Len

/assets/icons/formula/text.svg

Left

/assets/icons/formula/text.svg

Right

/assets/icons/formula/text.svg

Lower

/assets/icons/formula/text.svg

Upper

/assets/icons/formula/text.svg

Rept

/assets/icons/formula/text.svg

T

/assets/icons/formula/text.svg

Trim

/assets/icons/formula/text.svg

Encode URL Component

邏輯

/assets/icons/formula/logic.svg

If

/assets/icons/formula/logic.svg

Switch

/assets/icons/formula/logic.svg

True

/assets/icons/formula/logic.svg

False

/assets/icons/formula/logic.svg

And

/assets/icons/formula/boolean.svg

Or

/assets/icons/formula/boolean.svg

Xor

/assets/icons/formula/boolean.svg

Blank

/assets/icons/formula/boolean.svg

Error

/assets/icons/formula/boolean.svg

Is Error

/assets/icons/formula/boolean.svg

Not

日期

/assets/icons/formula/date.svg

Today

敬請期待

/assets/icons/formula/date.svg

Now

敬請期待

/assets/icons/formula/date.svg

To Now

敬請期待

/assets/icons/formula/date.svg

From Now

敬請期待

/assets/icons/formula/date.svg

Date Add

/assets/icons/formula/date.svg

Datetime Diff

/assets/icons/formula/date.svg

Workday

/assets/icons/formula/number.svg

Workday Diff

/assets/icons/formula/boolean.svg

Is After

/assets/icons/formula/boolean.svg

Is Before

/assets/icons/formula/boolean.svg

Is Same

/assets/icons/formula/text.svg

Datetime Format

/assets/icons/formula/date.svg

Datetime Parse

/assets/icons/formula/text.svg

Datestr

/assets/icons/formula/text.svg

Timestr

/assets/icons/formula/number.svg

Year

/assets/icons/formula/number.svg

Month

/assets/icons/formula/number.svg

Weekday

/assets/icons/formula/number.svg

Weeknum

/assets/icons/formula/number.svg

Day

/assets/icons/formula/number.svg

Hour

/assets/icons/formula/number.svg

Minute

/assets/icons/formula/number.svg

Second

/assets/icons/formula/date.svg

Set Locale

/assets/icons/formula/date.svg

Set Timezone

/assets/icons/formula/date.svg

Created Time

/assets/icons/formula/date.svg

Last Modified Time

敬請期待

數組

/assets/icons/formula/array.svg

Array Compact

/assets/icons/formula/array.svg

Array Unique

/assets/icons/formula/array.svg

Array Join

/assets/icons/formula/array.svg

Array Flatten

/assets/icons/formula/array.svg

Count

/assets/icons/formula/array.svg

CountA

/assets/icons/formula/array.svg

CountIf

/assets/icons/formula/array.svg

CountAll

對象

/assets/icons/formula/array.svg

Record ID

CONCATENATE

將多個文本值串聯成單個文本值。(其效果等同於 &) 【text1..】是要串聯的多個值,可以輸入文本、數字、日期參數或者引用列數據。 請用雙引號將你要串聯的文本值引起來,數字和引用列除外。 特例:如果要串聯雙引號,你需要使用反斜線(\)作為轉義字符。

函數使用

CONCATENATE(text1, [text2, ...])

函數示例

CONCATENATE({姓名}, {年紀}, "歲") CONCATENATE("\"", {年紀}, "\"")