How to extract values from text file?

Plareput

New member
Hi Everyone,

I am having data like this in text file.

values of D Code and Eff Date and all the CODE TITLE Hiring Rate *** Incumbent Rate Max Hiring Rate *** Incumbent Rate Max.
can someone help me on this?

UNIT: AC
D CODE: 129
UNION: DC 37
EFF DATE: October 26, 2019
TITLE
CODE TITLE Hiring Rate *** Incumbent Rate Max Hiring Rate *** Incumbent Rate Max
03739, 40510 Accountant * $48,755 $56,068 $87,000 $50,217 $57,750 $89,610
405100 Accountant * $44,104 $50,720 $87,000 $45,428 $52,242 $89,610
09521 Accountant (JOP) $48,755 $56,068 $66,247 $50,217 $57,750 $68,234
40731 Actuarial Specialist Level I $44,104 $50,720 $87,000 $45,428 $52,242 $89,610
40731 Actuarial Specialist Level I-A $44,104 $50,720 $109,022 $45,428 $52,242 $112,293
40710 Actuary ### $44,104 $50,720 $66,247 $45,428 $52,242 $68,234
 

EASCalumMuir

Moderator
Staff member
Hi there,

You can split this string up and assign various values to achieve what you want. Hopefully this will help...

D CODE:
FirstAssign = Split(strText, "D CODE: ")(1)
SecondAssign = Split(FirstAssign, "UNION")(0)

EFF DATE:
FirstAssign = Split(strText, "EFF DATE: ")(1)
SecondAssign = Split(FirstAssign , "TITLE")(0)

The end result will be SecondAssign in each case.

And so on...
 
Top