Click here to Skip to main content
15,860,859 members
Home / Discussions / Regular Expressions
   

Regular Expressions

 
AnswerRe: Capture values using regex Pin
Richard Deeming8-Dec-20 6:35
mveRichard Deeming8-Dec-20 6:35 
GeneralRe: Capture values using regex Pin
akwillows8-Dec-20 6:37
akwillows8-Dec-20 6:37 
GeneralRe: Capture values using regex Pin
Richard Deeming8-Dec-20 21:39
mveRichard Deeming8-Dec-20 21:39 
QuestionA Regular Expression that will search and replace characters from a string Pin
Member 135726842-Dec-20 9:05
Member 135726842-Dec-20 9:05 
AnswerRe: A Regular Expression that will search and replace characters from a string Pin
Richard Deeming2-Dec-20 22:23
mveRichard Deeming2-Dec-20 22:23 
GeneralRe: A Regular Expression that will search and replace characters from a string Pin
Member 135726843-Dec-20 0:52
Member 135726843-Dec-20 0:52 
AnswerRe: A Regular Expression that will search and replace characters from a string Pin
GenJerDan3-Dec-20 1:38
GenJerDan3-Dec-20 1:38 
QuestionRegEx: Get Values from HTML Attribute Tags Pin
Member 1046475230-Sep-20 19:47
Member 1046475230-Sep-20 19:47 
I need to get the values from below following html snippet. So far I came up with this regex which helps me trim it down to the values I needed, but to automate this I need to join 2 regex statements to get the result "18" which is where I am stuck at. Or Please suggest a better method for me get the values.

I am using WebHarvey scraping tool. The program is based on .net but it doesn't support inserting .net code so I need only regex command.

First Regex Statement
(?s)(?<=attribute bathroom).+?(?=\/span)
Result:
" title="Bathrooms" style="  ">
                    <span class="value" style="  ">18<


Second Regex Statement
(?s)(?<=<span class="value" style=" ">).+?(?=<)
Result: 18

HTML Snippet

<ul class="iconContainer" style="  ">
                <li class="attribute propertyId">
                    xxx1
                </li>
                <li class="attribute propertyType">
                    Factory
                </li>
                <li class="attribute bathroom" title="Bathrooms" style="  ">
                    18
                </li>
                <li class="attribute carspace" title="Car Spaces" style="  ">
                    18
                </li>
                <li class="attribute landArea">
                        <span title="Land Area">
                            5,010<span class="unit">mclass="superscript"></span>
                        </span>
                    <span>|</span>
                        <span title="Floor Area">
                            9,270<span class="unit">m^__b class="superscript">2</span>
                        </span>
                </li>
        </ul>

AnswerRe: RegEx: Get Values from HTML Attribute Tags Pin
Richard MacCutchan30-Sep-20 21:26
mveRichard MacCutchan30-Sep-20 21:26 
AnswerRe: RegEx: Get Values from HTML Attribute Tags Pin
Richard Deeming30-Sep-20 22:14
mveRichard Deeming30-Sep-20 22:14 
GeneralRe: RegEx: Get Values from HTML Attribute Tags Pin
Member 104647521-Oct-20 3:58
Member 104647521-Oct-20 3:58 
GeneralRe: RegEx: Get Values from HTML Attribute Tags Pin
Dave Kreskowiak1-Oct-20 4:41
mveDave Kreskowiak1-Oct-20 4:41 
GeneralRe: RegEx: Get Values from HTML Attribute Tags Pin
Richard Deeming1-Oct-20 4:41
mveRichard Deeming1-Oct-20 4:41 
QuestionString Replacement Pin
Michael Eckstein19-Sep-20 20:27
Michael Eckstein19-Sep-20 20:27 
AnswerRe: String Replacement Pin
Richard MacCutchan19-Sep-20 21:11
mveRichard MacCutchan19-Sep-20 21:11 
GeneralRe: String Replacement Pin
Michael Eckstein19-Sep-20 22:28
Michael Eckstein19-Sep-20 22:28 
GeneralRe: String Replacement Pin
Michael Eckstein20-Sep-20 0:19
Michael Eckstein20-Sep-20 0:19 
GeneralRe: String Replacement Pin
Michael Eckstein20-Sep-20 1:01
Michael Eckstein20-Sep-20 1:01 
GeneralRe: String Replacement Pin
Richard MacCutchan20-Sep-20 1:32
mveRichard MacCutchan20-Sep-20 1:32 
QuestionRegEx Split Pin
Member 148774747-Sep-20 7:56
Member 148774747-Sep-20 7:56 
AnswerRe: RegEx Split Pin
Richard Deeming7-Sep-20 22:43
mveRichard Deeming7-Sep-20 22:43 
Question9 million Rows in Excel Pin
IzaacSpyro30-Aug-20 22:20
IzaacSpyro30-Aug-20 22:20 
QuestionFinding a specific number in a string. Pin
Member 1086910714-Aug-20 11:36
Member 1086910714-Aug-20 11:36 
AnswerRe: Finding a specific number in a string. Pin
Richard MacCutchan14-Aug-20 21:40
mveRichard MacCutchan14-Aug-20 21:40 
GeneralRe: Finding a specific number in a string. Pin
Member 1086910715-Aug-20 1:17
Member 1086910715-Aug-20 1:17 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.