Solved

String Extract from column

  • 5 September 2017
  • 2 replies
  • 15 views

Badge +2

I have a workflow that sends emails and uses elements from the library columns to fill in the text. A few of these columns are pulling in the column ID and the text that is stored in that column, IE "Tire|33bee267-b1c5-4d3d-b2bb-8ddd0d25cf9e". I just need the information before the pipe to be displayed in the email. Does anyone know how to go about separating this in variables so the emails are readable?

icon

Best answer by paul_crawford 5 September 2017, 22:53

View original

2 replies

Userlevel 4
Badge +7

Hi

use a regex expression with this expression. ^[^|]*

use the extract option and save this to a collection and then use a collection operation, with an integer variable set with a default value of 0 as the index and save this to a text variable and you should have the text you need. 

Let me me know if you need more help

‌ 

Badge +2

Thank you, Paul! Worked like a charm. 

Reply