You are viewing limited content. For full access, please sign in.

Question

Question

How do I parse a field using pattern matching

asked on July 15, 2014

 

Using QuickFields 8.1 and trying to parse a string with inserted delimiters using pattern matching.  The input string contains valid spaces so /S+ will not work correctly. I can create the input string with any delimiter needed with the end goal to provide a multi-valued field with department. 

 

Input   Leased Housing^IT^Human Resources

 

Output  

Leased Housing

IT

Human Resources

 

The question is what pattern matching command string will do this

 

Craig

0 0

Answer

APPROVED ANSWER SELECTED ANSWER
replied on July 15, 2014

Craig,

 

If QF 8.3 has provision for multiple matching (as does workflow), the following pattern will work accordingly:

 

 

Louis-Simon

1 0
replied on July 16, 2014

Thank you, prelim testing seems to work in 8.1. I will do a real data test later this week

 

Craig

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.