Splunk Search
Highlighted

Capitalize the first character of a string value using eval or field format?

Path Finder

How can I capitalize the first character of some string values using one of the eval or fieldformat operators?

Tags (3)
Highlighted

Re: Capitalize the first character of a string value using eval or field format?

Legend

Off the top of my head (I have no Splunk instance to try this on at the moment), this should do it:

... | eval myfield = upper(substr(myfield,1,1)).substr(myfield,2)

View solution in original post

Highlighted

Re: Capitalize the first character of a string value using eval or field format?

Splunk Employee
Splunk Employee

Try this

| eval myfield = upper(substr(myfield,1,1)).lower(substr(myfield,2))
0 Karma