Ad:

Java Discussion Thread
Marked Solved
Views: 9306

Page 1
2
Next

You are currently viewing page 1 of this multi-page discussion thread

Jul 4th, 2006

breaking up a String... (a bit more advance)

Expand Post »

Hello everyone!

Any help would be much appreciated!

My problem:

I want to break up a string into separate objects.

Scenario:

I am reading a txt file into my program and I want to
separate the String in to separate categories.

String line = "BATHROOM TOI 48157 Y DOVE BWASH MCDAMIA 375ML 6 NEW" ;

Java Syntax (Toggle Plain Text)

 String line = "BATHROOM TOI    48157   Y   DOVE BWASH MCDAMIA 375ML             6  NEW" ;

to

String category = "BARTHROOM TOI" ;
String sku = "48157" ;
String tmp = "Y" ;
String description "DOVE BWASH....." ;
etc..
etc...

Any help would be much appreciated

Andy.

outbackandy

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

5 posts
since Jul 2006

Permalink

Jul 4th, 2006

Re: breaking up a String... (a bit more advance)

Looking at your string I assume that the different parts of the string are
seperate4d by a TAB character. If so do the following:

Java Syntax (Toggle Plain Text)
String line = "BATHROOM TOI    48157   Y   DOVE BWASH MCDAMIA 375ML             6  NEW" ;
String[] parts = line.split("\\t");
//parts[0] = "BATHROOM TOI";
//parts[1] = "48157";
// etc. etc
String line = "BATHROOM TOI    48157   Y   DOVE BWASH MCDAMIA 375ML             6  NEW" ;
String[] parts = line.split("\\t");
//parts[0] = "BATHROOM TOI";
//parts[1] = "48157";
// etc. etc

masijade

Moderator

Reputation Points: 1471

Solved Threads: 490

Industrious Poster

Offline

4,043 posts
since Feb 2006

Permalink

Jul 4th, 2006

Re: breaking up a String... (a bit more advance)

Quote originally posted by masijade ...

Looking at your string I assume that the different parts of the string are
seperate4d by a TAB character. If so do the following:
Java Syntax (Toggle Plain Text)
String line = "BATHROOM TOI    48157   Y   DOVE BWASH MCDAMIA 375ML             6  NEW" ;
String[] parts = line.split("\\t");
//parts[0] = "BATHROOM TOI";
//parts[1] = "48157";
// etc. etc
String line = "BATHROOM TOI 48157 Y DOVE BWASH MCDAMIA 375ML 6 NEW" ; String[] parts = line.split("\\t"); //parts[0] = "BATHROOM TOI"; //parts[1] = "48157"; // etc. etc

Gee thanks mate, that's pretty close. For the moment I'm now using two separated spaces i.e. line.split(" ") instead of your tab idea - which by the way has given me a GREAT starting point. The data is unfortunately not separated by tabs.
Thank dude!!!

- AB

outbackandy

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

5 posts
since Jul 2006

Permalink

Jul 5th, 2006

Re: breaking up a String... (a bit more advance)

No problem. And have fun.

masijade

Moderator

Reputation Points: 1471

Solved Threads: 490

Industrious Poster

Offline

4,043 posts
since Feb 2006

Permalink

Jul 5th, 2006

Re: breaking up a String... (a bit more advance)

This is a rough draft solution to tha problem. (if your are inferested) Thanks for your help!

Java Syntax (Toggle Plain Text)
 String description = null ;
        String cat = null ; 
        String sku = null ; 
        String temp = null ; 
        String qty = null ;
        String newLine = null ; 
 
 
        ArrayList list = new ArrayList() ;
        // different combinations. 
        String line = "BATHROOM TOI     48157   Y   DOVE BWASH MCDAMIA 375ML             6  NEW" ;
       //String line = "DEODORANTS       9609       REXONA R/ON 50ML ICE COOL            6" ;
       // String line = "FRAGRANCE       16696   Y   CK ESCAPE EDP 30ML                   2" ;
       // String line = "DEODORANTS       9609       REXONA R/ON 50ML ICE COOL            6  NEW" ;
        String[] parts = line.split("  ");
        for (int i=0; i < parts.length ; i++) {
            if (parts[i].length() != 0) {
                 list.add(parts[i]) ;
            }            
        }
 
        // remove surounding white space - if any
        for (int i=0; i< list.size() ; i++) {
            String ob = (String) list.get(i) ;
            ob = ob.trim() ;
            if (ob.charAt(0) == ' ') {
                int finish = ob.length() ;
                String newString = ob.substring(1, finish);
                ob = newString ;
            }
        list.remove(i);
        list.add(i,ob);      
 
        switch (i) {
            case 0:  cat = ob ; break ; 
            case 1:  sku = ob ; break ;
            case 2: {
                if (ob.equalsIgnoreCase("Y")){
                    temp = "Y" ;
                } 
                else  {
                    description = ob ;                    
                }
 
            }  break ;
 
            case 3: {
                if (description == null) {
                    description = ob; 
                }
                else {
                    qty = ob ;
                }                    
            } break ;
            case 4: {
                if (qty == null) {
                    qty = ob ;
                }
                else if (ob.equalsIgnoreCase("NEW")) {
                    newLine = ob ; 
                }
            } break ; 
            case 5: {
                if (ob.equalsIgnoreCase("NEW")) {
                    newLine = ob ; 
                }
            } break ; 
 
 
        } // end swith
 
        } // end for i
        System.out.println(line);
        System.out.println("");
        System.out.println("Cat: " + cat);
        System.out.println("Sku:" + sku);
        System.out.println("Temp " + temp);
        System.out.println("Description:" + description);
        System.out.println("Qty: " + qty);
        System.out.println("NewLine: " + newLine);
 String description = null ;
        String cat = null ; 
        String sku = null ; 
        String temp = null ; 
        String qty = null ;
        String newLine = null ; 
        
        
        ArrayList list = new ArrayList() ;
        // different combinations. 
        String line = "BATHROOM TOI     48157   Y   DOVE BWASH MCDAMIA 375ML             6  NEW" ;
       //String line = "DEODORANTS       9609       REXONA R/ON 50ML ICE COOL            6" ;
       // String line = "FRAGRANCE       16696   Y   CK ESCAPE EDP 30ML                   2" ;
       // String line = "DEODORANTS       9609       REXONA R/ON 50ML ICE COOL            6  NEW" ;
        String[] parts = line.split("  ");
        for (int i=0; i < parts.length ; i++) {
            if (parts[i].length() != 0) {
                 list.add(parts[i]) ;
            }            
        }
        
        // remove surounding white space - if any
        for (int i=0; i< list.size() ; i++) {
            String ob = (String) list.get(i) ;
            ob = ob.trim() ;
            if (ob.charAt(0) == ' ') {
                int finish = ob.length() ;
                String newString = ob.substring(1, finish);
                ob = newString ;
            }
        list.remove(i);
        list.add(i,ob);      
        
        switch (i) {
            case 0:  cat = ob ; break ; 
            case 1:  sku = ob ; break ;
            case 2: {
                if (ob.equalsIgnoreCase("Y")){
                    temp = "Y" ;
                } 
                else  {
                    description = ob ;                    
                }
                
            }  break ;
            
            case 3: {
                if (description == null) {
                    description = ob; 
                }
                else {
                    qty = ob ;
                }                    
            } break ;
            case 4: {
                if (qty == null) {
                    qty = ob ;
                }
                else if (ob.equalsIgnoreCase("NEW")) {
                    newLine = ob ; 
                }
            } break ; 
            case 5: {
                if (ob.equalsIgnoreCase("NEW")) {
                    newLine = ob ; 
                }
            } break ; 
            
            
        } // end swith
        
        } // end for i
        System.out.println(line);
        System.out.println("");
        System.out.println("Cat: " + cat);
        System.out.println("Sku:" + sku);
        System.out.println("Temp " + temp);
        System.out.println("Description:" + description);
        System.out.println("Qty: " + qty);
        System.out.println("NewLine: " + newLine);

outbackandy

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

5 posts
since Jul 2006

Permalink

Jul 7th, 2006

Re: breaking up a String... (a bit more advance)

Is each data chunk given a certain amount of space to be written in and just filled in with blank spaces to pad a smaller value?

Phaelax

Reputation Points: 92

Solved Threads: 51

Practically a Posting Shark

Offline

856 posts
since Mar 2004

Permalink

Jul 7th, 2006

Re: breaking up a String... (a bit more advance)

no it's really all random information, but the space between the data is at least two blank spaces between them.

The information is being read from a txt file that was cut and pasted from an email.

AB

outbackandy

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

5 posts
since Jul 2006

Permalink

Jul 9th, 2006

Re: breaking up a String... (a bit more advance)

well split() does take a regular expression, so why not just use that?

It looks for 2 or more spaces to be the delimiter.

Java Syntax (Toggle Plain Text)
        String s = "BATHROOM TOI    48157   Y   DOVE BWASH MCDAMIA 375ML             6  NEW" ;
        String[] tokens = s.split(" {2,}?");
 
        for(int i=0; i<tokens.length; i++)  
            System.out.println(tokens[i]);
        String s = "BATHROOM TOI    48157   Y   DOVE BWASH MCDAMIA 375ML             6  NEW" ;
        String[] tokens = s.split(" {2,}?");
 
        for(int i=0; i<tokens.length; i++)  
            System.out.println(tokens[i]);

Last edited by Phaelax; Jul 9th, 2006 at 10:43 pm.

Phaelax

Reputation Points: 92

Solved Threads: 51

Practically a Posting Shark

Offline

856 posts
since Mar 2004

Permalink

Jul 9th, 2006

Re: breaking up a String... (a bit more advance)

Thanks everyone for your help.

AB

outbackandy

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

5 posts
since Jul 2006

Permalink

Jul 15th, 2006

Re: breaking up a String... (a bit more advance)

use String Tokenizer

N[e]tt[e]

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

18 posts
since Feb 2005

Page 1
2
Next

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

This thread is currently closed and is not accepting any new replies.

Previous Thread in Java Forum Timeline: new/help

Next Thread in Java Forum Timeline: Java Interpreter: LET Statement

DaniWeb Message

Cancel Changes

User Name
Password