Forum Discussion
Read a list of Node Name and its software name, then find the next Node Name
Hi, Newbie here....I have a question. What's the best way to read from a txt file that contains a list of Node Name and its Software Name, set it in a column1.....then reads the next Node Name a...
Excel has built in command DATA then Get External data,, allows to import data from Text file also, where every record must be in a Row, and either separated by Space or Comma.
I know that feature, but since my dataset is on a one long column without any separated commas, how can I set it into cols and rows per Node Name is the question.
How do we know that the text in one row is node name and in another one is software name? Perhaps you may share small sample file to illustrate.
- The text will say "Node Name: Server1"...etc, same goes for Software Name: nameofsw in front it. These are probably the keywords you're after?
