如何在Google Spreadsheet公式中将字符串转换为camelcase [英] How to convert a string to camelcase in Google Spreadsheet formula

问题描述

试图创建一个公式来将由空格分隔的字符串转换为camelcase

解决方案

这应该起作用：

（A3，））和LOWER（MID（SPLIT（A3，））和LOWER（LEFT（SPLIT（A3， ），2,500））））

或者更确切：

= JOIN（，ArrayFormula（UPPER（LEFT（SPLIT（A3，）））&
LOWER（REGEXEXTRACT（SPLIT（A3，），。（ 。*）））））

Trying to create a formula to turn a string of words separated by spaces into camelcase

解决方案

This should work:

=JOIN("",ArrayFormula(UPPER(LEFT(SPLIT(A3," ")))&LOWER(MID(SPLIT(A3," "),2,500))))

or to be more precise:

=JOIN("",ArrayFormula(UPPER(LEFT(SPLIT(A3," ")))& LOWER(REGEXEXTRACT(SPLIT(A3," "),".(.*)"))))

这篇关于如何在Google Spreadsheet公式中将字符串转换为camelcase的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！