I have a pipe delimited records in several text files that I am loading into a DB. As it turns out, sometimes a field will start with a quote but wont end with one, which causes the load to fail. Here's an example record

```
||field2|"field3"|"field4|"field5"|||

```

Notice that field 4 is missing the trailing quote. I would like to pre-process the file and remove the leading quote for these fields, but i can't seem to come up with a regex that works

I've tried lookahead and lookback combinations but always match `|"field3"|"field4|` instead of just `|"field4|`

I need something that looks for `|"` and some text that doesn't have a pipe, ending in a pipe without a leading quote.