vba regular expression - left and mid value

[Mallesh23]

Hi Team,

Please suggest Regular expression Pattern Just for learning purpose

after split I can get it. its just for learning purpose. Can someone assist thanks.



1) Find Company_Name always comes left side of Company. --------- expected AAABB
AAABB Company


2)1) Find Currency and Product. expected USD and LAPTOP

xxx LAPTOP USD 'Situation 1 -------------->
LAPTOP USD 'Situation2


Thanks
mg

 

[Mallesh23]

Hi Peter,

Right , Consider Just left of it. if multiple first left value. thanks.


Thanks.
mg

 

[Zot]

Hi Peter,

Right , Consider Just left of it. if multiple first left value. thanks.


Thanks.
mg

Just like @Peter_SSs said. to get the universal solution, you need to supply samples of data so that helpers know the ultimate solution. ?