How to find and extract a substring from a string

Question

Question

Ephraim Malane · Oct 6, 2022

I have a string below and I want to read the value of the first href with ObjectScript

String

<table id="tablepress-46" class="tablepress tablepress-id-46" aria-labelledby="tablepress-46-name">
	<tbody class="row-hover">
		<tr class="row-1 odd">
			<td class="column-1">ICD-10 MIT 2021 Excel - 16 March 2021</td>
			<td class="column-2">
				<a href="/wp-content/uploads/2021/04/ICD-10_MIT_2021_Excel_16-March_2021.xlsx">DOWNLOAD</a>
			</td>
		</tr>
		<tr class="row-2 even">
			<td class="column-1">Notice: Additional Emergency ICD10 Codes COVID-19</td>
			<td class="column-2">
				<a href="/wp-content/uploads/2021/04/Notice_-additional-emergency-ICD10-codes_COVID-19.pdf">DOWNLOAD</a>
			</td>
		</tr>
		<tr class="row-3 odd">
			<td class="column-1">ICD-10 MIT 2014 - MS Excel</td>
			<td class="column-2">
				<a href="/wp-content/uploads/2021/02/ICD-10_MIT_2014_Excel_01-Jan-2014.xls">DOWNLOAD</a>
			</td>
		</tr>
		<tr class="row-4 even">
			<td class="column-1">ICD-10 MIT 2014 - Comma Separated Values (CSV)</td>
			<td class="column-2">
				<a href="/wp-content/uploads/2021/02/ICD-10_MIT_2014_CSV_01-Jan-2014.csv">DOWNLOAD</a>
			</td>
		</tr>
		<tr class="row-5 odd">
			<td class="column-1">ICD-10 Master Industry Table Excel File Lay-out</td>
			<td class="column-2">
				<a href="/wp-content/uploads/2021/02/ICD-10_Master_Industry_Table.pdf">DOWNLOAD</a>
			</td>
		</tr>
		<tr class="row-6 even">
			<td class="column-1">ICD-10_MIT_2014 Changes Add Delete Modify 1 Jan 2014</td>
			<td class="column-2">
				<a href="/wp-content/uploads/2021/02/ICD-10_MIT_2014-Changes-Add-Delete-Modify-1-Jan-2014.xls">DOWNLOAD</a>
			</td>
		</tr>
		<tr class="row-7 odd">
			<td class="column-1">HDACC Report 3</td>
			<td class="column-2">
				<a href="/wp-content/uploads/2021/02/hdacc-report-3.pdf">DOWNLOAD</a>
			</td>
		</tr>
		<tr class="row-8 even">
			<td class="column-1">Health Research Briefs: No.9 - 01 July - 30 September 2017</td>
			<td class="column-2">
				<a href="/wp-content/uploads/2021/02/health-research-briefs-no.-9-1-july-30-september-2017.pdf">DOWNLOAD</a>
			</td>
		</tr>
		<tr class="row-9 odd">
			<td class="column-1">Circular No.03 of 2014 Generic Dictionary - The ICD-10 Dictionary</td>
			<td class="column-2">
				<a href="/wp-content/uploads/2021/02/icd-10dictionaryicircularno03of2014.pdf">DOWNLOAD</a>
			</td>
		</tr>
		<tr class="row-10 even">
			<td class="column-1">Circular No.06 of 2014 Validation of Secondary ICD-10 Codes</td>
			<td class="column-2">
				<a href="/wp-content/uploads/2021/02/icd-10codescircularno06of2014.pdf">DOWNLOAD</a>
			</td>
		</tr>
		<tr class="row-11 odd">
			<td class="column-1">ICD-10 Compliance Data Grid</td>
			<td class="column-2">
				<a href="/wp-content/uploads/2021/02/finalcompliancestatisticsgridversion2.xls">DOWNLOAD</a>
			</td>
		</tr>
		<tr class="row-12 even">
			<td class="column-1">Circular No.04 of 2014 Errata: Code Z09.0</td>
			<td class="column-2">
				<a href="/wp-content/uploads/2021/02/icd-10circularno04of2014.pdf">DOWNLOAD</a>
			</td>
		</tr>
		<tr class="row-13 odd">
			<td class="column-1">Circular No.05 of 2014 Inclusion of ICD-10 Codes on Prescription</td>
			<td class="column-2">
				<a href="/wp-content/uploads/2021/02/icd-10circularno05of2014.pdf">DOWNLOAD</a>
			</td>
		</tr>
		<tr class="row-14 even">
			<td class="column-1">Changes to the SA ICD-10 Morbidity Coding Standard Version 6 June 2014</td>
			<td class="column-2">
				<a href="/wp-content/uploads/2021/02/saicd10morbcodingstandvers6jun2014.pdf">DOWNLOAD</a>
			</td>
		</tr>
		<tr class="row-15 odd">
			<td class="column-1">Summary of changes made to the South African ICD-10 Morbidity Coding Standards and Guidelines document</td>
			<td class="column-2">
				<a href="/wp-content/uploads/2021/02/sa_icd-10morbiditycodingstandards.pdf">DOWNLOAD</a>
			</td>
		</tr>
		<tr class="row-16 even">
			<td class="column-1">Alphabetical Index Changes August 2013 final</td>
			<td class="column-2">
				<a href="/wp-content/uploads/2021/02/alphabeticalindexchangesaugust2013final.pdf">DOWNLOAD</a>
			</td>
		</tr>
		<tr class="row-17 odd">
			<td class="column-1">Tabular List Changes May 2014</td>
			<td class="column-2">
				<a href="/wp-content/uploads/2021/02/tabularlistchangesmay2014.pdf">DOWNLOAD</a>
			</td>
		</tr>
		<tr class="row-18 even">
			<td class="column-1">User Guide for the National ICD-10 Master Industry Table for South Africa</td>
			<td class="column-2">
				<a href="/wp-content/uploads/2021/02/cd-10mit_userguide_january2014.pdf">DOWNLOAD</a>
			</td>
		</tr>
		<tr class="row-19 odd">
			<td class="column-1">South African ICD-10 Technical User Guide compiled by the Ministerial ICD-10 Task Team</td>
			<td class="column-2">
				<a href="/wp-content/uploads/2021/02/icd-10_technical_mzuserguide.pdf">DOWNLOAD</a>
			</td>
		</tr>
		<tr class="row-20 even">
			<td class="column-1">New Codes with notes: WHO updates to ICD-10 2013</td>
			<td class="column-2">
				<a href="/wp-content/uploads/2021/02/icd-10codeswithnotesdecember2013.pdf">DOWNLOAD</a>
			</td>
		</tr>
		<tr class="row-21 odd">
			<td class="column-1">The South African ICD-10 Morbidity Coding Standards and Guidelines</td>
			<td class="column-2">
				<a href="/wp-content/uploads/2021/02/sa_icd-10morbiditycodingstandards-1.pdf">DOWNLOAD</a>
			</td>
		</tr>
		<tr class="row-22 even">
			<td class="column-1">Summary of the National ICD-10 Implementation Status Report for South Africa</td>
			<td class="column-2">
				<a href="/wp-content/uploads/2021/02/icd10-implementation-status-aug-2014-updated-on-27-july-2015_-document-b-.pdf">DOWNLOAD</a>
			</td>
		</tr>
		<tr class="row-23 odd">
			<td class="column-1">Errata ICD-10 Master Industry Table (MIT) of 01 January 2014</td>
			<td class="column-2">
				<a href="/wp-content/uploads/2021/02/NoticetoallStakeholdersErrataICD-10.pdf">DOWNLOAD</a>
			</td>
		</tr>
		<tr class="row-24 even">
			<td class="column-1">ICD-10 Circular 2 of 2014 Submission of Aggregated ICD-10 Compliance Data 2014</td>
			<td class="column-2">
				<a href="/wp-content/uploads/2021/02/ICD-10-Circular-2-of-2014-Submission-of-Aggregated-ICD-10-Compliance-Data-2014.pdf">DOWNLOAD</a>
			</td>
		</tr>
		<tr class="row-25 odd">
			<td class="column-1">Notification on implementation of ICD-10 Phase</td>
			<td class="column-2">
				<a href="/wp-content/uploads/2021/02/ICD-10-Phase3and41.pdf">DOWNLOAD</a>
			</td>
		</tr>
		<tr class="row-26 even">
			<td class="column-1">ICD-10 Notice to Healthcare Stakeholders</td>
			<td class="column-2">
				<a href="/wp-content/uploads/2021/02/ICD10-NOTICETOHEALTHCARESTAKEHOLDERS.pdf">DOWNLOAD</a>
			</td>
		</tr>
		<tr class="row-27 odd">
			<td class="column-1">ICD-10 Definitions</td>
			<td class="column-2">
				<a href="/wp-content/uploads/2021/02/AgeDefinitions2012.pdf">DOWNLOAD</a>
			</td>
		</tr>
		<tr class="row-28 even">
			<td class="column-1">ICD-10 Final User Technical Guide (PDF)</td>
			<td class="column-2">
				<a href="/wp-content/uploads/2021/02/finaluserguideicd10.pdf">DOWNLOAD</a>
			</td>
		</tr>
		<tr class="row-29 odd">
			<td class="column-1">ICD-10 Circular: No 1 of 2012 - ICD-10 Coding Requirements</td>
			<td class="column-2">
				<a href="/wp-content/uploads/2021/02/ICD10CIRCULARNO1OF2012.pdf">DOWNLOAD</a>
			</td>
		</tr>
	</tbody>
</table>

Product version: IRIS 2020.2

Discussion (2)1

Log in or sign up to continue

Julius Kavay · Oct 6, 2022

Use this link as a starting point and consider using either $FIND() or $LOCATE() to narrow down the string you're looking for and then use $EXTRACT() to extract the href value. By the way, it's enough a short example string, posting nearly the whole page is an overkill and wasting space.

0 0

Herman Slagman · Oct 7, 2022

Set href=$Piece($Piece(String,"href=""",2),"""",1)

0 0