Studio workflow if contains numbers

Hi Robert,

Yes, you can do this fairly easily using the Data Transfer event along with Regular Expressions functions from the Text group of functions in the Workflow Context browser.

NOTE: Download the attached StringTest.kprx workflow solution file for K2 Studio for better reference.

1. Essentially, I created two DataFields for the workflow, one called "StringToTest" and the other "EightDigits". Although your input string to test can come from a Form input, SmartObject, etc.

StringToTest is used to house a string value of:   FB82909182AlbmCRP923

EightDigits is used to store the first matched string of eight consecutive digits.

2. Then I used them in the Data Event called "Transfer 8 Matched Digits to EightDigits DataField". This event uses the "Match Single" Regular Expression function in conjunction with this regular expression "d{8}", to scan the "StringToTest" datafield for 8 consecutive digits. If found, the fuction returns the first matched string.  e.g. 82909182 from FB82909182AlbmCRP923

NOTE: You may need to experiment with the Regular Expression for your own needs. RegexPal Tester helped me.

3. From there the DataEvent takes the return value and puts it in the DataField called "EightDigits". If it doesn't find a match, I just use the Empty String function from the Text group of functions as the return value. Notice the option in the above image called "Expected When Empty". From there, you can then use Line Rules to branch the workflow by testing if the EightDigits datafield is "Empty".

4. In the end, the results transferred accordingly.

Hope this helps!

Jason

NOTE: This was run with Blackpearl 4.7.  Also, there are other things you could check for if necessary, such is if your input string is >= 8 characters before running the data transfer event.

Hi Robert,

Yes, you can do this fairly easily using the Data Transfer event along with Regular Expressions functions from the Text group of functions in the Workflow Context browser.

1. Essentially, I created two DataFields for the workflow, one called "StringToTest" and the other "EightDigits". Although your input string to test can come from a Form input, SmartObject, etc.

StringToTest is used to house a string value of:   FB82909182AlbmCRP923

EightDigits is used to store the first matched string of eight consecutive digits.

3. From there the DataEvent takes the return value and puts it in the DataField called "EightDigits". If it doesn't find a match, I just use the Empty String function from the Text group of functions as the return value. Notice the option in the above image called "Expected When Empty". From there, you can then use Line Rules to branch the workflow by testing if the EightDigits datafield is "Empty".

Hope this helps!

Jason

NOTE: This was run with Blackpearl 4.7.  Also, there are other things you could check for if necessary, such is if your input string is >= 8 characters before running the data transfer event.

Hi Robert,

Yes, you can do this fairly easily using the Data Transfer event along with Regular Expressions functions from the Text group of functions in the Workflow Context browser.

1. Essentially, I created two DataFields for the workflow, one called "StringToTest" and the other "EightDigits". Although your input string to test can come from a Form input, SmartObject, etc.

StringToTest is used to house a string value of:   FB82909182AlbmCRP923

EightDigits is used to store the first matched string of eight consecutive digits.

3. From there the DataEvent takes the return value and puts it in the DataField called "EightDigits". If it doesn't find a match, I just use the Empty String function from the Text group of functions as the return value. Notice the option in the above image called "Expected When Empty". From there, you can then use Line Rules to branch the workflow by testing if the EightDigits datafield is "Empty".

Hope this helps!

Jason

NOTE: This was run with Blackpearl 4.7.  Also, there are other things you could check for if necessary, such is if your input string is >= 8 characters before running the data transfer event.

Hi Robert,

Yes, you can do this fairly easily using the Data Transfer event along with Regular Expressions functions from the Text group of functions in the Workflow Context browser.

Hope this helps!

Jason

NOTE: This was run with Blackpearl 4.7.  Also, there are other things you could check for if necessary, such is if your input string is >= 8 characters before running the data transfer event.

Hi Robert,

Yes, you can do this fairly easily using the Data Transfer event along with Regular Expressions functions from the Text group of functions in the Workflow Context browser.

1. Essentially, I created two DataFields for the workflow, one called "StringToTest" and the other "EightDigits". Although your input string to test can come from a Form input, SmartObject, etc.

StringToTest is used to house a string value of:   FB82909182AlbmCRP923

EightDigits is used to store the first matched string of eight consecutive digits.

3. From there the DataEvent takes the return value and puts it in the DataField called "EightDigits". If it doesn't find a match, I just use the Empty String function from the Text group of functions as the return value. Notice the option in the above image called "Expected When Empty". From there, you can then use Line Rules to branch the workflow by testing if the EightDigits datafield is "Empty".

Hope this helps!

Jason 

NOTE: This was run with Blackpearl 4.7.  Also, there are other things you could check for if necessary, such is if your input string is >= 8 characters before running the data transfer event.

Hi Robert,

Yes, you can do this fairly easily using the Data Transfer event along with Regular Expressions functions from the Text group of functions in the Workflow Context browser.

1. Essentially, I created two DataFields for the workflow, one called "StringToTest" and the other "EightDigits". Although your input string to test can come from a Form input, SmartObject, etc.

StringToTest is used to house a string value of:   FB82909182AlbmCRP923

EightDigits is used to store the first matched string of eight consecutive digits.

3. From there the DataEvent takes the return value and puts it in the DataField called "EightDigits". If it doesn't find a match, I just use the Empty String function from the Text group of functions as the return value. Notice the option in the above image called "Expected When Empty". From there, you can then use Line Rules to branch the workflow by testing if the EightDigits datafield is "Empty".

Hope this helps!

Jason

NOTE: This was run with Blackpearl 4.7.  Also, there are other things you could check for if necessary, such is if your input string is >= 8 characters before running the data transfer event.

Hi Robert,

Yes, you can do this fairly easily using the Data Transfer event along with Regular Expressions functions from the Text group of functions in the Workflow Context browser.

1. Essentially, I created two DataFields for the workflow, one called "StringToTest" and the other "EightDigits". Although your input string to test can come from a Form input, SmartObject, etc.

StringToTest is used to house a string value of:   FB82909182AlbmCRP923

EightDigits is used to store the first matched string of eight consecutive digits.

3. From there the DataEvent takes the return value and puts it in the DataField called "EightDigits". If it doesn't find a match, I just use the Empty String function from the Text group of functions as the return value. Notice the option in the above image called "Expected When Empty". From there, you can then use Line Rules to branch the workflow by testing if the EightDigits datafield is "Empty".

Hope this helps!

Jason

NOTE: This was run with Blackpearl 4.7.  Also, there are other things you could check for if necessary, such is if your input string is >= 8 characters before running the data transfer event.

Hi Robert,

Yes, you can do this fairly easily using the Data Transfer event along with Regular Expressions functions from the Text group of functions in the Workflow Context browser.

1. Essentially, I created two DataFields for the workflow, one called "StringToTest" and the other "EightDigits". Although your input string to test can come from a Form input, SmartObject, etc.

StringToTest is used to house a string value of:   FB82909182AlbmCRP923

EightDigits is used to store the first matched string of eight consecutive digits.

3. From there the DataEvent takes the return value and puts it in the DataField called "EightDigits". If it doesn't find a match, I just use the Empty String function from the Text group of functions as the return value. Notice the option in the above image called "Expected When Empty". From there, you can then use Line Rules to branch the workflow by testing if the EightDigits datafield is "Empty".

Hope this helps!

Jason

NOTE: This was run with Blackpearl 4.7.  Also, there are other things you could check for if necessary, such is if your input string is >= 8 characters before running the data transfer event.

Hi Robert,

Yes, you can do this fairly easily using the Data Transfer event along with Regular Expressions functions from the Text group of functions in the Workflow Context browser.

1. Essentially, I created two DataFields for the workflow, one called "StringToTest" and the other "EightDigits". Although your input string to test can come from a Form input, SmartObject, etc.

StringToTest is used to house a string value of:   FB82909182AlbmCRP923

EightDigits is used to store the first matched string of eight consecutive digits.

3. From there the DataEvent takes the return value and puts it in the DataField called "EightDigits". If it doesn't find a match, I just use the Empty String function from the Text group of functions as the return value. Notice the option in the above image called "Expected When Empty". From there, you can then use Line Rules to branch the workflow by testing if the EightDigits datafield is "Empty".

Hope this helps!

Jason

NOTE: This was run with Blackpearl 4.7.  Also, there are other things you could check for if necessary, such is if your input string is >= 8 characters before running the data transfer event.

Hi Robert,

Yes, you can do this fairly easily using the Data Transfer event along with Regular Expressions functions from the Text group of functions in the Workflow Context browser.

NOTE: Download the attached StringTest.zip workflow solution file for K2 Studio for better reference.

1. Essentially, I created two DataFields for the workflow, one called "StringToTest" and the other "EightDigits". Although your input string to test can come from a Form input, SmartObject, etc.

StringToTest is used to house a string value of:   FB82909182AlbmCRP923

EightDigits is used to store the first matched string of eight consecutive digits.

1. Then I used them in the Data Event called "Transfer 8 Matched Digits to EightDigits DataField". This event uses the"Match Single" Regular Expression functionin conjunction with a regular expression(see image below for pattern), to scan the "StringToTest" datafield for 8 consecutive digits. If found, the fuction returns the first matched string.  e.g. 82909182 from FB82909182AlbmCRP923

NOTE: You may need to experiment with the Regular Expression for your own needs. RegexPal Tester helped me.

1. From there the DataEvent takes the return value and puts it in the DataField called "EightDigits". If it doesn't find a match, I just use the Empty String function from the Text group of functions as the return value. Notice the option in the above image called "Expected When Empty". From there, you can then use Line Rules to branch the workflow by testing if theEightDigitsdatafield is "Empty String".

1. In the end, the results transferred accordingly.

Hope this helps!

Jason

NOTE: This was run with Blackpearl 4.7.  Also, there are other things you could check for if necessary, such is if your input string is >= 8 characters before running the data transfer event.

Wonderful!  I have not tried it yet, but from what I can see, I think it's going to work perfectly.  

I hope to someday have enough K2 Studio knowledge to return the favor. :)

Rob