Zugg Software :: View topic - SQL on Access help cleaning up Map database

Enchanter Joined: 10 Oct 2000 Posts: 656 Location: USA

I know this is not really zmud related, but perhaps somebody can help me.

I'm working with the raw map database file in access trying to clean up some room descriptions that I created a while back with a bad map config.

The desc field in the ObjectTbl table has some bad data. One example would be
Desc=
A very small tunnel
You are deep underground in a very small rocky tunnel. The ceiling here is high. The air is very moist here. A very small amount of glowing moss grows here. It is blindingly bright here.
There are two exits: northeast

Notice that the Desc field has both the room name and the exit line. What I want to do is create a update query that will remove "There are %w exits: #w" part along with remove the first line if the first line is the same as room name field from the table.

But I want to keep "You are deep underground in a very small rocky tunnel. The ceiling here is high. The air is very moist here. A very small amount of glowing moss grows here. It is blindingly bright here." in the desc field.

Any suggestions?

SubAdmin Joined: 18 Nov 2001 Posts: 5182

Use zMud instead of Access. If you use the %mapquery function and check for multiple lines in the description (don't ask me the exact SQL string, the line breaks are stored as %crlf) you should get a list of rooms with multiple lines. Next just loop through them and use %word, %match, and %roomname to find and fix the problems.