遇到 Text.BeforeDelimiter 问题 [英] Having trouble with Text.BeforeDelimiter

问题描述

知道为什么会这样:= Table.AddColumn(#"Merged Columns", "Custom", each Text.BeforeDelimiter("ABCDEFG","E"))

给了我这个:

?

我的期望是这会用ABCD"填充自定义"列中的每个单元格.我已经检查并重新检查了拼写.我错过了什么?

My expectation is that this would populate each cell in the column "Custom" with "ABCD". I've checked and rechecked the spelling. What am I missing?

推荐答案

此功能最近已添加到 Power BI Desktop(2017 年 4 月更新)，甚至最近添加到 Excel 中的 Power Query.因此，您可能正在一个尚不可用的环境中使用该功能.

This function was recently added to Power BI Desktop (April 2017 update) and even more recently to Power Query in Excel. So probably you are using the function in an environment where it is not yet available.

如果我复制并粘贴您的代码，它就可以正常工作(如您所料).

If I copy and paste your code, it is working just fine (and as you expected).

这篇关于遇到 Text.BeforeDelimiter 问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！