Need to turn the data in DATA into three columns Ticker Bid Ask with the conditions given using regex. Having some trouble with the punctuation
You don't have a good pattern in the data to make the REGEX expression without multiple expressions. You may need to use 1 or more the tools. You also could remove the punctuation by using the Find and Replace tool and replace the punctuation with '' nothing. Then use the spaces and dash to create an expression. Either way, due to the lack of consistent pattern you'll need to use several tools to correctly parse it out.
Makes sense. Any help you can give on using Regex for the first row?