Community

Thank you for your reply.

This one is totally manual work. I want to do with Macro and RE since we have thousands of text files with different line counts from 10 to 1000+ lines each.

All I want to do is: Open a text file - Run Macro - DONE.

Best,

I have many text files with so many lines that I want to line up lines with its value. For example:

Line1
Line2
Line3
...
...
...
Linex
ValueofLine1
ValueofLine2
...
...
...
...
ValueofLinex

To become:

Line1 ValueofLine1
Line2 ValueofLine2
...
...
Linex ValueofLinex

How can I do it with Marco or ...

Here is the example:

þHeadersþ
þ1þ^þxxxxxxx....
þ2þ1þ^þxxxxxxx....
þxdsfdfd
kalfjadfodl
þ3þ^þxxxxxxx....
þdfdfdsfsdfds
dfasdfdsfsdfds
þ4þ^þxxxxxxx....
....
....

a DAT file with thousands of lines (records) starting from 1 to....Headers can be up to 100 fields separated by þ^þ ...

Hi,

How can I just simply search and replace on bookmarked lines only, ignoring the rest in a text file?

Thanks

Actually replace with \2-\1.

I never think about nested group in RE.

You are genius Ben!!!
Thank you so much.

Hi,
How can I copy file name from each line and paste it at the beginning of the line with regular expression. For example, I have directory file listing as follows:

C:\Users\abcxyz\Documents\Default.rdp
C:\Users\abcxyz\Documents\desktop.ini
C:\Users\abcxyz\Documents\LotusInstall.log
C:\Users ...

I have a sample of a text file below with multi lines of data between each records

Record 123
[MULTI LINES OF DATA HERE]
Record 124

Record 125

Record 130

Record 163

Is there anyway to add a number to the record number using marco and/or RE? For example if adding 50, my text file will look like ...