Extract text from Google Sheets using REGEXExtract
I'm trying to extract the company name from these text strings in Google Sheets. However, I can't get my head wrapped around regular expressions and regexextract.
Strings:
S-1 - Wealthbridge Acquisition Ltd (0001753673) (Filer)
S-1/A - KinerjaPay Corp. (0001494162) (Filer)
S-1 - CYTY CAPITAL SOLUTIONS INC (0001762609) (Filer)
S-1/A - NORTHWEST OIL & GAS TRADING COMPANY, INC. (0001762533) (Filer)
Intended result:
Wealthbridge Acquisition Ltd
KinerjaPay Corp.
CYTY CAPITAL SOLUTIONS INC
NORTHWEST OIL & GAS TRADING COMPANY, INC.
I've tried reading the Google Sheets documentation on REGEXExtract and many other sources, but none of it makes sense. I would turn to YouTube but unfortunately that's blocked at work. Thanks in advance community!
I tried this: =REGEXEXTRACT(A2,"s(.*)(")
which is getting closer but I still have no clue what I'm doing.
EDIT: Holy macaroni I figured it out! I'm not sure how it works, but it works.
=REGEXEXTRACT(A2,"s(w.*)(0")
regex google-sheets re2
asked Dec 27 '18 at 21:47
Adil Najmuddin
32
add a comment |
I'm trying to extract the company name from these text strings in Google Sheets. However, I can't get my head wrapped around regular expressions and regexextract.
Strings:
S-1 - Wealthbridge Acquisition Ltd (0001753673) (Filer)
S-1/A - KinerjaPay Corp. (0001494162) (Filer)
S-1 - CYTY CAPITAL SOLUTIONS INC (0001762609) (Filer)
S-1/A - NORTHWEST OIL & GAS TRADING COMPANY, INC. (0001762533) (Filer)
Intended result:
Wealthbridge Acquisition Ltd
KinerjaPay Corp.
CYTY CAPITAL SOLUTIONS INC
NORTHWEST OIL & GAS TRADING COMPANY, INC.
I've tried reading the Google Sheets documentation on REGEXExtract and many other sources, but none of it makes sense. I would turn to YouTube but unfortunately that's blocked at work. Thanks in advance community!
I tried this: =REGEXEXTRACT(A2,"s(.*)(")
which is getting closer but I still have no clue what I'm doing.
EDIT: Holy macaroni I figured it out! I'm not sure how it works, but it works.
=REGEXEXTRACT(A2,"s(w.*)(0")
regex google-sheets re2
asked Dec 27 '18 at 21:47
Adil Najmuddin
32
add a comment |
I'm trying to extract the company name from these text strings in Google Sheets. However, I can't get my head wrapped around regular expressions and regexextract.
Strings:
S-1 - Wealthbridge Acquisition Ltd (0001753673) (Filer)
S-1/A - KinerjaPay Corp. (0001494162) (Filer)
S-1 - CYTY CAPITAL SOLUTIONS INC (0001762609) (Filer)
S-1/A - NORTHWEST OIL & GAS TRADING COMPANY, INC. (0001762533) (Filer)
Intended result:
Wealthbridge Acquisition Ltd
KinerjaPay Corp.
CYTY CAPITAL SOLUTIONS INC
NORTHWEST OIL & GAS TRADING COMPANY, INC.
I've tried reading the Google Sheets documentation on REGEXExtract and many other sources, but none of it makes sense. I would turn to YouTube but unfortunately that's blocked at work. Thanks in advance community!
I tried this: =REGEXEXTRACT(A2,"s(.*)(")
which is getting closer but I still have no clue what I'm doing.
EDIT: Holy macaroni I figured it out! I'm not sure how it works, but it works.
=REGEXEXTRACT(A2,"s(w.*)(0")
regex google-sheets re2
asked Dec 27 '18 at 21:47
Adil Najmuddin
32
I'm trying to extract the company name from these text strings in Google Sheets. However, I can't get my head wrapped around regular expressions and regexextract.
Strings:
S-1 - Wealthbridge Acquisition Ltd (0001753673) (Filer)
S-1/A - KinerjaPay Corp. (0001494162) (Filer)
S-1 - CYTY CAPITAL SOLUTIONS INC (0001762609) (Filer)
S-1/A - NORTHWEST OIL & GAS TRADING COMPANY, INC. (0001762533) (Filer)
Intended result:
Wealthbridge Acquisition Ltd
KinerjaPay Corp.
CYTY CAPITAL SOLUTIONS INC
NORTHWEST OIL & GAS TRADING COMPANY, INC.
I've tried reading the Google Sheets documentation on REGEXExtract and many other sources, but none of it makes sense. I would turn to YouTube but unfortunately that's blocked at work. Thanks in advance community!
I tried this: =REGEXEXTRACT(A2,"s(.*)(")
which is getting closer but I still have no clue what I'm doing.
EDIT: Holy macaroni I figured it out! I'm not sure how it works, but it works.
=REGEXEXTRACT(A2,"s(w.*)(0")
regex google-sheets re2
regex google-sheets re2
asked Dec 27 '18 at 21:47
Adil Najmuddin
32
asked Dec 27 '18 at 21:47
Adil Najmuddin
32
edited Dec 27 '18 at 22:38
asked Dec 27 '18 at 21:47
Adil Najmuddin
32
asked Dec 27 '18 at 21:47
Adil Najmuddin
32
asked Dec 27 '18 at 21:47
Adil Najmuddin
32
32
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Assuming all follows that pattern ( dash name of company (number) ) the following works using REGEXEXTRACT.
=REGEXEXTRACT(A2; "-s([^(]+)")
My goal was to match the dash, after the space (s) and after that GROUP everything one or more times until i found a parenthesis on the string.
Also, i used regex101 to verify the pattern and made it work on google sheet.
answered Dec 27 '18 at 23:28
lucas_7_94
14616
I saw you edited your post, want to clarify your code will work except if the first number on the parenthesis isn't zero so, be carefull with that.
– lucas_7_94
Dec 27 '18 at 23:31
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
});
}
});
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%2f53951200%2fextract-text-from-google-sheets-using-regexextract%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
Assuming all follows that pattern ( dash name of company (number) ) the following works using REGEXEXTRACT.
=REGEXEXTRACT(A2; "-s([^(]+)")
My goal was to match the dash, after the space (s) and after that GROUP everything one or more times until i found a parenthesis on the string.
Also, i used regex101 to verify the pattern and made it work on google sheet.
answered Dec 27 '18 at 23:28
lucas_7_94
14616
I saw you edited your post, want to clarify your code will work except if the first number on the parenthesis isn't zero so, be carefull with that.
– lucas_7_94
Dec 27 '18 at 23:31
add a comment |
Assuming all follows that pattern ( dash name of company (number) ) the following works using REGEXEXTRACT.
=REGEXEXTRACT(A2; "-s([^(]+)")
My goal was to match the dash, after the space (s) and after that GROUP everything one or more times until i found a parenthesis on the string.
Also, i used regex101 to verify the pattern and made it work on google sheet.
answered Dec 27 '18 at 23:28
lucas_7_94
14616
I saw you edited your post, want to clarify your code will work except if the first number on the parenthesis isn't zero so, be carefull with that.
– lucas_7_94
Dec 27 '18 at 23:31
add a comment |
Assuming all follows that pattern ( dash name of company (number) ) the following works using REGEXEXTRACT.
=REGEXEXTRACT(A2; "-s([^(]+)")
My goal was to match the dash, after the space (s) and after that GROUP everything one or more times until i found a parenthesis on the string.
Also, i used regex101 to verify the pattern and made it work on google sheet.
answered Dec 27 '18 at 23:28
lucas_7_94
14616
Assuming all follows that pattern ( dash name of company (number) ) the following works using REGEXEXTRACT.
=REGEXEXTRACT(A2; "-s([^(]+)")
My goal was to match the dash, after the space (s) and after that GROUP everything one or more times until i found a parenthesis on the string.
Also, i used regex101 to verify the pattern and made it work on google sheet.
answered Dec 27 '18 at 23:28
lucas_7_94
14616
answered Dec 27 '18 at 23:28
lucas_7_94
14616
answered Dec 27 '18 at 23:28
lucas_7_94
14616
answered Dec 27 '18 at 23:28
lucas_7_94
14616
14616
I saw you edited your post, want to clarify your code will work except if the first number on the parenthesis isn't zero so, be carefull with that.
– lucas_7_94
Dec 27 '18 at 23:31
add a comment |
I saw you edited your post, want to clarify your code will work except if the first number on the parenthesis isn't zero so, be carefull with that.
– lucas_7_94
Dec 27 '18 at 23:31
I saw you edited your post, want to clarify your code will work except if the first number on the parenthesis isn't zero so, be carefull with that.
– lucas_7_94
Dec 27 '18 at 23:31
I saw you edited your post, want to clarify your code will work except if the first number on the parenthesis isn't zero so, be carefull with that.
– lucas_7_94
Dec 27 '18 at 23:31
add a comment |
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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.
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%2f53951200%2fextract-text-from-google-sheets-using-regexextract%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
