BrianWoods

Lowercase

Discussion created by BrianWoods on Sep 9, 2016
Latest reply on Sep 10, 2016 by user19752

I am trying to change the first letter in certain sentences to lower case.   However, some sentences start with opening quotes rather than letters.

 

I thought using the Case function nesting the Left function inside the Lower function would solve my problem. See below...

 

Case (

 

Left ( Sentence1; 1 ) = """;

Lower ( Left ( Sentence1; 2 );

 

Left (  Sentence1; 1) ≠ """;

Lower ( Left ( Sentence1; 1 );

 

)

 

Any help would be greatly appreciated.

Outcomes