Hello, I'm new to pl/sql and Apex, sorry if my question is stupid.
I want Apex to read a .ics calendar file (exported from outlook calendar) and fetch certain data, then insert them into the database and the exisiting calendar in Apex. The first step is to read the file, the question is how to read the text after certain text in a Specific line. Below is the example text in the .ics file, I want to read the line 5, all the text after "DTEND:". How to do that? Thanks in advance.
BEGIN:VEVENT
CLASS:PUBLIC
CREATED:20090818T121933Z
DESCRIPTION:abc
DTEND:20090821T120000Z
DTSTAMP:20090920T184515Z
DTSTART:20090821T060000Z
LAST-MODIFIED:20090902T105635Z
LOCATION:cde
PRIORITY:5
SEQUENCE:0
SUMMARY;LANGUAGE=zh-cn:test 2
TRANSP:OPAQUE
UID:040000008200E00074C5B7101A82E00800000000D044BB4F1720CA01000000000000000
010000000E82FBAAC6CF0DF4BB0E7F41833AA36A1
X-ALT-DESC;FMTTYPE=text/html:<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//E
N">\n<HTML>\n<HEAD>\n<META NAME="Generator" CONTENT="MS Exchange Server ve
rsion 08.00.0681.000">\n<TITLE></TITLE>\n</HEAD>\n<BODY>\n<!-- Converted f
rom text/rtf format -->\n\n<P DIR=LTR ALIGN=JUSTIFY><SPAN LANG="en-us"><FO
NT FACE="Calibri">abc</FONT></SPAN><SPAN LANG="en-us"></SPAN></P>\n\n</BOD
Y>\n</HTML>
X-MICROSOFT-CDO-BUSYSTATUS:BUSY
X-MICROSOFT-CDO-IMPORTANCE:1
X-MICROSOFT-DISALLOW-COUNTER:FALSE
X-MS-OLK-ALLOWEXTERNCHECK:TRUE
X-MS-OLK-AUTOFILLLOCATION:FALSE
X-MS-OLK-CONFTYPE:0
END:VEVENT