parsing data with various case

Jeff Raymond

Greetings all!

I am wondering if there is an easy way to seperate data that was not parsed properly

Example

redCherries
blueBlueberries
yellowLemons

Is there an easy way with this tool to make them

red Cherries
blue Blueberrues
yellow Lemons

thanks in advance

Scott Sumner

Find what zone: (?-i)([a-z]+)([A-Z])
Replace with zone: \1 \2
Search mode: Regular expression

…but…is your real data really as simple as your example??

Jeff Raymond

I suck at regex. But I will give it a shot.

Jeff Raymond

Scott, that worked. I am not a developer but Ive used REGEX in old school REXX

THANKS!