vba help - extract value from text

[Mallesh23]

Hi Team,

Below is my data in txt file,
Task is Copy Currency, Period and Buy Type: if nothing is mentioned infront of it Consider (zero value)

There are around 200 lines of data , I have to find and get value.


These 3 lines are sample from txt file , Ignore Blank lines
Currency : USD Period : ABC+PQR Buy Type: Manual

Currency : INR Period : ABC+PQR Buy Type:
Currency : AUD Period : -------- Buy Type: AAA,BBB CCC DDD HHH


Below is expected Value

Currency	Period	Buy Type
USD	ABC+PQR	Manual
INR	ABC+PQR	0
AUD	--------	AAA,BBB CCC DDD HHH

Thanks
mg

 

[Mallesh23]

Hi Danteamor,

Thanks a lot, it worked as per my Requirement. ?


Thanks
mg

 

[DanteAmor]

Hi Danteamor,
Thanks a lot, it worked as per my Requirement. ?
Thanks
mg

I'm glad to help you. Thanks for the feedback