java program for reading delimited txt file to excel sheet

[rsn64]

Hi,

I need help for a specific requirement.

I have some .txt files these contain delimited data, delimiter is the pipe (||) operator.

Sample data

Upadate
Color||blue
size||6
size||7
size||8
type||cleats
EOR

Every record set start with update which tells the beginning of record set and ends with EOR (End of record). The data is between these two. The property name first then pipe operator and then data.

I am looking for a help to read this txt file by java program and put this to excel sheet. THere I can make modifications to data manually and then want to read it to txt file back.

Require help on this.

Thanks

[Norm]

What part(s) of your program are you having trouble with?
If you are reading a simple text file, you could use the Scanner class.
To separate the records at the "||" separator boundary, you could use the String indexOf method to find the || and the use substring.

[rsn64]

I have no clue about the approach I should take for this IO operation.

Can you please suggest me a little detailed approach in getting started with the implementation.

Really appreciate your discussion below.

Thanks

[Norm]

Do a Search on this forum for uses of the Scanner class. There are several that read files.