Community

By newline, do you mean \n? Each record is on one line; I don't understand why I would have to change newlines to something else?

I was hoping I could do something like


...,"any or no character"anycharacter"any or no character",...


between the delimiters (commas) find the inner quotes, with ...

Hi, tried searching and couldn't find an answer, this is the closest thread I could find: http://forums.textpad.com/viewtopic.php?t=7698

I am trying to find and replace double quotes that are within another set of double quotes between commas with single quotes, i.e.:

,12344,"text",absd,5830 ...

@ben_josephs: Thanks so much, that works great! I was missing using the | for alternate matching. It seems so simple now looking at it :D

Anything but 1 as the first character, or anything but 0-3 as second or anything but 0-9 as third or ... and so on.

@Kaizyn: That did work, but only when the ...

I wanted to identify any data that didn't match the pattern as a validation step. If there was any data that didn't match this pattern, I could identify it and correct the problem.

I hadn't used bookmarks before, but that seems to work. Instead of Edit->Delete->Bookmarked Lines, I just did Edit ...

Hello,
I am trying to find values that do not match a particular pattern. My data is in the format:

123P45678
107N94861
132P59304

where:
the first character should always be a 1,
the second character should always be a 0, 1, 2, or 3,
the third character should be any number 0-9,
the fourth ...