本文介绍了如何在Google Spreadsheet公式中将字符串转换为camelcase的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
试图创建一个公式来将由空格分隔的字符串转换为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的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!