cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Nintex Newbie

Pull out only the text after ";" into another column

I have a column which captures the email subject. All items have the same email subject followed by the relevant/unique country name: 

    emailsubject;country

The country in the email subject makes the email unique. I need to pull the country out into a country column to allow filtering on the country.

 

;\w+ works for countries with one word but I need a pattern that will work for single or multiple words in the country name.

For example - using ;\w+ for Spain works but for Saudi Arabia it only picks up the Saudi.

 

Thanks

 

@vadim_tabakman 

Labels: (1)
0 Kudos
Reply
4 Replies
Highlighted
Nintex Employee
Nintex Employee

Re: Pull out only the text after ";" into another column

Hi,
I would use a regular expression to split the string at the ; and then update the colum with the required country.
No regex is required.
That will put the two halves into a collection variable and you just need to pull out index 1 to get the half that you need.
0 Kudos
Reply
Highlighted
Nintex Newbie

Re: Pull out only the text after ";" into another column

@SimonMuntz 

Thanks - Can you explain how I pull the index to get the half I require?

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: Pull out only the text after ";" into another column

Company name,text,moretext
This is my pattern I need to pull the company name only. Please note that the company name may consist of one word two words or more.
0 Kudos
Reply
Highlighted
Nintex Employee
Nintex Employee

Re: Pull out only the text after ";" into another column

The regular expression ^[a-zA-Z\s]+ shoud work for company names with spaces in them.
0 Kudos
Reply