Thread: Manipulating Strings in a File Scanner

I was given a text file that has list of names phone numbers, calls in and out ect... Like this

Adams#Marilyn#8233331109#0#0#01012014#C
Anderson#John#5025559980#20#15#12152013#M
Baker-Brown#Angelica#9021329944#0#3#02112014#C

The # are delimiters between data items and each line has the call status as the last item. I need to know how I can display each persons information on the screen in a format such as:

Name Phone Calls Out Calls In Last Call

Marilyn Adams (823) 333-1109 0 0 01-01-2104
John Anderson (502) 555-9980 20 15 12-15-2013
Angelica Baker-Brown (859) 254-1109 11 5 02-11-2014

I have to use substring method to extract the phone number and add parentheses/dashes ect I also must have a while statement and a delimiter...

So Far my code looks like this Also I am in a beginners Java coding class....

import java.util.Scanner;
import java.io.*;
 
public class phonedata2_1
{
  public static void main (String[] args) throws IOException
  {
 
   String Phonefile, FirstName, LastName;
   Scanner PhoneScan, fileScan;
 
   System.out.println ("    Name      Phone      Calls Out       Calls In       Last Call           Status");
 
   fileScan = new Scanner(new File("phonedata.txt"));
 
   while (fileScan.hasNext())
   {
Phonefile = fileScan.nextLine();
 
    PhoneScan = new Scanner(Phonefile);
    PhoneScan.useDelimiter("#");
 
System.out.println(PhoneScan.next()+" "+
PhoneScan.next()+"\t" +
PhoneScan.next()+"\t" +
PhoneScan.next()+"\t" +
PhoneScan.next()+"\t" +
PhoneScan.next()+"\t" +
PhoneScan.next());
}
   System.out.println ("\nTotal outgoing calls for the period: " + "\nTotal incoming calls    for the period: \n");
 
   }
}

Welcome to the Forum! Thanks for taking the time to learn to post code correctly, and if you haven't already, please read this topic to see other useful info for newcomers.

What's your question? What do you need help with?

Remember that class names are capitalized while variable and method names begin with lowercase letters. Not following this convention makes your code more difficult to read and understand.

Have you reviewed the substring() method in the String API? You might also look at the charAt() method while you're there.

I just need to know how I can take information from a File, which I have attached In my above post, then while using a delimiter grab the phone numbers and substring them to become (###)###-#### in that format.

I have the File in my Java editor and I even have the delimiter working. But I can not figure out how to use a substring to edit the phone numbers.

Adams#Marilyn#8233331109#0#0#01012014#C
Anderson#John#5025559980#20#15#12152013#M
Baker-Brown#Angelica#9021329944#0#3#02112014#C

This needs to look like

Marilyn Adams (823) 333-1109 0 0 01-01-2104
John Anderson (502) 555-9980 20 15 12-15-2013
Angelica Baker-Brown (859) 254-1109 11 5 02-11-2014

Which I am half way there its the substring I keep getting caught up on since its pretty much in a file and I dont understand how I can make that phone number a string to do that with.

In the first post you said you had to use the substring() method, now I'm not so sure that you have to use substring() and that you're really asking for the best approach to accomplish what you need to do using a delimiter. If you can, I recommend you use the String.split() method.

Clarify your requirements. In future, only include solutions that you must use to give us the freedom to guide you to other solutions that might be better than what you've chosen.