This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Use Text to Columns tool with the delimiter set to \n (the reference for the newline character) and configure the tool to split to rows instead of columns. That will take care of the first request.
To eliminate the bracketed text, here's an expression that can be used in a Formula tool on the [Asset] field: The idea is that it identifies the brackets (and anything between) and replaces it with nothing, effectively removing it.