不知道这个是否能用函数解决

zbcpgy · 发表于 2024-5-5 15:09

我的城市你来过发表于 2024-5-5 13:01
=TEXTSPLIT(TRIM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(CONCAT(IF(LENB(MID($A2,SEQUENCE(LEN($A2) ...

这个公式偏长，可以用，能解决问题。

cnmlgb9998 · 发表于 2024-5-5 18:09

PQ方案。。。。。。。。。。。。。。。。。。。。。

做的纵向。横向能做，不想做了

zbcpgy · 发表于 2024-5-5 18:38

cnmlgb9998 发表于 2024-5-5 18:09
PQ方案。。。。。。。。。。。。。。。。。。。。。

厉害，PQ太复杂，我一头雾水

cnmlgb9998 · 发表于 2024-5-5 21:44

let
源 = Excel.CurrentWorkbook(){[Name = "表1"]}[Content],
自定义1 = Table.ReplaceValue(
源,
"",
"",
(x, y, z) =>
[
a = List.Select(Text.Split(x, "#(lf)"), each _ <> ""),
b = List.Transform(
a,
each [
c = List.Select(Text.SplitAny(_, "，,。；;"), each _ <> ""),
d = List.Combine(
List.Transform(
c,
each Splitter.SplitTextByCharacterTransition(
{"m"},
{"订"}
)(Text.Remove(_, {":", "："}))
)
),
d2 = {"长", "宽", "高"},
e = List.Transform(
d,
each
if Text.Contains(_, "尺寸") then
[
f = Text.SplitAny(
Text.Select(
_,
{"0" .. "9", "*", "."}
),
"*"
),
g = List.Accumulate(
{0 .. 2},
{},
(x, y) =>
x
& {
d2{y}
& Text.From(
f{y}
)
}
)
][g]
else
_
),
h = List.Combine(
List.Transform(e, each if _ is text then {_} else _)
),
i = List.Zip(
List.Transform(
h,
(m) =>
Splitter.SplitTextByCharacterTransition(
{"一" .. "龥"},
{"A" .. "z", "0" .. "9"}
)(m)
)
),
j = Table.FromRows({i{1}}, i{0})
][j]
)
][b],
{"列1"}
)[列1],
自定义2 = List.Combine(自定义1),
自定义3 = Table.Combine(自定义2)
in
自定义3

复制代码

mykitami · 发表于 2024-5-5 21:59

=DROP(REDUCE("",TEXTSPLIT(A2,,CHAR(10),1),LAMBDA(x,y,HSTACK(x,TEXTSPLIT(y,{"mm",",",":","；","，","成品尺寸","：","。","。","发货数","生产数","订单数","*","产品名称"," "},,1)))),,1)

mykitami · 发表于 2024-5-5 22:02

=TOROW(TEXTSPLIT(A2,{"mm",",",":","；","，","成品尺寸","：","。","。","发货数","生产数","订单数","*","产品名称"," "},CHAR(10),1))

zbcpgy · 发表于 2024-5-6 18:33

mykitami 发表于 2024-5-5 22:02
=TOROW(TEXTSPLIT(A2,{"mm",",",":","；","，","成品尺寸","：","。","。","发货数","生产数","订单数","*" ...

这个公式非常强悍

		自动登录	找回密码
密码			免费注册

[求助] 不知道这个是否能用函数解决

评分

评分

评分