scp command changing csv delimiter
I have csv file created at a location everyday with a delimiter þ.
I have an automated job which needs to transfer this to another linux machine.
The automated job(running as root user) while accessing and dropping the file, changes all delimiters in the file to ?
There is another user 'app' who only has access to drop the file, thus the command as below.
I'm using jcraft session with below command.
scp -v -r abc.csv app@targetIP:/xyzlocation
Can anyone please tell me what am I doing wrong?
If I run the same job logged in as 'app' this issue doesn't happen. Only when job running as root user has this issue.
linux scp
edited Jan 6 at 11:25
Toto
3,62591226
asked Jan 6 at 9:38
Sun SuSun Su
1
New contributor
Sun Su is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I have csv file created at a location everyday with a delimiter þ.
I have an automated job which needs to transfer this to another linux machine.
The automated job(running as root user) while accessing and dropping the file, changes all delimiters in the file to ?
There is another user 'app' who only has access to drop the file, thus the command as below.
I'm using jcraft session with below command.
scp -v -r abc.csv app@targetIP:/xyzlocation
Can anyone please tell me what am I doing wrong?
If I run the same job logged in as 'app' this issue doesn't happen. Only when job running as root user has this issue.
linux scp
edited Jan 6 at 11:25
Toto
3,62591226
asked Jan 6 at 9:38
Sun SuSun Su
1
New contributor
Sun Su is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Thescpprogram normally copies files verbatim. If you're seeing '?' characters, that indicates an issue with the character set that you're using to view the file. Chances are that the file is being copied properly, but whatever you're using to view or parse the file can't handle the delimiter character.
– Kenster
Jan 6 at 15:37
add a comment |
I have csv file created at a location everyday with a delimiter þ.
I have an automated job which needs to transfer this to another linux machine.
The automated job(running as root user) while accessing and dropping the file, changes all delimiters in the file to ?
There is another user 'app' who only has access to drop the file, thus the command as below.
I'm using jcraft session with below command.
scp -v -r abc.csv app@targetIP:/xyzlocation
Can anyone please tell me what am I doing wrong?
If I run the same job logged in as 'app' this issue doesn't happen. Only when job running as root user has this issue.
linux scp
edited Jan 6 at 11:25
Toto
3,62591226
asked Jan 6 at 9:38
Sun SuSun Su
1
New contributor
Sun Su is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I have csv file created at a location everyday with a delimiter þ.
I have an automated job which needs to transfer this to another linux machine.
The automated job(running as root user) while accessing and dropping the file, changes all delimiters in the file to ?
There is another user 'app' who only has access to drop the file, thus the command as below.
I'm using jcraft session with below command.
scp -v -r abc.csv app@targetIP:/xyzlocation
Can anyone please tell me what am I doing wrong?
If I run the same job logged in as 'app' this issue doesn't happen. Only when job running as root user has this issue.
linux scp
linux scp
edited Jan 6 at 11:25
Toto
3,62591226
asked Jan 6 at 9:38
Sun SuSun Su
1
New contributor
Sun Su is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited Jan 6 at 11:25
Toto
3,62591226
asked Jan 6 at 9:38
Sun SuSun Su
1
New contributor
Sun Su is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited Jan 6 at 11:25
Toto
3,62591226
edited Jan 6 at 11:25
Toto
3,62591226
edited Jan 6 at 11:25
Toto
3,62591226
3,62591226
asked Jan 6 at 9:38
Sun SuSun Su
1
New contributor
Sun Su is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked Jan 6 at 9:38
Sun SuSun Su
1
asked Jan 6 at 9:38
Sun SuSun Su
1
1
New contributor
Sun Su is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Sun Su is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Sun Su is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Thescpprogram normally copies files verbatim. If you're seeing '?' characters, that indicates an issue with the character set that you're using to view the file. Chances are that the file is being copied properly, but whatever you're using to view or parse the file can't handle the delimiter character.
– Kenster
Jan 6 at 15:37
add a comment |
Thescpprogram normally copies files verbatim. If you're seeing '?' characters, that indicates an issue with the character set that you're using to view the file. Chances are that the file is being copied properly, but whatever you're using to view or parse the file can't handle the delimiter character.
– Kenster
Jan 6 at 15:37
The
scp program normally copies files verbatim. If you're seeing '?' characters, that indicates an issue with the character set that you're using to view the file. Chances are that the file is being copied properly, but whatever you're using to view or parse the file can't handle the delimiter character.– Kenster
Jan 6 at 15:37
The
scp program normally copies files verbatim. If you're seeing '?' characters, that indicates an issue with the character set that you're using to view the file. Chances are that the file is being copied properly, but whatever you're using to view or parse the file can't handle the delimiter character.– Kenster
Jan 6 at 15:37
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
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
});
}
});
Sun Su is a new contributor. Be nice, and check out our Code of Conduct.
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%2fsuperuser.com%2fquestions%2f1391107%2fscp-command-changing-csv-delimiter%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Sun Su is a new contributor. Be nice, and check out our Code of Conduct.
Sun Su is a new contributor. Be nice, and check out our Code of Conduct.
Sun Su is a new contributor. Be nice, and check out our Code of Conduct.
Sun Su is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Super User!
- 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%2fsuperuser.com%2fquestions%2f1391107%2fscp-command-changing-csv-delimiter%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
The
scpprogram normally copies files verbatim. If you're seeing '?' characters, that indicates an issue with the character set that you're using to view the file. Chances are that the file is being copied properly, but whatever you're using to view or parse the file can't handle the delimiter character.– Kenster
Jan 6 at 15:37