The ProgrammersTalk Community
Forum Register Search Today's Posts Mark Forums Read
Register

Go Back   The ProgrammersTalk Community > General Programming > Java


Welcome to the The ProgrammersTalk Community forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact contact us.
Reply
 
LinkBack Thread Tools    Display Modes   
  #1 (permalink)  
Old 03-04-2008, 01:45 PM
nogono nogono is offline
Novice
Join Date: Jul 2007
Posts: 35
iTrader: (0)
nogono is on a distinguished road
Concatenation

File1:

PID Name City

10 Larry LA
11 Man NY
15 Lan SF

File 2:

PID No ZIP

15 7271 90032
10 8281 9547
22 9213 4321

Question:
I want to concatenate the data of these two files.Like if File1 has PID same as File 2 PID the data should be concatenated like this....
egCondition having same PID should be concatenated)
O/P(Should be like this)

PID Name City No ZIP

10 Larry LA 8281 9547
15 Lan SF 7271 90032

How should be the java code for this?

__________________

Digg this Post! Del.Icio.Us this Post! Technorati this Post! Furl this Post! Mister Wong this Post! Newsvine this Post! Spurl this Post! Reddit this Post! Netscape this Post!
Reply With Quote
  #2 (permalink)  
Old 03-04-2008, 08:22 PM
ccoonen ccoonen is offline
PT Staff
Awards Showcase
Quality Tutorial Quality Tutorial Quality Tutorial Quality Tutorial 
Total Awards: 4
Join Date: Jun 2007
Location: Wisconsin
Posts: 308
iTrader: (0)
ccoonen is on a distinguished roadccoonen is on a distinguished roadccoonen is on a distinguished roadccoonen is on a distinguished road
I would import this data into two tables in a database, then just run queries joining the PID's
Reply With Quote
  #3 (permalink)  
Old 03-04-2008, 09:23 PM
HelloWorld's Avatar
HelloWorld HelloWorld is offline
Programming Expert
Awards Showcase
Quality Tutorial 
Total Awards: 1
Join Date: Jun 2007
Location: In front of computer...
Posts: 1,111
iTrader: (0)
HelloWorld will become famous soon enoughHelloWorld will become famous soon enoughHelloWorld will become famous soon enough
Well, you need to read from both files.. check from one string and compare it with the other one, and if they're the same, then write it once on the other file... basically, just create a new file based on these two files... compare them line by line.. or however you want to implement it..

if you don't want the two files to exists, you can delete them too I don't see it difficult to be implemented..

__________________
PHP Code:
System.out.println("Hello World!"); 

Digg this Post! Del.Icio.Us this Post! Technorati this Post! Furl this Post! Mister Wong this Post! Newsvine this Post! Spurl this Post! Reddit this Post! Netscape this Post!
Reply With Quote
  #4 (permalink)  
Old 05-30-2008, 08:04 AM
itgalary's Avatar
itgalary itgalary is offline
Novice
Join Date: May 2008
Posts: 3
iTrader: (0)
itgalary is on a distinguished road
Need to read both file and compair.. But i think converting to array, sorting and then applying some logic and make things easier.. have to know if its a one to one relation or 1-many??

__________________
Free Programming help http://www.itgalary.com
Free World Tourism http://maps.itgalary.com

Digg this Post! Del.Icio.Us this Post! Technorati this Post! Furl this Post! Mister Wong this Post! Newsvine this Post! Spurl this Post! Reddit this Post! Netscape this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

   Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -7. The time now is 01:08 PM. Powered by vBulletin
Copyright © 2000 - 2007, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO © 2007 ProgrammersTalk Sedo - Buy and Sell Domain Names and Websites project info: programmerstalk.net Statistics for project programmerstalk.net etracker® web controlling instead of log file analysis


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50