I’m trying to set up a custom import of transactions in a CSV file. Most dates in the date column look like this: 10/29/2025. Those dates are interpreted correctly. Some dates look like this: 10/29/2025 as of 10/27/2025. I need to extract the first date out of “10/29/2025 as of 10/27/2025”. Something like this regular expression might work for both date strings: (^\S+) I’m having trouble implementing this regex in the preset. The example in the documentation doesn’t actually show how to implement the replace function. Any ideas would be appreciated.
Instead of “Replace” use “Extract” and then you don’t even need to use parentheses if your expression looks like this: [0-9]+/[0-9]+/[0-9]+ . It’s best to enable matching from the beginning (click middle toggle with |A| so it’s |→).
As for replacing, your pattern is correct, but it does nothing, as it replaces the matched text with the matched text 
. In your case, you’d rather want to have as of .+ → [empty field] so that the second date gets removed.