Legal case names, inversion of

How about --

Group on the "v."

search & replace v. with , v. (comma v.)

select all the fields

Control+F6 to move everything after the comma to subentry field

Control+P to flip the entries

if you want to restore the original entries as main entries only, then use

Ctrl+F7

or you could have SKY consolidate orphan entries and then search to remove

commas before v.

Nancy Guenther

Make a back up.

Group using "v."

Use Control-D to duplicate this group

Use Shift-F6 to group the duplicates -- it's important to only have your

duplicate records in this group.

Open the Find box, Check "Use Pattern matching"

In the Find What box type: {*} v. {*}

In the Replace With box type: {2}, {1} v.

(be sure to include the spaces in the above)

Voila!

Ann Truesdale

OK, here's a way I just made up - if you can group all your cases together

and select them all at the same time, this will be a snap:

Set your OptionsProgram OptionsData entry Promote separator to ", "

(comma and space), Set the Demote separator to " " (two spaces)

Then, Select all your cases together (or do them separately) and do the

following:

1. Ctrl F6, choose Main to demote the ending case

2. Ctrl I (that's an "i" for italics) and choose Sub 1 (for some reason the

italics gets stripped away)

3. Ctrl F1 to flip the Main and Sub1 headings

4. Ctrl F5, Choose sub 1 to promote the leading case

- Susan

You can do it in Excel like this:

Starting in A1, copy and paste the entries to be inverted into column A

In B1 write =FIND("v.",A1) - this will locate the position of the v

full stop in the string

In C1 write =RIGHT(A1,LEN(A1)-B1-2) - this will extract the righthand part

of the string that follows the v full stop

In D1 write =LEFT(A1,B1+1) - this will extract the lefthand part of the

string up to and including the v full stop

In E1 write =C1 & ", " & D1 - this joins the two parts together with a

comma between them.

Autofill everything from B1-E1 down alongside all the entries to be

inverted. Then select everything in column E and copy it. Paste it into

Notepad so it ends up as text, save the Notepad file with a .TXT extension.

Back in Sky, use File Import to import the entries. Make sure the delimiter

is set to something other than comma, or you will end up with defendants in

the page number field.

Save the Excel file and keep it for next time. The same method can be used

to invert names, for instance, by looking for the space between first and

last name.

If you experiment a little you may be able to keep the page numbers as well.

Jon.