I want to read particular string from a text file and store them in Excel sheets

My Text file Contains line like this

FLTR TID: 0000003756 RPC ID: 0000108159 USER: Remedy Application Service

FLTR TID: 0000003756 RPC ID: 0000108159 USER: Remedy Application Service

FLTR TID: 0000003756 RPC ID: 0000108159 USER: ibsdr

FLTR TID: 0000003756 RPC ID: 0000108159 USER: Vinay.k@in.uni.com

FLTR TID: 0000003756 RPC ID: 0000108159 USER: Vinay.k@in.uni.com

FLTR TID: 0000003756 RPC ID: 0000108159 USER: wsdl

FLTR TID: 0000003756 RPC ID: 0000108159 USER: stefan.hummel@uni.com

I want to store highlighted words in Excel sheets in columns wise and i want to store only unique user names.. like:



1..................Remedy Application Service





This is what I have tried

public class User


    static HSSFWorkbook hwb=new HSSFWorkbook();

    static HSSFSheet sheet = hwb.createSheet("new sheet");

    static HSSFRow rowhead= sheet.createRow((short)0);

    static HSSFRow row= sheet.createRow((short)1);

    static int count=1;

    public static void main(String[]args)



            rowhead.createCell((short) 0).setCellValue("SNo");

            rowhead.createCell((short) 1).setCellValue("USER NAME");

            BufferedReader br=new BufferedReader(new FileReader("filter.log"));

            String str=null;

            String user=null;





                    user=str.substring(48,75);   // This is to get user names





            FileOutputStream fileOut = new FileOutputStream("D:/Excel.xls");



            System.out.println("Your excel file has been generated!");


        catch ( Exception ex )

        { System.out.println(ex);



    private static void store(String user,int count)


        row.createCell((short) 0).setCellValue(count);

        row.createCell((short) 1).setCellValue(user);





17963......Remedy Application Service

in this whenever I execute this program only first value is getting stored rather all values stores.. and I want to store only UNIQUE user names in this Excel sheet..

please help me , thanks in advance


  • For Unique Names you can Use ArrayList<String> add whenever new UserName appears add and before that check whether user exist in arrayList or not (by the Use of contains("UName")) and than proceed.
  • Use String username=line.substring(line.lastindexOf(":")).trim(); or You can use line.split(":")[1].trim();

For Excel row creation you can use loop.

int i=0;
row = sheet.createRow((short) i);
cell = row.createCell(i);
cell.setCellValue("UserName");//Set UserName after getting it from 'str'

First off, I am not an expert and have never tried this myself nor can I at the moment. From looking at your code I can spot a few design flaws that might be the reason for your problem.

You only ever declare one row:

static HSSFRow row= sheet.createRow((short)1);

This means that in your store method, the same row's cells will be written again and again. What you are missing is the logic to create a new row if a unique name is encountered. For this task, may I suggest using a Set preferably one operating on hashes for the benefit of low lookup time, and storing all unique names in there? That way you can use a simply contains query.

Furthermore, your countvariable is off and starts counting at 2, not at one. Initialise it to 0 or increment it after its use.

Some pseudocode:

private HashSet<String> names = new HashSet<>();
// More fields here.

// Now start in your if clause:
if(str.contains("FLTR" && !names.contains(str.substring(48))
    store(user, count);

// More of your code.

private static void store(String user, int count)
    // Create new row
    HSSFRow row = sheet.createRow((short)rowCount);

    row.createCell((short) 0).setCellValue(count);
    row.createCell((short) 1).setCellValue(user);

Need Your Help

Is it possible to reference custom code in the Where-clause of Neo4J's Cipher Query Language?

graph nosql neo4j

Is it possible to use Neo4J's Cipher Query language (or another declarative language) but still reference custom code snippets (for instance to do custom WHERE-clauses based on, say, the result of a

Chromecast SDK detects UPnP MediaRenderers because of AllCast

android upnp google-cast chromecast

I have an Android app which controls UPnP MediaRenderers, and I now want to modify it to use Chromecasts too.