another regular expression question

[abaker83]

Hey guys,
I am new to regex, and don't know much about patterns.I am trying to match data on a specific line; believe it or not this is all on one line "P57_20711. txt 0000666 0000000 0000000 00012074176 0 Vcar H57002007102120 DOE CM1956904710 00. 200711012007113 0 00000.00 00000.00 00168 " I am trying to remove everything from the letter "P" to "Vcar" including spacing and begin the line at the "H". I hear that the best way to do it is using regular expressions Any ideas?
Thanks

[AHMEDYO]

HI...

i cant understand you question fully , you just wanna to remove data from P to vcar and just you will have these characters

H57002007102120 DOE CM1956904710 00. 200711012007113 0 00000.00 00000.00 00168

waiting your reply..


GOOD LUCK

[9815402440]

hi
please write the output you want from the code. this will help understanding the problam.

regards
manpreet singh dhillon hoshiarpur

[Killer42]

Does the location of the desired data within the line vary? If not, you can just use Mid() or Right() function to grab it. If it does move, you can probably still do it almost as simply by using Instr() function to find your flag string ("Vcar") then either of the abovementioned functions to retrieve the rest of the line.

I expect there may be a way to use regular expressions for this as well, but don't have any experience with them. (Seems like unnecessary complication, too.)