Regular Expressions(Regex): Reformatting Date Example (Text Datatype)

Question:


I am doing advanced data extraction on a date field/zone; for example, this is what I’m extracting:

Termination
Effective
1/9/2015
Date:

My regex expression looks like this:

(?i).+\s.+\s(?.+)

I am looking for the date only, which I can extract without issue. However, I’m trying to replace the / in the date with a – instead. I’ve tried various methods to accomplish with the last straw using character filtering (auto correct with / to -) but that didn’t seem to work either. How can I extract a date such as 1/9/2015 but have the data look like 1-9-2015?

Solution:

You can accomplish this by extracting and regrouping using Custom Formatting under the Advanced Tab in step 6 of 10 under Document Type Configuration. Use a regex that uses grouping so for this instance. It is important to leave the field that is being formatted set to text so that it can be adjusted without system level adjustments being made.

1/19/2015

Your Example: (?i).+\s.+\s(?.+)

Grouped example: (?i).+\s.+\s(?\d{1,2})\s*.\s*(?\d{1,2})\s*.\s*(?\d{4})

Then in the customer formatting {Month}-{Day}-{Year}

When entered 1/19/2015 = 1-19-2015