I'll put out some ideas, but it's hard without seeing some example records
from the DB to match against. I'll assume a CSV style layout.
Example record: 2, 82, 1034, 138
find: ^(\d+),[ ]*\d{1,3},[ ]*(\d{3,4})
replace: \1, \2
This will remove column 2, which I believe is what you're asking for. The ^
means it will match the start of the line.
-K
On Wednesday, July 25, 2012 1:10:42 AM UTC-4, Steven wrote:
>
> This is an updated question to my previous enquiry. I am going to say
> thanks to the really nice folks who answered my last question.
>
> The basic issue is I have a database file that I have updated irregularly
> on two different systems. One is consistently the more rational system,
> but it has goofy id numbers because of the way it has been updates.
>
> The particular table I want to update will have two sets of numbers side
> by side. n^1, n^2. N1 is a number of 1 to 3 digits. N2 is three or
> four digits. I have other three digit or four digit sets in the database,
> so I only want to update the three or four digit number next to the very
> first number in the table, which can be one, two or three digits.
>
> I want to tell the machine to find the pair of numbers, eliminate the
> second set so that the database when I drop and then rebuild the table the
> second set will be set from the auto increment and will start at one,
> rather than at 1400.
>
> Is there a way to do this?
>
> Thanks again for your courtesy.
>
>
--
You received this message because you are subscribed to the
"BBEdit Talk" discussion group on Google Groups.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
<http://groups.google.com/group/bbedit?hl=en>
If you have a feature request or would like to report a problem,
please email "[email protected]" rather than posting to the group.
Follow @bbedit on Twitter: <http://www.twitter.com/bbedit>
