Can anyone pls tel me how to cleanup this in Perl.

[Anonymous Monk]

Hey Dear Monks,

I need your help. I want a data(string) to be cleaned and produce a clean output(string). I tried many ways, but failed. I am not a Perl expert, just a novice. I need this data cleaned can any Monks help me in my need.

Thank you.

Note: I have pasted the input and output here, pls have a look.

INPUT --------------------- |data to be cleaned | ---------------------

ftlx0!|!ftlUtil_resetPage!%24!requisitionDescriptionInterface!|!descRe
+quisition!|!rdPager!%24!211140!|!true!|!211140!|!false!|!Submission f
+or the position%5C: Operations Manager - (Job Number%5C: 12452)!|!fal
+se!|!211140!|!false!|!true!|!https%5C://bskyb.taleo.net/careersection
+/jobdetail.ftl?job=211140%26lang=en!|!Operations Manager!|!true!|!Ope
+rations Manager!|!12452!|!GB-England!|!GB-England!|!Permanent!|!Perma
+nent!|!Full-time!|!Full-time!|!Ongoing!|!Ongoing!|!!*!%26nbsp; %0A%3C
+P style=%22MARGIN-TOP%5C: 0px; MARGIN-BOTTOM%5C: 0px%22%3E%3CB style=
+%22mso-bidi-font-weight%5C: normal%22%3E%3CSPAN style=%22FONT-FAMILY%
+5C: %27Sky Text%27, %27sans-serif%27; COLOR%5C: black; FONT-SIZE%5C: 
+11pt; mso-bidi-font-family%5C: Calibri; mso-bidi-theme-font%5C: minor
+-latin%22%3EInfrastructure Operations Manager%3C?xml%5C:namespace pre
+fix = o ns = %22urn%5C:schemas-microsoft-com%5C:office%5C:office%22 /
+%3E%3Co%5C:p%3E%3C/o%5C:p%3E%3C/SPAN%3E%3C/B%3E%3C/P%3E%0A%3CP style=
+%22MARGIN-TOP%5C: 0px; MARGIN-BOTTOM%5C: 0px%22%3E%3CB style=%22mso-b
+idi-font-weight%5C: normal%22%3E%3CSPAN style=%22FONT-FAMILY%5C: %27S
+ky Text%27, %27sans-serif%27; COLOR%5C: black; FONT-SIZE%5C: 11pt; ms
+o-bidi-font-family%5C: Calibri; mso-bidi-theme-font%5C: minor-latin%2
+2%3EBSkyB - Sky Network Services%3C/SPAN%3E%3C/B%3E %3CB style=%22mso
+-bidi-font-weight%5C: normal%22%3E%3CSPAN style=%22FONT-FAMILY%5C: %2
+7Sky Text%27, %27sans-serif%27; COLOR%5C: black; FONT-SIZE%5C: 11pt; 
+mso-bidi-font-family%5C: Calibri; mso-bidi-theme-font%5C: minor-latin
+%22%3E- Information Systems Infrastructure%3CBR%3EBraham Street - Rol
+e may require some travel between Sky sites%3CBR style=%22mso-special
+-character%5C: line-break%22%3E%3CBR style=%22mso-special-character%5
+C: line-break%22%3E%3C/SPAN%3E%3C/B%3E%3CSPAN style=%22FONT-FAMILY%5C
+: %27Sky Text%27, %27sans-serif%27; COLOR%5C: black; FONT-SIZE%5C: 11
+pt; mso-bidi-font-family%5C: Calibri; mso-bidi-theme-font%5C: minor-l
+atin%22%3E%3Co%5C:p%3E%3C/o%5C:p%3E%3C/SPAN%3E%3C/P%3E%0A%3CP style=%
+22MARGIN-TOP%5C: 0px; MARGIN-BOTTOM%5C: 0px%22%3E%3CSPAN style=%22FON
+T-FAMILY%5C: %27Sky Text%27, %27sans-serif%27; COLOR%5C: black; FONT-
+SIZE%5C: 11pt; mso-bidi-font-family%5C: Calibri; mso-bidi-theme-font%
+5C: minor-latin%22%3ESky Network Services owns and manages BSkyB’s IP
+ network backbone and associated information systems infrastructure. 
+As a part of Sky Network Services, the Information Systems department
+ is responsible for Broadband and Telephony; specifically, service pr
+ovisioning, service assurance and service delivery of the core ISP se
+rvices.%3Co%5C:p%3E%3C/o%5C:p%3E%3C/SPAN%3E%3C/P%3E%0A%3CP style=%22M
+ARGIN-TOP%5C: 0px; MARGIN-BOTTOM%5C: 0px%22%3E%3CSPAN style=%22FONT-F
+AMILY%5C: %27Sky Text%27, %27sans-serif%27; COLOR%5C: black; FONT-SIZ
+E%5C: 11pt; mso-bidi-font-family%5C: Calibri; mso-bidi-theme-font%5C:
+ minor-latin%22%3E%3Co%5C:p%3E%26nbsp;%3C/o%5C:p%3E%3C/SPAN%3E%3C/P%3
+E%0A%3CP style=%22MARGIN-TOP%5C: 0px; MARGIN-BOTTOM%5C: 0px%22%3E%3CS
+PAN style=%22FONT-FAMILY%5C: %27Sky Text%27, %27sans-serif%27; COLOR%
+5C: black; FONT-SIZE%5C: 11pt; mso-bidi-font-family%5C: Calibri; mso-
+bidi-theme-font%5C: minor-latin%22%3ESNS IS works with other Sky Tech
+nology business units to develop the BSkyB technology strategy. It de
+fines the detailed requirements for IT solutions and then delivers an
+d supports those solutions.%3Co%5C:p%3E%3C/o%5C:p%3E%3C/SPAN%3E%3C/P%
+3E%0A%3CP style=%22MARGIN-TOP%5C: 0px; MARGIN-BOTTOM%5C: 0px%22%3E%3C
+SPAN style=%22FONT-FAMILY%5C: %27Sky Text%27, %27sans-serif%27; COLOR
+%5C: black; FONT-SIZE%5C: 11pt; mso-bidi-font-family%5C: Calibri; mso
+-bidi-theme-font%5C: minor-latin%22%3E%3Co%5C:p%3E%26nbsp;%3C/o%5C:p%
+3E%3C/SPAN%3E%3C/P%3E%0A%3CP style=%22MARGIN-TOP%5C: 0px; MARGIN-BOTT
+OM%5C: 0px; MARGIN-RIGHT%5C: 2.85pt%22 class=MsoNormal%3E%3CB style=%
+22mso-bidi-font-weight%5C: normal%22%3E%3CSPAN style=%22FONT-FAMILY%5
+C: %27Sky Text%27, %27sans-serif%27; COLOR%5C: black; mso-bidi-font-f
+amily%5C: Calibri; mso-bidi-theme-font%5C: minor-latin%22%3EKey respo
+nsibilities will include%5C:%3Co%5C:p%3E%3C/o%5C:p%3E%3C/SPAN%3E%3C/B
+%3E%3C/P%3E%0A%3CP style=%22MARGIN-TOP%5C: 0px; MARGIN-BOTTOM%5C: 0px
+; MARGIN-RIGHT%5C: 2.85pt%22 class=MsoNormal%3E%3CSPAN style=%22FONT-
+FAMILY%5C: %27Sky Text%27, %27sans-serif%27; mso-bidi-font-family%5C:
+ Calibri; mso-bidi-theme-font%5C: minor-latin%22%3EManaging operation
+al support, system maintenance and system implementation activities a
+cross the two primary Infrastructure operations teams, Systems Admini
+stration (SA) and Database Administration (DBA).%3Co%5C:p%3E%3C/o%5C:
+p%3E%3C/SPAN%3E%3C/P%3E%0A%3CP style=%22MARGIN-TOP%5C: 0px; MARGIN-BO
+TTOM%5C: 0px; MARGIN-RIGHT%5C: 2.85pt%22 class=MsoNormal%3E%3CSPAN st
+yle=%22FONT-FAMILY%5C: %27Sky Text%27, %27sans-serif%27; mso-bidi-fon
+t-family%5C: Calibri; mso-bidi-theme-font%5C: minor-latin%22%3ESystem
+s support%5C:%3Co%5C:p%3E%3C/o%5C:p%3E%3C/SPAN%3E%3C/P%3E%0A%3CP styl
+e=%22MARGIN-TOP%5C: 0px; MARGIN-BOTTOM%5C: 0px; MARGIN-RIGHT%5C: 2.85
+pt%22 class=MsoNormal%3E%3CSPAN style=%22FONT-FAMILY%5C: %27Sky Text%
+27, %27sans-serif%27; mso-bidi-font-family%5C: Calibri; mso-bidi-them
+e-font%5C: minor-latin%22%3E* Manage and coordinate incidents and pro
+blems across the systems estate.%3Co%5C:p%3E%3C/o%5C:p%3E%3C/SPAN%3E%
+3C/P%3E%0A%3CP style=%22MARGIN-TOP%5C: 0px; MARGIN-BOTTOM%5C: 0px; MA
+RGIN-RIGHT%5C: 2.85pt%22 class=MsoNormal%3E%3CSPAN style=%22FONT-FAMI
+LY%5C: %27Sky Text%27, %27sans-serif%27; mso-bidi-font-family%5C: Cal
+ibri; mso-bidi-theme-font%5C: minor-latin%22%3ESystem and platform ma
+intenance%5C:%3Co%5C:p%3E%3C/o%5C:p%3E%3C/SPAN%3E%3C/P%3E%0A%3CP styl
+e=%22MARGIN-TOP%5C: 0px; MARGIN-BOTTOM%5C: 0px; MARGIN-RIGHT%5C: 2.85
+pt%22 class=MsoNormal%3E%3CSPAN style=%22FONT-FAMILY%5C: %27Sky Text%
+27, %27sans-serif%27; mso-bidi-font-family%5C: Calibri; mso-bidi-them
+e-font%5C: minor-latin%22%3E* Manage system maintenance and coordinat
+e software releases across the estate.%3Co%5C:p%3E%3C/o%5C:p%3E%3C/SP
+AN%3E%3C/P%3E%0A%3CP style=%22MARGIN-TOP%5C: 0px; MARGIN-BOTTOM%5C: 0
+px; MARGIN-RIGHT%5C: 2.85pt%22 class=MsoNormal%3E%3CSPAN style=%22FON
+T-FAMILY%5C: %27Sky Text%27, %27sans-serif%27; mso-bidi-font-family%5
+C: Calibri; mso-bidi-theme-font%5C: minor-latin%22%3E* Sequence maint
+enance work into iterations across several different hosting platform
+s.%3Co%5C:p%3E%3C/o%5C:p%3E%3C/SPAN%3E%3C/P%3E%0A%3CP style=%22MARGIN
+-TOP%5C: 0px; MARGIN-BOTTOM%5C: 0px; MARGIN-RIGHT%5C: 2.85pt%22 class
+=MsoNormal%3E%3CSPAN style=%22FONT-FAMILY%5C: %27Sky Text%27, %27sans
+-serif%27; mso-bidi-font-family%5C: Calibri; mso-bidi-theme-font%5C: 
+minor-latin%22%3E* Manage operating system patches and upgrades, data
+base patches and upgrades and software packages and upgrades.%3Co%5C:
+p%3E%3C/o%5C:p%3E%3C/SPAN%3E%3C/P%3E%0A%3CP style=%22MARGIN-TOP%5C: 0
+px; MARGIN-BOTTOM%5C: 0px; MARGIN-RIGHT%5C: 2.85pt%22 class=MsoNormal
+%3E%3CSPAN style=%22FONT-FAMILY%5C: %27Sky Text%27, %27sans-serif%27;
+ mso-bidi-font-family%5C: Calibri; mso-bidi-theme-font%5C: minor-lati
+n%22%3E* Manage the production of operational documentation.%3Co%5C:p
+%3E%3C/o%5C:p%3E%3C/SPAN%3E%3C/P%3E%0A%3CP style=%22MARGIN-TOP%5C: 0p
+x; MARGIN-BOTTOM%5C: 0px; MARGIN-RIGHT%5C: 2.85pt%22 class=MsoNormal%
+3E%3CSPAN style=%22FONT-FAMILY%5C: %27Sky Text%27, %27sans-serif%27; 
+mso-bidi-font-family%5C: Calibri; mso-bidi-theme-font%5C: minor-latin
+%22%3E* Ensure company data governance and data protection policies a
+re adhered to, work with the Assurance Manager and Systems Design to 
+plan work to address the existing compliance issues as appropriate.%3
+Co%5C:p%3E%3C/o%5C:p%3E%3C/SPAN%3E%3C/P%3E%0A%3CP style=%22MARGIN-TOP
+%5C: 0px; MARGIN-BOTTOM%5C: 0px; MARGIN-RIGHT%5C: 2.85pt%22 class=Mso
+Normal%3E%3CSPAN style=%22FONT-FAMILY%5C: %27Sky Text%27, %27sans-ser
+if%27; mso-bidi-font-family%5C: Calibri; mso-bidi-theme-font%5C: mino
+r-latin%22%3E* Ensure company security guidelines are adhered to, wor
+k with the Assurance Manager and Systems Design to plan work to addre
+ss the existing security issues as appropriate.%3Co%5C:p%3E%3C/o%5C:p
+%3E%3C/SPAN%3E%3C/P%3E%0A%3CP style=%22MARGIN-TOP%5C: 0px; MARGIN-BOT
+TOM%5C: 0px; MARGIN-RIGHT%5C: 2.85pt%22 class=MsoNormal%3E%3CSPAN sty
+le=%22FONT-FAMILY%5C: %27Sky Text%27, %27sans-serif%27; mso-bidi-font
+-family%5C: Calibri; mso-bidi-theme-font%5C: minor-latin%22%3E* Work 
+to prevent occurrences of compliance breaches and security breaches.%
+3Co%5C:p%3E%3C/o%5C:p%3E%3C/SPAN%3E%3C/P%3E%0A%3CP style=%22MARGIN-TO
+P%5C: 0px; MARGIN-BOTTOM%5C: 0px; MARGIN-RIGHT%5C: 2.85pt%22 class=Ms
+oNormal%3E%3CSPAN style=%22FONT-FAMILY%5C: %27Sky Text%27, %27sans-se
+rif%27; mso-bidi-font-family%5C: Calibri; mso-bidi-theme-font%5C: min
+or-latin%22%3E* Manage and maintain an accurate repository of the SNS
+ system estate, ensure it is accurate.%3Co%5C:p%3E%3C/o%5C:p%3E%3C/SP
+AN%3E%3C/P%3E%0A%3CP style=%22MARGIN-TOP%5C: 0px; MARGIN-BOTTOM%5C: 0
+px; MARGIN-RIGHT%5C: 2.85pt%22 class=MsoNormal%3E%3CSPAN style=%22FON
+T-FAMILY%5C: %27Sky Text%27, %27sans-serif%27; mso-bidi-font-family%5
+C: Calibri; mso-bidi-theme-font%5C: minor-latin%22%3ESystem implement
+ation and platform implementation%5C:%3Co%5C:p%3E%3C/o%5C:p%3E%3C/SPA
+N%3E%3C/P%3E%0A%3CP style=%22MARGIN-TOP%5C: 0px; MARGIN-BOTTOM%5C: 0p
+x; MARGIN-RIGHT%5C: 2.85pt%22 class=MsoNormal%3E%3CSPAN style=%22FONT
+-FAMILY%5C: %27Sky Text%27, %27sans-serif%27; mso-bidi-font-family%5C
+: Calibri; mso-bidi-theme-font%5C: minor-latin%22%3E* Project work wi
+ll necessitate the growth of the systems estate and platforms; howeve
+r, your role will be to prioritise the platform maintenance activitie
+s while working with the project managers and team leaders to ensure 
+both needs are fully met.%3Co%5C:p%3E%3C/o%5C:p%3E%3C/SPAN%3E%3C/P%3E
+%0A%3CP style=%22MARGIN-TOP%5C: 0px; MARGIN-BOTTOM%5C: 0px; MARGIN-RI
+GHT%5C: 2.85pt%22 class=MsoNormal%3E%3CSPAN style=%22FONT-FAMILY%5C: 
+%27Sky Text%27, %27sans-serif%27; mso-bidi-font-family%5C: Calibri; m
+so-bidi-theme-font%5C: minor-latin%22%3E* Work with project managemen
+t in order to identify risks, issues and dependencies associated with
+ systems and database implementation work.%3Co%5C:p%3E%3C/o%5C:p%3E%3
+C/SPAN%3E%3C/P%3E%0A%3CP style=%22MARGIN-TOP%5C: 0px; MARGIN-BOTTOM%5
+C: 0px; MARGIN-RIGHT%5C: 2.85pt%22 class=MsoNormal%3E%3CSPAN style=%2
+2FONT-FAMILY%5C: %27Sky Text%27, %27sans-serif%27; mso-bidi-font-fami
+ly%5C: Calibri; mso-bidi-theme-font%5C: minor-latin%22%3E* Look for a
+nd drive process improvements in the work allocation lifecycle. %3Co%
+5C:p%3E%3C/o%5C:p%3E%3C/SPAN%3E%3C/P%3E%0A%3CP style=%22MARGIN-TOP%5C
+: 0px; MARGIN-BOTTOM%5C: 0px; MARGIN-RIGHT%5C: 2.85pt%22 class=MsoNor
+mal%3E%3CSPAN style=%22FONT-FAMILY%5C: %27Sky Text%27, %27sans-serif%
+27; mso-bidi-font-family%5C: Calibri; mso-bidi-theme-font%5C: minor-l
+atin%22%3E* Coordinate maintenance activities across other teams with
+in SNS and the rest of Sky.%3Co%5C:p%3E%3C/o%5C:p%3E%3C/SPAN%3E%3C/P%
+3E%0A%3CP style=%22MARGIN-TOP%5C: 0px; MARGIN-BOTTOM%5C: 0px; MARGIN-
+RIGHT%5C: 2.85pt%22 class=MsoNormal%3E%3CSPAN style=%22FONT-FAMILY%5C
+: %27Sky Text%27, %27sans-serif%27; mso-bidi-font-family%5C: Calibri;
+ mso-bidi-theme-font%5C: minor-latin%22%3ETeam and people management%
+5C:%3Co%5C:p%3E%3C/o%5C:p%3E%3C/SPAN%3E%3C/P%3E%0A%3CP style=%22MARGI
+N-TOP%5C: 0px; MARGIN-BOTTOM%5C: 0px; MARGIN-RIGHT%5C: 2.85pt%22 clas
+s=MsoNormal%3E%3CSPAN style=%22FONT-FAMILY%5C: %27Sky Text%27, %27san
+s-serif%27; mso-bidi-font-family%5C: Calibri; mso-bidi-theme-font%5C:
+ minor-latin%22%3E* Act as a champion for the IS Infrastructure teams
+. Build solid relationships with them and spend time getting to under
+stand their work backlog and their issues.%3Co%5C:p%3E%3C/o%5C:p%3E%3
+C/SPAN%3E%3C/P%3E%0A%3CP style=%22MARGIN-TOP%5C: 0px; MARGIN-BOTTOM%5
+C: 0px; MARGIN-RIGHT%5C: 2.85pt%22 class=MsoNormal%3E%3CSPAN style=%2
+2FONT-FAMILY%5C: %27Sky Text%27, %27sans-serif%27; mso-bidi-font-fami
+ly%5C: Calibri; mso-bidi-theme-font%5C: minor-latin%22%3E* Regularly 
+attend team meetings and coordinate activities with the Infrastructur
+e Iteration Manager.%3Co%5C:p%3E%3C/o%5C:p%3E%3C/SPAN%3E%3C/P%3E%0A%3
+CP style=%22MARGIN-TOP%5C: 0px; MARGIN-BOTTOM%5C: 0px; MARGIN-RIGHT%5
+C: 2.85pt%22 class=MsoNormal%3E%3CSPAN style=%22FONT-FAMILY%5C: %27Sk
+y Text%27, %27sans-serif%27; mso-bidi-font-family%5C: Calibri; mso-bi
+di-theme-font%5C: minor-latin%22%3E* Build good relationships with th
+e infrastructure team leaders and managers.%3Co%5C:p%3E%3C/o%5C:p%3E%
+3C/SPAN%3E%3C/P%3E%0A%3CP style=%22TEXT-ALIGN%5C: justify; MARGIN-TOP
+%5C: 0px; TEXT-INDENT%5C: 0cm; MARGIN-BOTTOM%5C: 0px; MARGIN-LEFT%5C:
+ 0cm; mso-list%5C: none; tab-stops%5C: 36.0pt%22 class=JDbullet%3E%3C
+SPAN style=%22FONT-FAMILY%5C: %27Sky Text%27, %27sans-serif%27; mso-b
+idi-font-family%5C: Calibri; mso-bidi-theme-font%5C: minor-latin; mso
+-bidi-font-size%5C: 11.0pt%22%3E* Maintenance, extraction, manipulati
+on and analysis to support the continuous improvement and creation of
+ new reporting %3Co%5C:p%3E%3C/o%5C:p%3E%3C/SPAN%3E%3C/P%3E%0A%3CP st
+yle=%22LINE-HEIGHT%5C: normal; MARGIN%5C: 6pt 0cm%22 class=MsoNormal%
+3E%3CSPAN style=%22FONT-FAMILY%5C: %27Sky Text%27, %27sans-serif%27; 
+mso-bidi-font-family%5C: Calibri; mso-bidi-theme-font%5C: minor-latin
+%22%3E* Taking business requirements and converting these into querie
+s that can extract the required data %3Co%5C:p%3E%3C/o%5C:p%3E%3C/SPA
+N%3E%3C/P%3E%0A%3CP style=%22LINE-HEIGHT%5C: normal; MARGIN%5C: 6pt 0
+cm%22 class=MsoNormal%3E%3CSPAN style=%22FONT-FAMILY%5C: %27Sky Text%
+27, %27sans-serif%27; mso-bidi-font-family%5C: Calibri; mso-bidi-them
+e-font%5C: minor-latin%22%3E* Presenting data in a format that is rea
+dily understood by the business consumers.%3Co%5C:p%3E%3C/o%5C:p%3E%3
+C/SPAN%3E%3C/P%3E%0A%3CP style=%22LINE-HEIGHT%5C: normal; MARGIN%5C: 
+6pt 0cm%22 class=MsoNormal%3E%3CSPAN style=%22FONT-FAMILY%5C: %27Sky 
+Text%27, %27sans-serif%27; mso-bidi-font-family%5C: Calibri; mso-bidi
+-theme-font%5C: minor-latin%22%3E* Writing detailed specifications (t
+echnical and non-technical) for DBAs and Data Warehouse analysts to o
+btain and maintain required data.%3Co%5C:p%3E%3C/o%5C:p%3E%3C/SPAN%3E
+%3C/P%3E%0A%3CP style=%22LINE-HEIGHT%5C: normal; MARGIN%5C: 6pt 0cm%2
+2 class=MsoNormal%3E%3CSPAN style=%22FONT-FAMILY%5C: %27Sky Text%27, 
+%27sans-serif%27; mso-bidi-font-family%5C: Calibri; mso-bidi-theme-fo
+nt%5C: minor-latin%22%3E* Help to identify gaps in the operational pr
+ocess and add reporting around it to prevent drop out %3Co%5C:p%3E%3C
+/o%5C:p%3E%3C/SPAN%3E%3C/P%3E%0A%3CP style=%22LINE-HEIGHT%5C: normal;
+ MARGIN%5C: 6pt 0cm%22 class=MsoNormal%3E%3CSPAN style=%22FONT-FAMILY
+%5C: %27Sky Text%27, %27sans-serif%27; mso-bidi-font-family%5C: Calib
+ri; mso-bidi-theme-font%5C: minor-latin%22%3E* Performing statistical
+ and root cause analysis to resolve any issues.%3Co%5C:p%3E%3C/o%5C:p
+%3E%3C/SPAN%3E%3C/P%3E%0A%3CP style=%22LINE-HEIGHT%5C: normal; MARGIN
+%5C: 6pt 0cm%22 class=MsoNormal%3E%3CSPAN style=%22FONT-FAMILY%5C: %2
+7Sky Text%27, %27sans-serif%27; mso-bidi-font-family%5C: Calibri; mso
+-bidi-theme-font%5C: minor-latin%22%3E* Ensuring the integrity, accur
+acy and delivery of business data extracted from various systems to s
+upport operational, regulatory and compliance reporting.%3Co%5C:p%3E%
+3C/o%5C:p%3E%3C/SPAN%3E%3C/P%3E%0A%3CP style=%22LINE-HEIGHT%5C: norma
+l; MARGIN%5C: 6pt 0cm%22 class=MsoNormal%3E%3CSPAN style=%22FONT-FAMI
+LY%5C: %27Sky Text%27, %27sans-serif%27; mso-bidi-font-family%5C: Cal
+ibri; mso-bidi-theme-font%5C: minor-latin%22%3E* Ensuring that all pr
+ocesses, automation and SQL scripts are documented.%3Co%5C:p%3E%3C/o%
+5C:p%3E%3C/SPAN%3E%3C/P%3E%0A%3CP style=%22MARGIN-TOP%5C: 0px; MARGIN
+-BOTTOM%5C: 0px; MARGIN-RIGHT%5C: 2.85pt%22 class=MsoNormal%3E%3CSPAN
+ style=%22FONT-FAMILY%5C: %27Sky Text%27, %27sans-serif%27; mso-bidi-
+font-family%5C: Calibri; mso-bidi-theme-font%5C: minor-latin%22%3E* E
+nsuring timely and accurate compilation of monthly and weekly regular
+ity reports to relevant stake holders.%3C/SPAN%3E%3CSPAN style=%22FON
+T-FAMILY%5C: %27Sky Text%27, %27sans-serif%27; mso-bidi-font-family%5
+C: Calibri; mso-bidi-theme-font%5C: minor-latin; mso-ansi-language%5C
+: EN-US%22 lang=EN-US%3E%3Co%5C:p%3E%3C/o%5C:p%3E%3C/SPAN%3E%3C/P%3E%
+0A%3CP style=%22LINE-HEIGHT%5C: normal; MARGIN%5C: 0cm -52.7pt 0pt 0c
+m%22 class=MsoNormal%3E%3CB style=%22mso-bidi-font-weight%5C: normal%
+22%3E%3CSPAN style=%22FONT-FAMILY%5C: %27Sky Text%27, %27sans-serif%2
+7; COLOR%5C: black; mso-bidi-font-family%5C: Calibri; mso-bidi-theme-
+font%5C: minor-latin%22%3ESuccessful applicants must have%5C:%3Co%5C:
+p%3E%3C/o%5C:p%3E%3C/SPAN%3E%3C/B%3E%3C/P%3E%0A%3CP style=%22LINE-HEI
+GHT%5C: normal; MARGIN%5C: 0cm -52.7pt 0pt 0cm%22 class=MsoNormal%3E%
+3CSPAN style=%22FONT-FAMILY%5C: %27Sky Text%27, %27sans-serif%27; COL
+OR%5C: black; mso-bidi-font-family%5C: Calibri; mso-bidi-theme-font%5
+C: minor-latin%22%3E%3Co%5C:p%3E%26nbsp;%3C/o%5C:p%3E%3C/SPAN%3E%3C/P
+%3E%0A%3CP style=%22MARGIN-TOP%5C: 0px; TEXT-INDENT%5C: 0cm; MARGIN-B
+OTTOM%5C: 0px; MARGIN-LEFT%5C: 0cm; mso-list%5C: none; tab-stops%5C: 
+36.0pt%22 class=cpcontent%3E%3CSPAN style=%22FONT-SIZE%5C: 11pt%22%3E
+* Relevant degree or equivalent professional qualifications%3Co%5C:p%
+3E%3C/o%5C:p%3E%3C/SPAN%3E%3C/P%3E%0A%3CP style=%22MARGIN-TOP%5C: 0px
+; TEXT-INDENT%5C: 0cm; MARGIN-BOTTOM%5C: 0px; MARGIN-LEFT%5C: 0cm; ms
+o-list%5C: none; tab-stops%5C: 36.0pt%22 class=cpcontent%3E%3CSPAN st
+yle=%22FONT-SIZE%5C: 11pt%22%3E* Extensive IT management experience i
+n a highly technical environment%3Co%5C:p%3E%3C/o%5C:p%3E%3C/SPAN%3E%
+3C/P%3E%0A%3CP style=%22MARGIN-TOP%5C: 0px; TEXT-INDENT%5C: 0cm; MARG
+IN-BOTTOM%5C: 0px; MARGIN-LEFT%5C: 0cm; mso-list%5C: none; tab-stops%
+5C: 36.0pt%22 class=cpcontent%3E%3CSPAN style=%22FONT-SIZE%5C: 11pt%2
+2%3E* Demonstrable background in computer infrastructure%3Co%5C:p%3E%
+3C/o%5C:p%3E%3C/SPAN%3E%3C/P%3E%0A%3CP style=%22MARGIN-TOP%5C: 0px; T
+EXT-INDENT%5C: 0cm; MARGIN-BOTTOM%5C: 0px; MARGIN-LEFT%5C: 0cm; mso-l
+ist%5C: none; tab-stops%5C: 36.0pt%22 class=cpcontent%3E%3CSPAN style
+=%22FONT-SIZE%5C: 11pt%22%3E* Experience with one or more business/in
+dustry sectors – Communications industry desirable %3Co%5C:p%3E%3C/o%
+5C:p%3E%3C/SPAN%3E%3C/P%3E%0A%3CP style=%22MARGIN-TOP%5C: 0px; TEXT-I
+NDENT%5C: 0cm; MARGIN-BOTTOM%5C: 0px; MARGIN-LEFT%5C: 0cm; mso-list%5
+C: none; tab-stops%5C: 36.0pt%22 class=cpcontent%3E%3CSPAN style=%22F
+ONT-SIZE%5C: 11pt%22%3E* Experience of capturing risks and issues%3Co
+%5C:p%3E%3C/o%5C:p%3E%3C/SPAN%3E%3C/P%3E%0A%3CP style=%22MARGIN-TOP%5
+C: 0px; TEXT-INDENT%5C: 0cm; MARGIN-BOTTOM%5C: 0px; MARGIN-LEFT%5C: 0
+cm; mso-list%5C: none; tab-stops%5C: 36.0pt%22 class=cpcontent%3E%3CS
+PAN style=%22FONT-SIZE%5C: 11pt%22%3E* Experience in co-ordinating an
+d engaging across teams%3Co%5C:p%3E%3C/o%5C:p%3E%3C/SPAN%3E%3C/P%3E%0
+A%3CP style=%22MARGIN-TOP%5C: 0px; TEXT-INDENT%5C: 0cm; MARGIN-BOTTOM
+%5C: 0px; MARGIN-LEFT%5C: 0cm; mso-list%5C: none; tab-stops%5C: 36.0p
+t%22 class=cpcontent%3E%3CSPAN style=%22FONT-SIZE%5C: 11pt; mso-bidi-
+font-family%5C: Calibri; mso-bidi-theme-font%5C: minor-latin%22%3E* C
+ommitted to all aspects of people and team performance%3Co%5C:p%3E%3C
+/o%5C:p%3E%3C/SPAN%3E%3C/P%3E%0A%3CP style=%22MARGIN-TOP%5C: 0px; TEX
+T-INDENT%5C: 0cm; MARGIN-BOTTOM%5C: 0px; MARGIN-LEFT%5C: 0cm; mso-lis
+t%5C: none; tab-stops%5C: 36.0pt%22 class=cpcontent%3E%3CSPAN style=%
+22FONT-SIZE%5C: 11pt; mso-bidi-font-family%5C: Calibri; mso-bidi-them
+e-font%5C: minor-latin%22%3E* Strong communication skills with the ab
+ility to develop present and defend recommendations%3Co%5C:p%3E%3C/o%
+5C:p%3E%3C/SPAN%3E%3C/P%3E%0A%3CP style=%22MARGIN-TOP%5C: 0px; TEXT-I
+NDENT%5C: 0cm; MARGIN-BOTTOM%5C: 0px; MARGIN-LEFT%5C: 0cm; mso-list%5
+C: none; tab-stops%5C: 36.0pt%22 class=cpcontent%3E%3CSPAN style=%22F
+ONT-SIZE%5C: 11pt; mso-bidi-font-family%5C: Calibri; mso-bidi-theme-f
+ont%5C: minor-latin%22%3E* Credible to both IT and business users%3Co
+%5C:p%3E%3C/o%5C:p%3E%3C/SPAN%3E%3C/P%3E%0A%3CP style=%22MARGIN-TOP%5
+C: 0px; TEXT-INDENT%5C: 0cm; MARGIN-BOTTOM%5C: 0px; MARGIN-LEFT%5C: 0
+cm; mso-list%5C: none; tab-stops%5C: 36.0pt%22 class=cpcontent%3E%3CS
+PAN style=%22FONT-SIZE%5C: 11pt; mso-bidi-font-family%5C: Calibri; ms
+o-bidi-theme-font%5C: minor-latin%22%3E* Relationship management – ab
+ility to develop and maintain effective relationships with business u
+sers%3Co%5C:p%3E%3C/o%5C:p%3E%3C/SPAN%3E%3C/P%3E%0A%3CP style=%22MARG
+IN-TOP%5C: 0px; TEXT-INDENT%5C: 0cm; MARGIN-BOTTOM%5C: 0px; MARGIN-LE
+FT%5C: 21pt; mso-list%5C: none; tab-stops%5C: 36.0pt%22 class=cpconte
+nt%3E%3CSPAN style=%22FONT-SIZE%5C: 11pt; mso-bidi-font-family%5C: Ca
+libri; mso-bidi-theme-font%5C: minor-latin%22%3E%3Co%5C:p%3E%26nbsp;%
+3C/o%5C:p%3E%3C/SPAN%3E%3C/P%3E%0A%3CP style=%22MARGIN-TOP%5C: 0px; T
+EXT-INDENT%5C: 0cm; MARGIN-BOTTOM%5C: 0px; MARGIN-LEFT%5C: 0cm; mso-l
+ist%5C: none; tab-stops%5C: 36.0pt%22 class=cpcontent%3E%3CSPAN style
+=%22FONT-SIZE%5C: 11pt; mso-bidi-font-family%5C: Calibri; mso-bidi-th
+eme-font%5C: minor-latin%22%3EOur benefits package is designed to rec
+ognise the essential part you play in Sky’s success. We offer free Sk
+y+HD, broadband and talk services; private medical insurance, generou
+s holiday entitlements, a contribution pension scheme, a Share scheme
+ so you can have a stake in Sky and our success plus Sky Choices a be
+nefit scheme to help you make valuable tax %26amp; national insurance
+ savings. %3Co%5C:p%3E%3C/o%5C:p%3E%3C/SPAN%3E%3C/P%3E%0A%3CP style=%
+22MARGIN-TOP%5C: 0px; TEXT-INDENT%5C: 0cm; MARGIN-BOTTOM%5C: 0px; MAR
+GIN-LEFT%5C: 0cm; mso-list%5C: none; tab-stops%5C: 36.0pt%22 class=cp
+content%3E%3CSPAN style=%22FONT-SIZE%5C: 11pt; mso-bidi-font-family%5
+C: Calibri; mso-bidi-theme-font%5C: minor-latin%22%3E%3CSPAN style=%2
+2mso-spacerun%5C: yes%22%3E%26nbsp;%3C/SPAN%3E%3Co%5C:p%3E%3C/o%5C:p%
+3E%3C/SPAN%3E%3C/P%3E%0A%3CP style=%22MARGIN-TOP%5C: 0px; TEXT-INDENT
+%5C: 0cm; MARGIN-BOTTOM%5C: 0px; MARGIN-LEFT%5C: 0cm; mso-list%5C: no
+ne; tab-stops%5C: 36.0pt%22 class=cpcontent%3E%3CSPAN style=%22FONT-S
+IZE%5C: 11pt; mso-bidi-font-family%5C: Calibri; mso-bidi-theme-font%5
+C: minor-latin%22%3ESky delivers some of the most diverse content and
+ services on the planet, and we value the same diversity within our b
+usiness. We provide a culture of entrepreneurialism and opportunity f
+or one and all. %3Co%5C:p%3E%3C/o%5C:p%3E%3C/SPAN%3E%3C/P%3E%0A%3CP s
+tyle=%22MARGIN-TOP%5C: 0px; TEXT-INDENT%5C: 0cm; MARGIN-BOTTOM%5C: 0p
+x; MARGIN-LEFT%5C: 0cm; mso-list%5C: none; tab-stops%5C: 36.0pt%22 cl
+ass=cpcontent%3E%3CSPAN style=%22FONT-SIZE%5C: 11pt; mso-bidi-font-fa
+mily%5C: Calibri; mso-bidi-theme-font%5C: minor-latin%22%3E%3Co%5C:p%
+3E%26nbsp;%3C/o%5C:p%3E%3C/SPAN%3E%3C/P%3E%0A%3CP style=%22MARGIN-TOP
+%5C: 0px; TEXT-INDENT%5C: 0cm; MARGIN-BOTTOM%5C: 0px; MARGIN-LEFT%5C:
+ 0cm; mso-list%5C: none; tab-stops%5C: 36.0pt%22 class=cpcontent%3E%3
+CSPAN style=%22FONT-SIZE%5C: 11pt; mso-bidi-font-family%5C: Calibri; 
+mso-bidi-theme-font%5C: minor-latin%22%3EFor more information about w
+orking for Sky visit %3C/SPAN%3E%3CA href=%22http%5C://www.workforsky
+.com/%22%3E%3CSPAN style=%22FONT-SIZE%5C: 11pt; mso-bidi-font-family%
+5C: Calibri; mso-bidi-theme-font%5C: minor-latin%22%3Ewww.workforsky.
+com%3C/SPAN%3E%3C/A%3E%3CSPAN style=%22FONT-SIZE%5C: 11pt; mso-bidi-f
+ont-family%5C: Calibri; mso-bidi-theme-font%5C: minor-latin%22%3E%3Co
+%5C:p%3E%3C/o%5C:p%3E%3C/SPAN%3E%3C/P%3E%0A%3CP style=%22MARGIN-TOP%5
+C: 0px; TEXT-INDENT%5C: 0cm; MARGIN-BOTTOM%5C: 0px; MARGIN-LEFT%5C: 0
+cm; mso-list%5C: none; tab-stops%5C: 36.0pt%22 class=cpcontent%3E%3CS
+PAN style=%22FONT-SIZE%5C: 11pt; mso-bidi-font-family%5C: Calibri; ms
+o-bidi-theme-font%5C: minor-latin%22%3ESky - Believe in Better %3Co%5
+C:p%3E%3C/o%5C:p%3E%3C/SPAN%3E%3C/P%3E%0A%3CP style=%22MARGIN-TOP%5C:
+ 0px; TEXT-INDENT%5C: 0cm; MARGIN-BOTTOM%5C: 0px; MARGIN-LEFT%5C: 0cm
+; mso-list%5C: none; tab-stops%5C: 36.0pt%22 class=cpcontent%3E%3CSPA
+N style=%22FONT-SIZE%5C: 11pt; mso-bidi-font-family%5C: Calibri; mso-
+bidi-theme-font%5C: minor-latin%22%3E%3Co%5C:p%3E%26nbsp;%3C/o%5C:p%3
+E%3C/SPAN%3E%3C/P%3E%0A%3CP style=%22MARGIN-TOP%5C: 0px; TEXT-INDENT%
+5C: 0cm; MARGIN-BOTTOM%5C: 0px; MARGIN-LEFT%5C: 0cm; mso-list%5C: non
+e; tab-stops%5C: 36.0pt%22 class=cpcontent%3E%3CSPAN style=%22FONT-SI
+ZE%5C: 11pt; mso-bidi-font-family%5C: Calibri; mso-bidi-theme-font%5C
+: minor-latin%22%3EDue to the fast paced nature of Sky%27s Businesses
+ our vacancy close dates may be subject to change%3Co%5C:p%3E%3C/o%5C
+:p%3E%3C/SPAN%3E%3C/P%3E%0A%3CP style=%22MARGIN-TOP%5C: 0px; TEXT-IND
+ENT%5C: 0cm; MARGIN-BOTTOM%5C: 0px; MARGIN-LEFT%5C: 0cm; mso-list%5C:
+ none; tab-stops%5C: 36.0pt%22 class=cpcontent%3E%3CSPAN style=%22FON
+T-FAMILY%5C: %27Calibri%27, %27sans-serif%27; mso-bidi-theme-font%5C:
+ minor-latin; mso-ascii-theme-font%5C: minor-latin; mso-hansi-theme-f
+ont%5C: minor-latin%22%3E%3Co%5C:p%3E%26nbsp;%3C/o%5C:p%3E%3C/SPAN%3E
+%3C/P%3E%0A%3CP style=%22MARGIN-TOP%5C: 0px; MARGIN-BOTTOM%5C: 0px%22
+ class=MsoNormal%3E%3Co%5C:p%3E%26nbsp;%3C/o%5C:p%3E%3C/P%3E!|!!|!fal
+se!|!211140!|!211140!|!true!|!211140!|!false!|!Submission for the pos
+ition%5C: Operations Manager - (Job Number%5C: 12452)!|!false!|!21114
+0!|!false!|!true!|!https%5C://bskyb.taleo.net/careersection/jobdetail
+.ftl?job=211140%26lang=en!|!Operations Manager!|!true!%24!ftlerrors!|
+!!|!descRequisition.size!|!1!|!descRequisition.nbElements!|!155!|!des
+cRequisition.isEmpty!|!false!|!descRequisition.hasElements!|!true!|!f
+ocusOnField!|!!|!emptyListToken!|!!|!isListEmpty!|!false!|!listCount!
+|!!|!commonDescriptionForAddThis!|!!|!alreadyAppliedColumnDisplayed!|
+!false!|!displayDraft!|!!|!displaymessage!|!false!|!initialHistoryPag
+e!|!1!|!restoreInitialHistoryOnRefresh!|!false!|!applicationCandidate
+No!|!!|!calloutPageDisplayed!|!true!|!descriptionLogginMandatory!|!fa
+lse!|!displayAsMainHeader!|!false!|!displayListingsPerPage!|!false!|!
+displayUrgentNeed!|!!|!isApplicantUser!|!true!|!jobsPerPageCaption!|!
+Job {0} out of {1}!|!listEmptyIsApplicantUser!|!true!|!listLabels!|!!
+|!listLocales!|!!|!requisitionno!|!211140!|!interfaceIdForTimeZone!|!
+requisitionDescriptionInterface!|!isJobCartActionDisplayed!|!true!|!o
+penDescFrom!|!default!|!serializedCriteria!|!!|!sortby!|!11!%24!requi
+sitionDescriptionInterface!|!!|!!|!!|!!|!!|!Apply for this position o
+nline!|!Apply by Email!|!Apply to this position by email!|!Add this p
+osition to the job cart!|!!|!Job Description!|!Tell us about a friend
+ who might be interested in this job. All privacy rights will be prot
+ected.!|!false!|!Tell us about a person who might be interested in wo
+rking for our organization. All privacy rights will be protected.!|!t
+rue!|! !|!Apply for this position online!|!Apply to this position by 
+email!|!Add this position to the job cart!|!!|!!|!!|!

OUTPUT ---------------------------- |I need the output as below| ----------------------------

Infrastructure Operations Manager
BSkyB - Sky Network Services - Information Systems Infrastructure
Braham Street - Role may require some travel between Sky sites

Sky Network Services owns and manages BSkyB’s IP network backbone and 
+associated information systems infrastructure. As a part of Sky Netwo
+rk Services, the Information Systems department is responsible for Br
+oadband and Telephony; specifically, service provisioning, service as
+surance and service delivery of the core ISP services.
 
SNS IS works with other Sky Technology business units to develop the B
+SkyB technology strategy. It defines the detailed requirements for IT
+ solutions and then delivers and supports those solutions.
 
Key responsibilities will include:
Managing operational support, system maintenance and system implementa
+tion activities across the two primary Infrastructure operations team
+s, Systems Administration (SA) and Database Administration (DBA).
Systems support:
* Manage and coordinate incidents and problems across the systems esta
+te.
System and platform maintenance:
* Manage system maintenance and coordinate software releases across th
+e estate.
* Sequence maintenance work into iterations across several different h
+osting platforms.
* Manage operating system patches and upgrades, database patches and u
+pgrades and software packages and upgrades.
* Manage the production of operational documentation.
* Ensure company data governance and data protection policies are adhe
+red to, work with the Assurance Manager and Systems Design to plan wo
+rk to address the existing compliance issues as appropriate.
* Ensure company security guidelines are adhered to, work with the Ass
+urance Manager and Systems Design to plan work to address the existin
+g security issues as appropriate.
* Work to prevent occurrences of compliance breaches and security brea
+ches.
* Manage and maintain an accurate repository of the SNS system estate,
+ ensure it is accurate.
System implementation and platform implementation:
* Project work will necessitate the growth of the systems estate and p
+latforms; however, your role will be to prioritise the platform maint
+enance activities while working with the project managers and team le
+aders to ensure both needs are fully met.
* Work with project management in order to identify risks, issues and 
+dependencies associated with systems and database implementation work
+.
* Look for and drive process improvements in the work allocation lifec
+ycle.
* Coordinate maintenance activities across other teams within SNS and 
+the rest of Sky.
Team and people management:
* Act as a champion for the IS Infrastructure teams. Build solid relat
+ionships with them and spend time getting to understand their work ba
+cklog and their issues.
* Regularly attend team meetings and coordinate activities with the In
+frastructure Iteration Manager.
* Build good relationships with the infrastructure team leaders and ma
+nagers.
* Maintenance, extraction, manipulation and analysis to support the co
+ntinuous improvement and creation of new reporting
* Taking business requirements and converting these into queries that 
+can extract the required data

* Presenting data in a format that is readily understood by the busine
+ss consumers.

* Writing detailed specifications (technical and non-technical) for DB
+As and Data Warehouse analysts to obtain and maintain required data.

* Help to identify gaps in the operational process and add reporting a
+round it to prevent drop out

* Performing statistical and root cause analysis to resolve any issues
+.

* Ensuring the integrity, accuracy and delivery of business data extra
+cted from various systems to support operational, regulatory and comp
+liance reporting.

* Ensuring that all processes, automation and SQL scripts are document
+ed.

* Ensuring timely and accurate compilation of monthly and weekly regul
+arity reports to relevant stake holders.
Successful applicants must have:
 
* Relevant degree or equivalent professional qualifications
* Extensive IT management experience in a highly technical environment
* Demonstrable background in computer infrastructure
* Experience with one or more business/industry sectors – Communicatio
+ns industry desirable
* Experience of capturing risks and issues
* Experience in co-ordinating and engaging across teams
* Committed to all aspects of people and team performance
* Strong communication skills with the ability to develop present and 
+defend recommendations
* Credible to both IT and business users
* Relationship management – ability to develop and maintain effective 
+relationships with business users
 
Our benefits package is designed to recognise the essential part you p
+lay in Sky’s success. We offer free Sky+HD, broadband and talk servic
+es; private medical insurance, generous holiday entitlements, a contr
+ibution pension scheme, a Share scheme so you can have a stake in Sky
+ and our success plus Sky Choices a benefit scheme to help you make v
+aluable tax & national insurance savings.
 
Sky delivers some of the most diverse content and services on the plan
+et, and we value the same diversity within our business. We provide a
+ culture of entrepreneurialism and opportunity for one and all.

[Athanasius]

NetWallah’s advice is correct, and if you follow it you will save yourself a lot of time and difficulty in the long run. But — to show off Perl’s text-munging power — the following quick-and-dirty script (OK, hack) will produce output close to what you’re seeking (for this data):

#! perl
use strict;
use warnings;

if (my ($field) = grep { /^!!./ } split /\|/, do { local $/; <DATA> })
{
    my @lines = $field =~ m{ minor-latin%22%3E (.*?) %3C }gx;

    for (@lines)
    {
        s{ \\x92     }{'}gx;
        s{   %5C     } {}gx;
        s{   %27     }{'}gx;
        s{   %26amp; }{&}gx;
    }

    print join("\n", @lines);
}

__DATA__
<insert the data here>

Hope that helps,

[Anonymous Monk]

Thanks Athanasius. That was cool. I am not that good with perl. my question may be foolish but pls can you tell me, how the script should be modified if the data is already in a string. means if '$data' contains the whole data and kindly tell me how I should modify this script.

[Athanasius]

If the data has already been read into the variable $data as a single string, then just replace the line:

if (my ($field) = grep { /^!!./ } split /\|/, do { local $/; <DATA> })

with:

if (my ($field) = grep { /^!!./ } split /\|/, $data)

(The expression do { local $/; <DATA> } slurps the whole of the data in from the __DATA__ block at the foot of the script.)

Hope that helps,

[NetWallah]

It looks like you need to properly get and reformat the contents of this URL:

https://bskyb.taleo.net/careersection/corporate/jobdetail.ftl?job=211140

To do this, you need to use something like the LWP series of modules, and an HTML parser.

You will need to enhance your perl skills considerably, in order to use these techniques effectively.

Also, please read the "readmore" sectiopn of Writeup Formatting Tips, if you are posting large amounts of text or code.

[Anonymous Monk]

Thx. NetWallah. Used Mechanize module. But this is javascript powered site.I think we cant really do it with an HTML parser(if going through mechanize module). Try save the file using mechanize and open it again and see the difference

[NetWallah]

I was able to fetch the content using "curl" - so, as far as I can see, the javascript is irrelevant, and you may not need the Mechanize. A simpler LWP module should be sufficient for fetching, once you know the URL.