Find string VB.NET

Question

I have a text file with multiple different items that I need to grab from it.

Here is portion of the text file:

JOB_NUMBER                      XXXX-XX              TYPE: String               
                                                     SOURCE: User-Defined       
                                                     ACCESS: Full               
                                                     DESIGNATED: NO             
                                                     DESCRIPTION:               

CUSTOMER                        SAMPLE COMPANY       TYPE: String               
                                                     SOURCE: User-Defined       
                                                     ACCESS: Full               
                                                     DESIGNATED: NO             
                                                     DESCRIPTION:               

OVERBURN                        5.500000e-03         TYPE: Real Number          
                                                     SOURCE: User-Defined       
                                                     ACCESS: Full               
                                                     DESIGNATED: NO             
                                                     DESCRIPTION:

I need to find the string with JOB_NUMBER in it and grab the number "XXXX-XX" same with "CUSTOMER" but that will be a string not an integer.

This cannot be done by line number because it will be different every time.

Any suggestions would be very helpful

NeverHopeless · Accepted Answer · 2012-11-13 09:38:47Z

1

You should also look at here.

Another example

answered Nov 13, 2012 at 9:38

NeverHopeless

11.2k4 gold badges37 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Steve · Accepted Answer · 2012-11-07 18:14:03Z

1

Is there only going to be 1 job number and one customer string in each file? If yes you could read the file to a string and extract like so:

Dim thefile As String = IO.File.ReadAllText("C:\test.txt")
Dim jobnumber As String = Split(Split(thefile, "JOB_NUMBER")(1), "TYPE:")(0).Trim()
Dim customer As String = Split(Split(thefile, "CUSTOMER")(1), "TYPE:")(0).Trim()

edited Nov 7, 2012 at 18:14

answered Nov 7, 2012 at 18:08

Steve

20.5k5 gold badges47 silver badges71 bronze badges

Comments

Bradley Thomas · Accepted Answer · 2012-11-07 17:50:44Z

0

If those are fixed width columns, simply find the lines that begin with JOB_NUMBER and CUSTOMER and substring out the middle column, then trim the spaces.

answered Nov 7, 2012 at 17:50

Bradley Thomas

4,1076 gold badges36 silver badges58 bronze badges

Collectives™ on Stack Overflow

Find string VB.NET

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related