how to retrieve a specific value from a text file with visual basic in excel

katia 1 Reputation point
2020-06-26T16:41:02.953+00:00

Dear all,

I have a text file from which I want to retrieve a specific value from a specific line. Let's say that my text file with many lines out of which I am interested in specific data for example:

clusters, rings

tik = B01

sep = C01, G1

shades, colors

1) I want to retrieve the value which comes from the line that starts with #tik after =. So I want only B01. How can I get it?
2) And if I want the value after the comma from the line that starts with #sep (ie G1), how can I get it as well?

Thank you in advance,
Katia

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,618 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Anonymous
    2020-06-26T17:43:25.277+00:00

    Excel is not currently supported here on QnA. They're actively answering questions in dedicated forums here.
    https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-msoffice_custom
    https://social.technet.microsoft.com/Forums/office/en-US/home?forum=excel
    https://social.msdn.microsoft.com/Forums/Lync/en-US/home?forum=exceldev

    --please don't forget to Accept as answer if the reply is helpful--


    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows Server] Datacenter Management

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.

    0 comments No comments