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 RE?...

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 þ^þ. Eac...

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\abcxyz...

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 this:...