• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Tim Cooke
  • Jeanne Boyarsky
  • Liutauras Vilda
Sheriffs:
  • Frank Carver
  • Henry Wong
  • Ron McLeod
Saloon Keepers:
  • Tim Moores
  • Frits Walraven
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Piet Souris
  • Himai Minh

How search keywords within Excel/Notepad and save to a varliable JAVA

 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I am working with JAVA
I have an excel file that contains a list of info, For example:


Column A
(ROW 1 ) INFO1
(ROW 2 ) INFO2
(ROW 3 ) INFO3

Column B
(ROW 1 ) MOREINFO1(SomeMoreInfo = Info123) (ExampleInfo=987)
(ROW 2 ) MOREINFO2(SomeMoreInfo = Info456) (ExampleInfo=456)
(ROW 3 ) MOREINFO3(SomeMoreInfo = Info789) (ExampleInfo=123)

What I need is, when user enters the value for Column A; have code to search for Column A and copy whats in Column B in that same row.

(this can also apply in an notepad file that contains the same info, any method that makes is simper is fine)

Or, copy some key words in Column B, such as:

If user enters: INFO1,
I either need:
Row1,ColumnB Value:
MOREINFO1(SomeMoreInfo = Info123) (ExampleInfo=987)

or Keywords:

(SomeMoreInfo,ExampleInfo)
So when user enters: INFO1
I would need:

(Info123,987)

After all this, the results need to be stored in a variable so they can be later send to a .txt file. (The end user dose not need the results)

I hope someone can help me out here, I have been searching everywhere and nothing seems to apply what I need. I might just be over thinking this! not sure! or am in way over my head for my knowledge anyhow, ANY! advice would be greatly appreciated! THANK YOU

I am working with JAVA
 
A day job? In an office? My worst nightmare! Comfort me tiny ad!
the value of filler advertising in 2021
https://coderanch.com/t/730886/filler-advertising
reply
    Bookmark Topic Watch Topic
  • New Topic