₦airaland Forum

I want to develop an application in java which searches special characters in a .CSV, Flat File and Excel sheet. I want an alert once it finds any special characters in these files.Please provide the complete code.

The complete code? 

There's no way You Can get the Complete code, You can only get assistance so pls be specific.

I am using this code to read the txt file.


import java.io.*;
class FileRead
{
public static void main(String args[])
{
try{
// Open the file that is the first
// command line parameter
FileInputStream fstream = new FileInputStream("textfile.txt";
// Get the object of DataInputStream
DataInputStream in = new DataInputStream(fstream);
BufferedReader br = new BufferedReader(new InputStreamReader(in));
String strLine;
//Read File Line By Line
while ((strLine = br.readLine()) != null) {
// Print the content on the console
System.out.println (strLine);
}
//Close the input stream
in.close();
}catch (Exception e){//Catch exception if any
System.err.println("Error: " + e.getMessage());
}
}
}



Which code I have to add to get the alert message that your file contains special characters.

Please help!!!

Good. Now people can step in and help. Note: this is probably not valid Java code but your program should look something like this:

char[] specialXters = { '*', '%', '&', '/', '\' }; //I don't know if this is what you mean by special characters?

while ((strLine = br.readLine()) != null)   
{
      // Print the content on the console
      System.out.println (strLine);

     foreach(char c in strLine)
     {
           int i = 0;
           while(i < 5) //because I have 5 special characters in this example
           {
               if(c == specialXters[i++])
               {
                 System.out.println("Special Character found!";
                 break;
               }
           }
     }
}

Essentially, create an array or list to hold your special characters. For each line you read, iterate over the characters in the line to find if the character occurs in your "special character array", if that happens, alert the user that a special character has been found.

import java.io.*;
class FileRead
{
public static void main(String args[])
{

try{


var iChars = "*|,\":<>[]{}`\';()@&$#%";
for (var i = 0; i < string.length; i++) {
if (iChars.indexOf(string.charAt(i)) != -1){
System.out.println("Characters found";
}


catch (Exception e){
System.err.println("Error: " + e.getMessage());
}


}
}
}

Please let me know what is wrong with the above code.

It is giving some compilation errors.

You did not post the compiler errors? I am not sure there is a var keyword in Java - however, I may be wrong. Looks more like Javascript to me. Try this:

char[] specialXters = {'*', '|', '\', ':', '<', '>', '[', ']', '{', '}', '\', ';', '(', ')', '@', '&', '$', '#', '%'};
int numberOfXters = 19; //about 19 characters in this case

for(char c: strLine)
{
int i = 0;
while(i <   numberOfXters)
{
  if(c == specialXters[i++])
  {
   System.out.println("Characters found";
   break;
  }
}
}

Insert this into your code. I don't do Java though, but I think should work. If you have any problems tell us the compiler error you're getting as well.

good job guys

Very good job. Just a software engineering tip, if you encouter this problem a little often, its better to create a special class (maybe StringProcessor) with static method contains(String s, char[] symbols). You should now read each line of the file using java.util.Scanner(new java.io.File("dataFile.txt".readLine();. (remember to place that in a try block because it throws a couple of exceptions e.g IOException, SecurityException etc) that should return a string. pass that string to the method you created in your StringProcessor class. Implement your contains method as stated above (only that you need some little syntax modification but @IbrahimB's algorithm is okay). I should have uploaded the complete source code but I'm kind'a busy. I hope my explanation helps.