AnsweredAssumed Answered

Extract data from multiple lines of text field

Question asked by rortiz312000 on Nov 12, 2015
Latest reply on Nov 13, 2015 by rortiz312000

I’m using a list Nintex workflow in SP 2013, I have requirements to extract data from multiple lines text field, and store the data in to another field. Below, please find sample text:

 

“QUALIFICATIONS:                    
Knowledge       
·            Advanced
working knowledge of information systems and operations systems for supported
business
groups.          
·            Advanced knowledge
of business processes for supported business groups.  core business
functions, policies and procedures.                    
Skills       
·            Ability and
willingness to achieve organizational and individual goals by seizing
opportunities and learning from
experience.          
·            Excellent
oral, written, and interpersonal communication skills with all levels of the
organization; ability to communicate concepts and processes in an easy to
understand manner to a diverse audience.
      ·    
Experience       
·            Bachelor's
degree in computer studies or equivalent
experience.      
·            5 to 7
years prior analysis experience in an Information Technology environment and
respective business area.        WORK
CONDITION:          Work is
conducted in a professional office environment. Typically, subject to stressful
situations arising from set project timelines, delivery deadlines, and managing
multiple projects and priorities.”

 

So the requirement is to extract:

“Experience       
·            Bachelor's
degree in computer studies or equivalent
experience.        ·          
5 to 7 years prior analysis experience in an Information Technology environment
and respective business area.”   Into another field.

 

Then extract: 

WORK
CONDITION:          Work is
conducted in a professional office environment. Typically, subject to stressful
situations arising from set project timelines, delivery deadlines, and managing
multiple projects and priorities. Into another field.

 

This is exactly how it's sent over to me!

 

Would someone be so kind as to offer me a regular expression solution?  

 

Thanks for your help in advance.

Outcomes