regular expression to search in xml file
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
-2
i have a xml file a lot of links and some other information
i want to extract these links from that xml to put them in another text file.
i am using sublime 3 so i want a regular expression to search for links inside the xml file
here is some of the file
<Row ss:Height="13.8"><Cell ss:Formula="of:=HYPERLINK("http://csr.bu.edu/ftp/asl/asllvd/demos/verify_start_end_handshape_annotations//test_auto_move//signs_mov_separ_signers/Liz_10.mov"; "MOV")"><Data ss:Type="String">MOV</Data></Cell></Row>
<Row ss:Height="13.8"><Cell ss:Formula="of:=HYPERLINK("http://csr.bu.edu/ftp/asl/asllvd/demos/verify_start_end_handshape_annotations//test_auto_move//signs_mov_separ_signers/Tyler_10.mov"; "MOV")"><Data ss:Type="String">MOV</Data></Cell></Row>
<Row ss:Height="13.8"><Cell ss:Formula="of:=HYPERLINK("http://csr.bu.edu/ftp/asl/asllvd/demos/verify_start_end_handshape_annotations//test_auto_move//signs_mov_separ_signers/Naomi_10.mov"; "MOV")"><Data ss:Type="String">MOV</Data></Cell></Row>
<Row ss:Index="7" ss:Height="13.8"><Cell ss:Formula="of:=HYPERLINK("http://csr.bu.edu/ftp/asl/asllvd/demos/verify_start_end_handshape_annotations//test_auto_move//signs_mov_separ_signers/Brady_10.mov"; "MOV")"><Data ss:Type="String">MOV</Data></Cell></Row>
i want to exctract these links to be like this
http://csr.bu.edu/ftp/asl/asllvd/demos/verify_start_end_handshape_annotations//test_auto_move//signs_mov_separ_signers/Liz_10.mov
how can i do this?
regex xml sublimetext3
edited Nov 17 '18 at 9:06
JohnyL
3,73811025
asked Nov 17 '18 at 1:01
Mustafa MancyMustafa Mancy
32
add a comment |
-2
i have a xml file a lot of links and some other information
i want to extract these links from that xml to put them in another text file.
i am using sublime 3 so i want a regular expression to search for links inside the xml file
here is some of the file
<Row ss:Height="13.8"><Cell ss:Formula="of:=HYPERLINK("http://csr.bu.edu/ftp/asl/asllvd/demos/verify_start_end_handshape_annotations//test_auto_move//signs_mov_separ_signers/Liz_10.mov"; "MOV")"><Data ss:Type="String">MOV</Data></Cell></Row>
<Row ss:Height="13.8"><Cell ss:Formula="of:=HYPERLINK("http://csr.bu.edu/ftp/asl/asllvd/demos/verify_start_end_handshape_annotations//test_auto_move//signs_mov_separ_signers/Tyler_10.mov"; "MOV")"><Data ss:Type="String">MOV</Data></Cell></Row>
<Row ss:Height="13.8"><Cell ss:Formula="of:=HYPERLINK("http://csr.bu.edu/ftp/asl/asllvd/demos/verify_start_end_handshape_annotations//test_auto_move//signs_mov_separ_signers/Naomi_10.mov"; "MOV")"><Data ss:Type="String">MOV</Data></Cell></Row>
<Row ss:Index="7" ss:Height="13.8"><Cell ss:Formula="of:=HYPERLINK("http://csr.bu.edu/ftp/asl/asllvd/demos/verify_start_end_handshape_annotations//test_auto_move//signs_mov_separ_signers/Brady_10.mov"; "MOV")"><Data ss:Type="String">MOV</Data></Cell></Row>
i want to exctract these links to be like this
http://csr.bu.edu/ftp/asl/asllvd/demos/verify_start_end_handshape_annotations//test_auto_move//signs_mov_separ_signers/Liz_10.mov
how can i do this?
regex xml sublimetext3
edited Nov 17 '18 at 9:06
JohnyL
3,73811025
asked Nov 17 '18 at 1:01
Mustafa MancyMustafa Mancy
32
Where's theregexyou've attempted? That would be a start.
– l'L'l
Nov 17 '18 at 1:05
stackoverflow.com/a/1732454/62576
– Ken White
Nov 17 '18 at 1:10
add a comment |
-2
-2
-2
i have a xml file a lot of links and some other information
i want to extract these links from that xml to put them in another text file.
i am using sublime 3 so i want a regular expression to search for links inside the xml file
here is some of the file
<Row ss:Height="13.8"><Cell ss:Formula="of:=HYPERLINK("http://csr.bu.edu/ftp/asl/asllvd/demos/verify_start_end_handshape_annotations//test_auto_move//signs_mov_separ_signers/Liz_10.mov"; "MOV")"><Data ss:Type="String">MOV</Data></Cell></Row>
<Row ss:Height="13.8"><Cell ss:Formula="of:=HYPERLINK("http://csr.bu.edu/ftp/asl/asllvd/demos/verify_start_end_handshape_annotations//test_auto_move//signs_mov_separ_signers/Tyler_10.mov"; "MOV")"><Data ss:Type="String">MOV</Data></Cell></Row>
<Row ss:Height="13.8"><Cell ss:Formula="of:=HYPERLINK("http://csr.bu.edu/ftp/asl/asllvd/demos/verify_start_end_handshape_annotations//test_auto_move//signs_mov_separ_signers/Naomi_10.mov"; "MOV")"><Data ss:Type="String">MOV</Data></Cell></Row>
<Row ss:Index="7" ss:Height="13.8"><Cell ss:Formula="of:=HYPERLINK("http://csr.bu.edu/ftp/asl/asllvd/demos/verify_start_end_handshape_annotations//test_auto_move//signs_mov_separ_signers/Brady_10.mov"; "MOV")"><Data ss:Type="String">MOV</Data></Cell></Row>
i want to exctract these links to be like this
http://csr.bu.edu/ftp/asl/asllvd/demos/verify_start_end_handshape_annotations//test_auto_move//signs_mov_separ_signers/Liz_10.mov
how can i do this?
regex xml sublimetext3
edited Nov 17 '18 at 9:06
JohnyL
3,73811025
asked Nov 17 '18 at 1:01
Mustafa MancyMustafa Mancy
32
i have a xml file a lot of links and some other information
i want to extract these links from that xml to put them in another text file.
i am using sublime 3 so i want a regular expression to search for links inside the xml file
here is some of the file
<Row ss:Height="13.8"><Cell ss:Formula="of:=HYPERLINK("http://csr.bu.edu/ftp/asl/asllvd/demos/verify_start_end_handshape_annotations//test_auto_move//signs_mov_separ_signers/Liz_10.mov"; "MOV")"><Data ss:Type="String">MOV</Data></Cell></Row>
<Row ss:Height="13.8"><Cell ss:Formula="of:=HYPERLINK("http://csr.bu.edu/ftp/asl/asllvd/demos/verify_start_end_handshape_annotations//test_auto_move//signs_mov_separ_signers/Tyler_10.mov"; "MOV")"><Data ss:Type="String">MOV</Data></Cell></Row>
<Row ss:Height="13.8"><Cell ss:Formula="of:=HYPERLINK("http://csr.bu.edu/ftp/asl/asllvd/demos/verify_start_end_handshape_annotations//test_auto_move//signs_mov_separ_signers/Naomi_10.mov"; "MOV")"><Data ss:Type="String">MOV</Data></Cell></Row>
<Row ss:Index="7" ss:Height="13.8"><Cell ss:Formula="of:=HYPERLINK("http://csr.bu.edu/ftp/asl/asllvd/demos/verify_start_end_handshape_annotations//test_auto_move//signs_mov_separ_signers/Brady_10.mov"; "MOV")"><Data ss:Type="String">MOV</Data></Cell></Row>
i want to exctract these links to be like this
http://csr.bu.edu/ftp/asl/asllvd/demos/verify_start_end_handshape_annotations//test_auto_move//signs_mov_separ_signers/Liz_10.mov
how can i do this?
regex xml sublimetext3
regex xml sublimetext3
edited Nov 17 '18 at 9:06
JohnyL
3,73811025
asked Nov 17 '18 at 1:01
Mustafa MancyMustafa Mancy
32
edited Nov 17 '18 at 9:06
JohnyL
3,73811025
asked Nov 17 '18 at 1:01
Mustafa MancyMustafa Mancy
32
edited Nov 17 '18 at 9:06
JohnyL
3,73811025
edited Nov 17 '18 at 9:06
JohnyL
3,73811025
edited Nov 17 '18 at 9:06
JohnyL
3,73811025
3,73811025
asked Nov 17 '18 at 1:01
Mustafa MancyMustafa Mancy
32
asked Nov 17 '18 at 1:01
Mustafa MancyMustafa Mancy
32
asked Nov 17 '18 at 1:01
Mustafa MancyMustafa Mancy
32
32
Where's theregexyou've attempted? That would be a start.
– l'L'l
Nov 17 '18 at 1:05
stackoverflow.com/a/1732454/62576
– Ken White
Nov 17 '18 at 1:10
add a comment |
Where's theregexyou've attempted? That would be a start.
– l'L'l
Nov 17 '18 at 1:05
stackoverflow.com/a/1732454/62576
– Ken White
Nov 17 '18 at 1:10
Where's the
regex you've attempted? That would be a start.– l'L'l
Nov 17 '18 at 1:05
Where's the
regex you've attempted? That would be a start.– l'L'l
Nov 17 '18 at 1:05
stackoverflow.com/a/1732454/62576
– Ken White
Nov 17 '18 at 1:10
stackoverflow.com/a/1732454/62576
– Ken White
Nov 17 '18 at 1:10
add a comment |
1 Answer
1
active
oldest
votes
0
Not the best solution but it works
(http(s)??).+?(?=")
answered Nov 17 '18 at 1:32
Tom PowisTom Powis
459512
just another question what if i want to get the word WEAVE from that xml line how to do this ?<Row ss:Height="12.81"><Cell><Data ss:Type="String">WEAVE</Data></Cell></Row>
– Mustafa Mancy
Nov 17 '18 at 2:42
@MustafaMancy(?<=[>])[A-Z]+?(?=[<])
– Tom Powis
Nov 17 '18 at 20:54
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53347249%2fregular-expression-to-search-in-xml-file%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
0
Not the best solution but it works
(http(s)??).+?(?=")
answered Nov 17 '18 at 1:32
Tom PowisTom Powis
459512
just another question what if i want to get the word WEAVE from that xml line how to do this ?<Row ss:Height="12.81"><Cell><Data ss:Type="String">WEAVE</Data></Cell></Row>
– Mustafa Mancy
Nov 17 '18 at 2:42
@MustafaMancy(?<=[>])[A-Z]+?(?=[<])
– Tom Powis
Nov 17 '18 at 20:54
add a comment |
0
Not the best solution but it works
(http(s)??).+?(?=")
answered Nov 17 '18 at 1:32
Tom PowisTom Powis
459512
just another question what if i want to get the word WEAVE from that xml line how to do this ?<Row ss:Height="12.81"><Cell><Data ss:Type="String">WEAVE</Data></Cell></Row>
– Mustafa Mancy
Nov 17 '18 at 2:42
@MustafaMancy(?<=[>])[A-Z]+?(?=[<])
– Tom Powis
Nov 17 '18 at 20:54
add a comment |
0
0
0
Not the best solution but it works
(http(s)??).+?(?=")
answered Nov 17 '18 at 1:32
Tom PowisTom Powis
459512
Not the best solution but it works
(http(s)??).+?(?=")
answered Nov 17 '18 at 1:32
Tom PowisTom Powis
459512
answered Nov 17 '18 at 1:32
Tom PowisTom Powis
459512
answered Nov 17 '18 at 1:32
Tom PowisTom Powis
459512
answered Nov 17 '18 at 1:32
Tom PowisTom Powis
459512
459512
just another question what if i want to get the word WEAVE from that xml line how to do this ?<Row ss:Height="12.81"><Cell><Data ss:Type="String">WEAVE</Data></Cell></Row>
– Mustafa Mancy
Nov 17 '18 at 2:42
@MustafaMancy(?<=[>])[A-Z]+?(?=[<])
– Tom Powis
Nov 17 '18 at 20:54
add a comment |
just another question what if i want to get the word WEAVE from that xml line how to do this ?<Row ss:Height="12.81"><Cell><Data ss:Type="String">WEAVE</Data></Cell></Row>
– Mustafa Mancy
Nov 17 '18 at 2:42
@MustafaMancy(?<=[>])[A-Z]+?(?=[<])
– Tom Powis
Nov 17 '18 at 20:54
just another question what if i want to get the word WEAVE from that xml line how to do this ?
<Row ss:Height="12.81"><Cell><Data ss:Type="String">WEAVE</Data></Cell></Row>– Mustafa Mancy
Nov 17 '18 at 2:42
just another question what if i want to get the word WEAVE from that xml line how to do this ?
<Row ss:Height="12.81"><Cell><Data ss:Type="String">WEAVE</Data></Cell></Row>– Mustafa Mancy
Nov 17 '18 at 2:42
@MustafaMancy
(?<=[>])[A-Z]+?(?=[<])– Tom Powis
Nov 17 '18 at 20:54
@MustafaMancy
(?<=[>])[A-Z]+?(?=[<])– Tom Powis
Nov 17 '18 at 20:54
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53347249%2fregular-expression-to-search-in-xml-file%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Where's the
regexyou've attempted? That would be a start.– l'L'l
Nov 17 '18 at 1:05
stackoverflow.com/a/1732454/62576
– Ken White
Nov 17 '18 at 1:10