本文介绍了如何在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的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

10-16 07:40