Extract data from multiple lines of text field

  • 12 November 2015
  • 4 replies
  • 7 views

Badge +4

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.


4 replies

Badge +4

No, I guess I would need help with that if that is the way to extract data.

Thanks

Userlevel 4
Badge +10

I agree with Lei Fu. Until Nintex creates a FIND function (like Excel's) that will find the position of a string of text within a string of text, regular expression is almost your only option. if you are able to install a 3rd party function (or your central admin managers are) Vadim Tabakman has created a function that will do the trick while nested in a fn-substring(). Nintex Workflow - InStr Inline Function - Vadim Tabakman

Badge +5

Something like this should work.

 

.*(?<experience>Experience[Ss]*)s(?<workcondition>WORK[s]CONDITION[Ss]*)

 

Use replace text and then in the replacement text use ${experience} or ${workcondition} depending on which result you want to capture. 

Badge +4

Jeremiah,  Thanks so much!  It worked!!!

Reply