Skip to content

Make 1st letter of a field value uppercase in ETL

lthomas

lthomas Member

January 10 in Datasets

Is there a way to make the first letter of a value in a field uppercase? Not the entire word, just the first letter…

0

Best Answer

ColemenWilson Coach

January 10 edited January 10 Answer ✓
CONCAT(UPPER(LEFT(`YourField`,1)), SUBSTRING(`YourField`, 2))
If I solved your problem, please select "yes" above
1

Answers

ColemenWilson Coach

January 10 edited January 10 Answer ✓
CONCAT(UPPER(LEFT(`YourField`,1)), SUBSTRING(`YourField`, 2))
If I solved your problem, please select "yes" above
1
lthomas Member

January 10

Thanks @ColemenWilson This worked great!

0

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.

Categories