This is a problem I have run into a number of times and it just seems that there ought to be a way to make it work.
I am trying to chunk data…that’s my term. Creat records, essentially. The data is in a text file. Rather than being delimited by tabs or spaces or anything else normal, each individual piece of data exists on a line of its own. Now, if each complete “record” were precisely the same number of lines, I could probably make that work without too much agony. Even if each complete record had the same starting or ending info, I might be able to make it work. But it doesn’t. So I’m stumped about how to structure or manipulate it so that I can actually create records.
Let me show you (what I’m working with currently is text extracted from my Eudora Filters…I have so many that my mail is a mess and I can’t figure out what’s what. However bizarre it is of me, I’d like to pullo that informaiton into either Filemaker or Excel and be able to search it for repeats, sort it, see what’s conflicting with what, none of which is possible in Eudora itself…very annoying. If anyone knows of a program that will do this for me, that would be great. But I’d still like this question answered because I’ve run across it in other contexts.)
Record one is:
transfer : RetroRelated:Content Related:Andreas
personality test personality
the next record, which starts on the very next line, is:
rule Any Recipient:Gfone
header Any Recipient
reply AA Password Request
speak 3 1836346163 50
And the next:
Now, there is a max of 5 actions for any filter, but as you can see, there are many possible parts to any given action as well as parts to the rules.
So, Data crunchers Extraordinaire…any help you can offer on how to parse this puppy? (FYI: ;the total number of rows in the file is nearly FOUR THOUSAND! Crazyness…)