Opening the Text field link in a new tab obiee

Summary:

In OBIEE , I have a text field and which contains a URL. I made it to clickable from data format. When we choose the data format as html hypertext it started working as link

Now here when I click on this link it is opening in the same page , how can we make it to open in a new window?

Content (please ensure you mask any confidential information):

am not using the action links because , this link we are generation based on another field , so there are multiple different links and they have parameters so that is why we have created a text and generating and then the field we are using in obiee.