Usage Of Splunk Eval Function : LTRIM

“ltrim” function is an eval function. We can use one or two arguments with this function and returns the value from first argument with the character/characters in second argument trimmed from the left side.

Note : If second argument is not specified then it remove spaces and tabs from the first argument from left side.

Syntax :  

| eval <field_name>=ltrim(A,B)

Example :

| makeresults
| eval Name="Ram,Sham,Jadu,Shaan" , Name=split(Name,",")
| mvexpand Name
| eval New_Name=ltrim(Name,"Sh")

Result :
Image 1 : –

Image 2 : –
Explanation :

  • In the first image (Image1) search creates one result using the makeresults command.
  • The search then uses the eval command to create a field “Name” with some comma separated value.
  • Then we have used eval function split to split the comma separated value.
  • After perform split function one multivalue field has been created there and using mvexpand command we split this multivalue field in a separate row for each value.
  • In the second image (Image2) we use eval command to create a new field New_Name and also we used eval function ltrim to remove the characters from left side.

Into the ltrim function we use two arguments, first one is field name (from where we want to remove character) and the second one is which character/characters we want to remove.

  • In the new field New_Name contains output result from name field after removal of  character/characters from the left side which we have mentioned as a second argument (“sh”)  with the ltrim function.

Now you can effectively utilize “ltrim” function with “eval” command to meet your requirement !!

You can also know about :  Usage of Splunk EVAL Function : MVJOIN

Hope you are now comfortable in : Usage of Splunk EVAL Function : LTRIM


One comment

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.