Community

ben_josephs wrote:

Find what: (.+)\n+(.+)\n+(.+)\n+(.+)
Replace with: \('$1', '$2', '$3', '$4'\)

Thank you Ben.
Your code works only for 4 entries. I need a generic solution, where it should work, even if i enter 100 entries.

I need little help in creating a macro. The regex works as expected. But when I try to put it in a macro, it doesn’t work. This is one column of data: C0031 C1376 F189 F912 This is how I want the data to look like. ('C0031', 'C1376', 'F189', 'F912') Here are the steps I follow. They work perfectly...

I found that the maximum length limit for replace string is 1024 characters. I am doing a replace which is longer than 1024 characters. Is there a way to increase the limit? Some sort of setting that I can update?

What are the things that can be achieved only in Wildedit and not in Textpad?

Thank you Ben. That makes sense.

When I try to see the content of file (by TYPE DOS command), every character is delimited by a space. After – converting the file to DOS – in textpad, the file looks fine.

Why does this happen?

Got your point. Thank you Ben.

Is it possible to have RegEx for a range? For e.g. how to write a RegEx that searches numbers falling between 50 and 75?

Amazing! Thank you ben!

My apologies for not giving a proper example. The RegEx works for my earlier example, however it is not working for following case,

Thank you Ben! It worked.

I need to prefix the objects with schema name. I have the following code, I need a RegEx which prefixes "dbo." to objects; at the same time it also takes care of existing schema.

Is there an easy way to insert header and footer in ALL OPEN DOCUMENTS using textpad?

Thanks Bob. Thanks talleyrand.

As talleyrand mentioned I was looking for an option similar to - "match entire document" and replace with "header"\1"footer"

I have around 40 files, in which header and footer (constant string) is required. How to achieve this using regular expressions or macro?