Search results for query: *

That is great - it works brilliantly! Now how does it work?!? (I think) I get the Splitting the field at the ", but where does the [2] and [4] come in to it (something to do with arrays)? How does it know where to stop? Thanks again.

OK, I got the first piece working by chucking some brackets around it. But it is now producing inconsistent results as it variously extracts the full remaining line of text (looks like if the quoted data isn't only a number) or stops when it gets to a space, or stops partway through a word...

Thanks for your help. Piece two works great, but for piece one I get an error: "Start position is less than 1 or not an integer

In CR10, is it possible to extract particular parts from a string? I am trying to build a report that shows CIs that have changed location on our CMDB using the history line that is created when the field is updated which reads like: Room No. from "4" to "6". or Room No. from "56" to "Store"...