In the absence of field delimiters you need to make use of the structure of your data.

In this case is the Product ID always an integer? Is the cost always a single word ( [\w\d]+ )? and is the Product type a single word?

Without some such pattern, a general solution, may not be possible.