It should just be a matter of nested find, mid, left and or right calcs as long as there is a 100% consistent way to get to the None noted part of the string. If "ariel" always precedes it then part of your calc will be to use find "ariel" then a mid calc off of that result. If you can provide an example couple of actual strings I could work it out.
Basically the string is going to be in the same format as in the example all the HTML tags are going to be the same. Just the Bold part is going to change (which is what I require to extract).
Rahul, Sorry I'm not familiar with tags or their syntax representation so I struggle with understanding what the tags and format are until I see an actual example.
My requirement is like this:
I have a field with values as
I want the output as
Can it be done?