Hello Everyone,

Is there a function that allows me to capitalize the first letter of each element within a column? I'll give you an example: inside a column I have:

computer
digital platform
Product lines

I would:

Computer
Digital Platform
Product Lines

Something that automates the initials of each word with a major letter if not present. I need it for the purposes of Lookup because is case-sensitive.

Thank You



#ApptioforAll

CapFirstLetter() should work for you.
Original Message:
Sent: 03-04-2022 06:08
From: Alessandro Citrigno
Subject: Capital Letter Function

Hello Everyone,

Is there a function that allows me to capitalize the first letter of each element within a column? I'll give you an example: inside a column I have:

computer
digital platform
Product lines

I would:

Computer
Digital Platform
Product Lines

Something that automates the initials of each word with a major letter if not present. I need it for the purposes of Lookup because is case-sensitive.

Thank You



#ApptioforAll

I wasn't aware of the CapFirstLetter() function 😮😮😮😮. Thanks, @James Funk & @Jenny Franklin!​​

------------------------------
Regards, Guillermo
------------------------------

Original Message:
Sent: 03-04-2022 08:23
From: James Funk
Subject: Capital Letter Function

CapFirstLetter() should work for you.
Original Message:
Sent: 03-04-2022 06:08
From: Alessandro Citrigno
Subject: Capital Letter Function

Hello Everyone,

Is there a function that allows me to capitalize the first letter of each element within a column? I'll give you an example: inside a column I have:

computer
digital platform
Product lines

I would:

Computer
Digital Platform
Product Lines

Something that automates the initials of each word with a major letter if not present. I need it for the purposes of Lookup because is case-sensitive.

Thank You

#ApptioforAll

James beat me to it 😋

https://help.apptio.com/en-us/studio/formulas-and-functions/functions/capfirstletter.htm?Highlight=capitalize%20first%20letter

Original Message:
Sent: 03-04-2022 06:08
From: Alessandro Citrigno
Subject: Capital Letter Function

Hello Everyone,

Is there a function that allows me to capitalize the first letter of each element within a column? I'll give you an example: inside a column I have:

computer
digital platform
Product lines

I would:

Computer
Digital Platform
Product Lines

Something that automates the initials of each word with a major letter if not present. I need it for the purposes of Lookup because is case-sensitive.

Thank You

#ApptioforAll

@Alessandro Citrigno
You also have the option of making the Lookup Formula case-insensitive.

Syntax
Lookup(source_column,lookup_table,matching_column,replacement_column[,leave_original_value][,replace_nulls][,ignore_case]) ​

We often don't specify the last 3 optional arguments of the lookup formula, and they default to false. That's the reason Lookup is case-sensitive by default. However, when ignore_case is set to True, it makes the match value case-insensitive.

------------------------------
JJ Sharma
Sr. TBM Practice Manager
KPMG Australia
------------------------------

Original Message:
Sent: 03-04-2022 06:08
From: Alessandro Citrigno
Subject: Capital Letter Function

Hello Everyone,

Is there a function that allows me to capitalize the first letter of each element within a column? I'll give you an example: inside a column I have:

computer
digital platform
Product lines

I would:

Computer
Digital Platform
Product Lines

Something that automates the initials of each word with a major letter if not present. I need it for the purposes of Lookup because is case-sensitive.

Thank You



#ApptioforAll

Thanks, @Jaitabh Jewel Sharma! I was vaguely aware of the ignore_case option, but have never used it. I'll try to keep it in mind 😏😏😏​

------------------------------
Regards, Guillermo
------------------------------

Original Message:
Sent: 03-06-2022 22:28
From: JJ Sharma
Subject: Capital Letter Function

@Alessandro Citrigno
You also have the option of making the Lookup Formula case-insensitive.

Syntax
Lookup(source_column,lookup_table,matching_column,replacement_column[,leave_original_value][,replace_nulls][,ignore_case]) ​

We often don't specify the last 3 optional arguments of the lookup formula, and they default to false. That's the reason Lookup is case-sensitive by default. However, when ignore_case is set to True, it makes the match value case-insensitive.

------------------------------
JJ Sharma
Sr. TBM Practice Manager
KPMG Australia

Original Message:
Sent: 03-04-2022 06:08
From: Alessandro Citrigno
Subject: Capital Letter Function

Hello Everyone,

Is there a function that allows me to capitalize the first letter of each element within a column? I'll give you an example: inside a column I have:

computer
digital platform
Product lines

I would:

Computer
Digital Platform
Product Lines

Something that automates the initials of each word with a major letter if not present. I need it for the purposes of Lookup because is case-sensitive.

Thank You



#ApptioforAll

Proper()
CapFirstLetter()

should work!
Original Message:
Sent: 03-04-2022 06:08
From: Alessandro Citrigno
Subject: Capital Letter Function

Hello Everyone,

Is there a function that allows me to capitalize the first letter of each element within a column? I'll give you an example: inside a column I have:

computer
digital platform
Product lines

I would:

Computer
Digital Platform
Product Lines

Something that automates the initials of each word with a major letter if not present. I need it for the purposes of Lookup because is case-sensitive.

Thank You



#ApptioforAll