Click here to Skip to main content
16,011,974 members
Home / Discussions / C#
   

C#

 
GeneralRe: Blank datagrid--parameter issue? Pin
Josh Smith22-Jun-06 10:01
Josh Smith22-Jun-06 10:01 
AnswerRe: Blank datagrid--parameter issue? Pin
Josh Smith22-Jun-06 7:52
Josh Smith22-Jun-06 7:52 
Questionhow to refresh or keep the graphics Pin
donkaiser22-Jun-06 6:37
donkaiser22-Jun-06 6:37 
AnswerRe: how to refresh or keep the graphics Pin
Dustin Metzgar22-Jun-06 6:49
Dustin Metzgar22-Jun-06 6:49 
GeneralRe: how to refresh or keep the graphics Pin
donkaiser22-Jun-06 7:05
donkaiser22-Jun-06 7:05 
GeneralRe: how to refresh or keep the graphics Pin
Dustin Metzgar22-Jun-06 7:33
Dustin Metzgar22-Jun-06 7:33 
AnswerRe: how to refresh or keep the graphics Pin
atuldeore22-Jun-06 7:16
atuldeore22-Jun-06 7:16 
QuestionA program to organize and fix data. Pin
Noah Moerbeek22-Jun-06 5:38
Noah Moerbeek22-Jun-06 5:38 
Hi,

I am working on a little project right now and I need a little help getting started. I have an access database that is a giant mess with disorganized fields, data put in the wrong places etc.

What I want to be able to do is organize the data, export the new data to either a CVS file or some other readable file and put the garbage in a seperate notes feild. Then import all of the new data into an organized Access database. The problem is of course that the data is not organized and I thought it would be a fun project that could be usefull to other people. Also their is some redundancy in the database I would like to eliminate and sometimes abbreviations are not consistent.

I was wondering if this would be the best way of doing it (or even if I could complete the project this way)

Create An application to load the Access Database

Be able to search within the fields of information and replace inconsistent abbreviations with the one I that i have picked (I of course will have to allow the user to change this input per column) and delete what it is replacing.

Can I use a string split to create tokens to bust up the different data in some way and then reorder it in a specefic order.

Is it possible to have something that reads Agoodkid Johnny Smith

bust it up then reorder it to be Smith Johnny A goodkid and then have it proceed onto the next one that maybe even more messed up like 8989879RobCell Robert Smith

I had planned to use Regular Expressions but sense the data is not consistent in the way it is structured is it still possible to do this.

Would it be more advisable to tokenize all of the data just by cutting it up into pieces, saving it in some way (although I am not sure how I would do that) export all of the data to an XML file, tear it apart, then just call different parts of it in the right order based upon just querying on the XML document.

In summary after that somewhat confusing text

What would be the best method of fixing a very disorganized database by creating a utility to correctly order, change, edit and export the data into a new table (or data source of some kind)?

QuestionSelecting leaf node directly !!! Pin
ankushmn22-Jun-06 4:57
ankushmn22-Jun-06 4:57 
AnswerRe: Selecting leaf node directly !!! Pin
Dustin Metzgar22-Jun-06 5:07
Dustin Metzgar22-Jun-06 5:07 
QuestionIIS and Active directory Pin
engsrini22-Jun-06 4:52
engsrini22-Jun-06 4:52 
QuestionZip file creation in C# Pin
coolestCoder22-Jun-06 4:28
coolestCoder22-Jun-06 4:28 
AnswerRe: Zip file creation in C# Pin
Judah Gabriel Himango22-Jun-06 4:42
sponsorJudah Gabriel Himango22-Jun-06 4:42 
QuestionWIA and TakePicture Pin
(Steven Hicks)n+122-Jun-06 4:07
(Steven Hicks)n+122-Jun-06 4:07 
Questionhow to attach file using html file field Pin
ayyp22-Jun-06 3:43
ayyp22-Jun-06 3:43 
Questionserial port data read error ? help please ... Pin
cmpeng3422-Jun-06 3:33
cmpeng3422-Jun-06 3:33 
AnswerRe: serial port data read error ? help please ... [modified] Pin
Judah Gabriel Himango22-Jun-06 4:20
sponsorJudah Gabriel Himango22-Jun-06 4:20 
GeneralMessage Closed Pin
25-Jun-06 22:33
cmpeng3425-Jun-06 22:33 
GeneralRe: serial port data read error ? help please ... Pin
Judah Gabriel Himango26-Jun-06 4:17
sponsorJudah Gabriel Himango26-Jun-06 4:17 
QuestionHow to convert blocking socket to non blocking Pin
Shajeel22-Jun-06 3:17
Shajeel22-Jun-06 3:17 
AnswerRe: How to convert blocking socket to non blocking Pin
Judah Gabriel Himango22-Jun-06 4:19
sponsorJudah Gabriel Himango22-Jun-06 4:19 
QuestionCreating C# files Pin
tom groezer22-Jun-06 2:31
tom groezer22-Jun-06 2:31 
AnswerRe: Creating C# files Pin
Judah Gabriel Himango22-Jun-06 4:17
sponsorJudah Gabriel Himango22-Jun-06 4:17 
GeneralRe: Creating C# files Pin
tom groezer24-Jun-06 4:31
tom groezer24-Jun-06 4:31 
AnswerRe: Creating C# files Pin
atuldeore22-Jun-06 6:06
atuldeore22-Jun-06 6:06 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.