Hi
For editing I find that Notepad++ is very good at playing around
with regex, tabs etc.
But, if I really want to restructure the lines I find that Excel, or
its equivalent, is much better. Just import the text file, without
reformatting since Excel will probably make wrong choices.
Then put a new column at the front and fill it with a set of
sequence numbers - A1 -->1, A2 =A1+1 and then copy down to the end (Ctrl-D),
select column A and copy it, then paste back in as values. Each line has a
unique line number that you can use to recover the file in order after you
have sorted it.
You can now sort the file, including the sequence numbers, and
decide how you need to process each part of it. Usually best to split each
section into multiple columns, as needed. Remove any rows that you don't
need, like headings.
Once you have restructured the lines, just resort the file on the
sequence number. Depending on what you want and how you split the various
types of lines you can then merge rows together (only a few clicks).
This has been my method for manipulating data files and reports for
the last 25 years. Excel is not just a tool for calculations, it an
extremely powerful tool for data manipulation and structure.
Regards
Chris
-----Original Message-----
From: LegacyUserGroup [mailto:legacyusergroup-boun...@legacyusers.com] On
Behalf Of Kris
Sent: 18 April 2017 00:17
To: Legacy User Group <legacyusergroup@legacyusers.com>
Subject: Re: [LegacyUG] Report Font Problem
Hi, Gene -- You can do the same in OOo by just pasting "unformatted text."
Which is what I did. But still needed the regex find/replace to add the
tabs, etc. Kris
On 4/17/2017 3:23 PM, Gene Young wrote:
> On 4/17/2017 3:26 PM, Kris wrote:
>> Hi, Gene --
>>
>> This worked out great, though I've spent all morning formatting the
>> resulting report in Open Office via search and replace with regular
>> expressions and template manipulation. The "raw" copy/paste was just
>> too hard to read. I now have this:
>>
>> http://cousin-collector.com/images/LG-SS-3.jpg
>>
>> If anyone else is having this problem, let me know and I may be able
>> to help you with the regular expressions.
>>
>> Thanks, also, to Chris Hill, for his solution.
>>
>
> That is the primary reason I use Note Tab as an intermediate program.
> It immediately and instantly removes all formatting, leaving pure
> ascii text. Then I did a search and replace for ]"space" replacing
> with ]^T (replaces the space following the ] with a tab. A search and
> replace for "space^Pmarriage:: replace with "space^Tmarriage: removes
> the lf/cr and moves the marriage info to the same line as the couple.
> This takes less that 30 seconds and results in each marriage being on
> its own line. From there is is simple to copy into libre or open
> office for final formatting.
> Very useful program.
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
--
LegacyUserGroup mailing list
LegacyUserGroup@legacyusers.com
To manage your subscription and unsubscribe
http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
Archives at:
http://www.mail-archive.com/legacyusergroup@legacyusers.com/
--
LegacyUserGroup mailing list
LegacyUserGroup@legacyusers.com
To manage your subscription and unsubscribe
http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
Archives at:
http://www.mail-archive.com/legacyusergroup@legacyusers.com/
