Yes, column two is what I am looking to remove.
What it looks like is
insert into record(fknumber, primaryKeynumber,description, year,page_count)
values ({a range from 1-600},{a range from 850-1800},'some text',{a range
from 0-2012},{a range from 100-2200}) I want to make sure I remove only
the second column and not any other. Since the second column is a auto
incremented primary key, (that got munged somehow during the last backup) I
can delete that column and have it auto increment again fresh at 0
On Wednesday, July 25, 2012 6:41:41 AM UTC-7, Kendall Conrad wrote:
>
> 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>
