Question

Patterning Matching to get month to display

Workflow Pattern Matching and Regular Expressions

Updated May 30, 2019

asked on May 29, 2019

I am building a Workflow and using the Pattern Matching for Months. I can get the months to display as numbers (03) but cannot get them to display as the actual month (March.) I have used MMMM in the pattern but it only works in the Results Value now the actual workflow. I am currently using this:

Input:%(RetrieveFieldValues3_Date)

Pattern: (\d?\d?)/\d?\d?/\d?\d?\d?\d?

Month Pattern Matching.PNG (9.09 KB)

| Download

0 0

Replies

replied on May 29, 2019

You need to use the formatting feature in the Token Dialog.

4 0

replied on May 30, 2019

It is as Devin Goble said.

When you see %(RetrieveFieldValues3_Date) literally right click on and go Token editor.

Click apply formatting and type in MMMM.

The output of this should be whatever the month provided as plain text.

IF your date format is not completely bummed.

1 0

replied on May 29, 2019

I have tried this and the Result Value is (Empty match.) Testing it results in nothing.

Month Pattern MMMM.PNG (21.85 KB)

| Download

Mothn Pattern MMMM2.PNG (11.88 KB)

| Download

0 0

replied on May 29, 2019

Could it be that your Field captured is not a Date field, which is why the Token "MMMM" is not working. I's suggest changing the Field attribute from String to Date to see how that affects the above.

0 0

replied on May 29, 2019

Pattern matching doesn't work this way. If you want to match "March", then your input needs to contain "March". In your second screen shot, you have a test value of 03/28/2019. If you want to match that to "March", then your pattern needs to be \A03

It feels like we're I'm not getting a clear picture of what your are attempting to do. I apologize, I'm probably being dense.

1 0

You are not allowed to follow up in this post.

Question

Question

Patterning Matching to get month to display

Replies

Sign in to reply to this post.