August 2022
Beginner to intermediate
463 pages
9h 22m
Chinese
Content preview from Tableau Prep即学即用
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
｜
79
处理字符串数据
findnth()
查找字符串中指定字符或子串的第
n
个实例（即第
n
次出现）的位置。当你不
想查找一个字符的第一个实例的位置时，这个函数特别有用，因为这种情况下
find()
不足以满足你的要求。
len()
返回字符串中的字符数。这个函数可以帮助你找到前导空格或尾部空格，并执
行其他错误检查。
replace()
在字符串数据字段中搜索指定的字符或一组连续字符，并用指定的不同字符或
字符集替换。如果输入两个连续的引号作为替换值，该功能也可以将现有的字
符或字符集替换为空。
9.4
使用字符串数据的分组和替换选项
在
Prep Builder
中，分组功能超越了
Tableau
的
Desktop
版本，其可以帮助你使用比
Desktop
的手动选择方法更快的方式清理混乱的数据集。
Prep Builder
为处理字符串
提供了三种可供选择的分组和替换选项（见图
9-4
）：
•
发音（
Pronunciation
），根据音节放在一起时的发音来分组。
•
常见字符（
Common Characters
），将具有相似字母的字符串分组。
•
拼 写（
Spelling
），将类似于缺少字母或与正确拼写不同的单词组合在一起进行分组。
图
9
-
4
：Prep Builder 中可用的分组和替换选项
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.