cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Extract string left of @ character

Jump to solution

Hi,

For a given email address, e.g. john.smith1@hello.co.uk, how could I extract the text before the "@" and store it in a variable? Which, in this case would be john.smith1

Usually I would use the 'Left' function but that doesn't seem to be present in Nintex.

Any ideas?

Thanks

Reply
4 Replies
Workflow Hero

Re: Extract string left of @ character

Jump to solution

You can do it following these steps:

-Create a variable named myResult (string type)

-Create a variable named myResults (collection type)

-Create a variable named myIndex (number type-default 0)

-Add the action named "Regular Expression"

-Add the action named "Collection operation"

You will get the result in "myResult"

Reply
Workflow Hero

Re: Extract string left of @ character

Jump to solution

Thanks Fernando

Reply
Workflow Hero

Re: Extract string left of @ character

Jump to solution

Hi Fernando Hunth

Is there a way to do this for multiple splits.. example..

I want to extract text in a date field "3/04/2016 12:00 am." my desired result is 3042016

Please let me know if this is possible

Thanks,

Kimberley

Reply
Workflow Hero

Re: Extract string left of @ character

Jump to solution

You could use the fn-Replace function

fn-Replace (     fn-Replace ( {yourVar}, "12:00 am.", "" )   , "/" , "" )

Reply