splitting long numbers

General Discussion
1

I have files that have sets of numbers that I want to seperate with spaces or dashes.

Example: 550424

55 is the year
04 is the month
24 is the day

So I would like the result to be 55 04-24

I am thinking RegEx would work but I have no idea on how to do it.

if it was 55-04-24 it would be simple:)

Thanx ahead of time!!!

2

Yes, regular expressions can do that :slight_smile:

Action type: Replace with regular expression
Field: Type in the field here
Regular expression: (\d{2})(\d{2})(\d{2})
Replace matches with: $1 $2-$3

3

Wow!!! Simply Amazing!! It works great! Thank-you soooo much! and congrats on winning gold!!