Get part of field

joris raffin

Hi, 

I have an issue, I have many mails coming in my JSM and i would like to take the 5th line of these mail to put the text in another field.

 

I know that there is smart values like substringBetween etc but i don't know how to isolate a specific Line of the description field.

Moreover once i have this value how can i use it in the same automation ?

Alex Koxaras -Relational-

Hi @joris raffin 

That's a tricky situation you got there. Now, I've run some tests and I'll lay out the main foundation for the solution I'm going to give you. I'm taking for granted, that when you say "5th line" you mean "5th NEW line". This simply mean that your emails (e.g. you want to take the 5th line of the email body (description)) has to have 5 lines, each separated with the "\n" new line. In that case, using the following smart value will get you the result you want:

{{issue.description.split("\n").get(4)}}

Do let me know if that works out for you.