Mixing
how to get values from list string in neo4j cypher
-1
I have a value of ["1-0", "4-0"] in a variable score from which I want to get 4 and 0 separately and return them
RETURN toInteger(trim(r.scoreHTFT[1])) returns null
string list neo4j cypher
edited Jan 6 at 11:14
SHR
6,05872544
asked Jan 2 at 7:39
Euclid StonnaEuclid Stonna
12
add a comment |
-1
I have a value of ["1-0", "4-0"] in a variable score from which I want to get 4 and 0 separately and return them
RETURN toInteger(trim(r.scoreHTFT[1])) returns null
string list neo4j cypher
edited Jan 6 at 11:14
SHR
6,05872544
asked Jan 2 at 7:39
Euclid StonnaEuclid Stonna
12
Don't you also want to get "1" and "0' separately? Or do you always want the results for the last list element, or the second one -- or are you trying to do something else?
– cybersam
Jan 3 at 18:21
I have found the answer I have been looking for. Thank you for your interest. As of your question I wanted the value 4 and 0 returned not the 1 and 0.
– Euclid Stonna
Jan 4 at 7:20
add a comment |
-1
-1
-1
I have a value of ["1-0", "4-0"] in a variable score from which I want to get 4 and 0 separately and return them
RETURN toInteger(trim(r.scoreHTFT[1])) returns null
string list neo4j cypher
edited Jan 6 at 11:14
SHR
6,05872544
asked Jan 2 at 7:39
Euclid StonnaEuclid Stonna
12
I have a value of ["1-0", "4-0"] in a variable score from which I want to get 4 and 0 separately and return them
RETURN toInteger(trim(r.scoreHTFT[1])) returns null
string list neo4j cypher
string list neo4j cypher
edited Jan 6 at 11:14
SHR
6,05872544
asked Jan 2 at 7:39
Euclid StonnaEuclid Stonna
12
edited Jan 6 at 11:14
SHR
6,05872544
asked Jan 2 at 7:39
Euclid StonnaEuclid Stonna
12
edited Jan 6 at 11:14
SHR
6,05872544
edited Jan 6 at 11:14
SHR
6,05872544
edited Jan 6 at 11:14
SHR
6,05872544
6,05872544
asked Jan 2 at 7:39
Euclid StonnaEuclid Stonna
12
asked Jan 2 at 7:39
Euclid StonnaEuclid Stonna
12
asked Jan 2 at 7:39
Euclid StonnaEuclid Stonna
12
12
Don't you also want to get "1" and "0' separately? Or do you always want the results for the last list element, or the second one -- or are you trying to do something else?
– cybersam
Jan 3 at 18:21
I have found the answer I have been looking for. Thank you for your interest. As of your question I wanted the value 4 and 0 returned not the 1 and 0.
– Euclid Stonna
Jan 4 at 7:20
add a comment |
Don't you also want to get "1" and "0' separately? Or do you always want the results for the last list element, or the second one -- or are you trying to do something else?
– cybersam
Jan 3 at 18:21
I have found the answer I have been looking for. Thank you for your interest. As of your question I wanted the value 4 and 0 returned not the 1 and 0.
– Euclid Stonna
Jan 4 at 7:20
Don't you also want to get "1" and "0' separately? Or do you always want the results for the last list element, or the second one -- or are you trying to do something else?
– cybersam
Jan 3 at 18:21
Don't you also want to get "1" and "0' separately? Or do you always want the results for the last list element, or the second one -- or are you trying to do something else?
– cybersam
Jan 3 at 18:21
I have found the answer I have been looking for. Thank you for your interest. As of your question I wanted the value 4 and 0 returned not the 1 and 0.
– Euclid Stonna
Jan 4 at 7:20
I have found the answer I have been looking for. Thank you for your interest. As of your question I wanted the value 4 and 0 returned not the 1 and 0.
– Euclid Stonna
Jan 4 at 7:20
add a comment |
2 Answers
2
active
oldest
votes
0
you can try for this
UNWIND ["15-2","18-1"] as r
with split(r,"-") as splitFromDash
return toInteger(splitFromDash[1])
answered Jan 2 at 7:46
VipulVipul
474312
add a comment |
0
I have answered a similar question here.
It may be some help to you.
answered Jan 2 at 8:23
RajRaj
846514
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%2f54002805%2fhow-to-get-values-from-list-string-in-neo4j-cypher%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
0
you can try for this
UNWIND ["15-2","18-1"] as r
with split(r,"-") as splitFromDash
return toInteger(splitFromDash[1])
answered Jan 2 at 7:46
VipulVipul
474312
add a comment |
0
you can try for this
UNWIND ["15-2","18-1"] as r
with split(r,"-") as splitFromDash
return toInteger(splitFromDash[1])
answered Jan 2 at 7:46
VipulVipul
474312
add a comment |
0
0
0
you can try for this
UNWIND ["15-2","18-1"] as r
with split(r,"-") as splitFromDash
return toInteger(splitFromDash[1])
answered Jan 2 at 7:46
VipulVipul
474312
you can try for this
UNWIND ["15-2","18-1"] as r
with split(r,"-") as splitFromDash
return toInteger(splitFromDash[1])
answered Jan 2 at 7:46
VipulVipul
474312
edited Jan 2 at 7:51
answered Jan 2 at 7:46
VipulVipul
474312
answered Jan 2 at 7:46
VipulVipul
474312
answered Jan 2 at 7:46
VipulVipul
474312
474312
add a comment |
add a comment |
0
I have answered a similar question here.
It may be some help to you.
answered Jan 2 at 8:23
RajRaj
846514
add a comment |
0
I have answered a similar question here.
It may be some help to you.
answered Jan 2 at 8:23
RajRaj
846514
add a comment |
0
0
0
I have answered a similar question here.
It may be some help to you.
answered Jan 2 at 8:23
RajRaj
846514
I have answered a similar question here.
It may be some help to you.
answered Jan 2 at 8:23
RajRaj
846514
answered Jan 2 at 8:23
RajRaj
846514
answered Jan 2 at 8:23
RajRaj
846514
answered Jan 2 at 8:23
RajRaj
846514
846514
add a comment |
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%2f54002805%2fhow-to-get-values-from-list-string-in-neo4j-cypher%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
Don't you also want to get "1" and "0' separately? Or do you always want the results for the last list element, or the second one -- or are you trying to do something else?
– cybersam
Jan 3 at 18:21
I have found the answer I have been looking for. Thank you for your interest. As of your question I wanted the value 4 and 0 returned not the 1 and 0.
– Euclid Stonna
Jan 4 at 7:20