Oracle SQL: Extracting text between two characters

I had similar kind of Requirement which was we have to display text only occurs in between colon and hypen (":" and "-") so I used below line which worked successfully 

    LTRIM(RTRIM(TRIM (BOTH ':' FROM REGEXP_SUBSTR({fieldname}, ':[^-]+'))))

Example line

**Computer, Internet & Software: Atlassian - Business Software**

then the ouctcome was

**Atlassian** 

this Formula i have used inside a saved search result in NetSuite Environment 

Suite Cloud IDE Download / Install in eclipse

SuiteCloud itself is available through an Eclipse update site. The plugin is installed as any other Eclipse plugin:
1. Open Help > Install New Software…
2. Click Add…, set Name to “SuiteCloud IDE” and set Location to
http://system.netsuite.com/download/ide/update; click OK.
3. Once the list of plugins populates, select the SuiteCloud node and click Finish


ref : http://blog.erpguru.com/2012/05/how-i-survived-suiteworld-2012.html