模板帮助价格博客社区
联系我们
登录
产品
登录 & 注册
模板中心
集成
API 文档
支持
帮助中心
入门教程
产品路线图
品牌资料
隐私政策
用户条款
联系方式
社区
联系销售
公司
联盟计划
关于
AItool-PRO
© 2025 Copyright Bika.ai
twitterLinkedInmedium
call to action

推荐阅读

  • What Are Dynamic AI Agents and Why They Matter for Your Business
  • What’s the difference between an AI Agent and an LLM?
  • What Is a Vertical AI Agent? Definition, Examples, and How It Works
  • Why Current AI Stock Analysis Struggles with Future Risk Forecasting
  • Top 5 AI Investing Tools for Event-Driven Market Strategies
从文本的开头提取多个字符。

【string】是要被提取字符的文本。
【howMany】是提取的字符数量。用数字表示,比如"4",代表从左到右提取4个字符。

Left

从文本的开头提取多个字符。 【string】是要被提取字符的文本。 【howMany】是提取的字符数量。用数字表示,比如"4",代表从左到右提取4个字符。

输入公式

选择字段或函数

数字

/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

LEFT

从文本的开头提取多个字符。 【string】是要被提取字符的文本。 【howMany】是提取的字符数量。用数字表示,比如"4",代表从左到右提取4个字符。

使用方法

LEFT(text, [num_chars])

示例

LEFT("Bika:支持API,随意DIY", 4) => Bika LEFT({出生年月}, 4) => 1994