How to convert CSV file of strings seperated by a new line to arrayProblem with sed on a array containing...
Thought experiment and possible contradiction between electromagnetism and special relativity
Discussing work with supervisor in an invited dinner with his family
Can I get a PhD for developing an educational software?
Why did the population of Bhutan drop by 70% between 2007 and 2008?
How can I download a file from a host I can only SSH to through another host?
What's special ammo in Destiny 2?
Why is strlen so complex in C?
How to prevent a hosting company from accessing a VM's encryption keys?
Do you pay one or two mana to bounce a transformed Delver of Secrets with Repeal?
Why is adding AC power easier than adding DC power?
What does it take for witness testimony to be believed?
about to retire but not retired yet, employed but not working any more
Why does a sticker slowly peel off, but if it is pulled quickly it tears?
Which old Technic set included large yellow motor?
Changing JPEG to RAW to use on Lightroom?
Is first Ubuntu user root?
Who was the most successful German spy against Great Britain in WWII, from the contemporary German perspective?
Dealing with stress in coding interviews
Given current technology, could TV display screens double as video camera sensors?
What does rm -rf $(!!) mean?
Cooking Scrambled Eggs
Why is sh (not bash) complaining about functions defined in my .bashrc?
Can I renew my USA passport book and passport card separately?
Half filled water bottle
How to convert CSV file of strings seperated by a new line to array
Problem with sed on a array containing strings containing spacesHow to move or copy list of files referenced in a csv file to a new folderCSV file + set CSV parameters and values in bash scriptawk not doing a new lineBash: split multi line input into arrayHow do I form a new string from a parsed CSV line?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}
I have a csv file with data like this:
UserName
UserName
UserName
Each piece of data is seperated by a new line.
I need that data to be converted to an array of strings and stored in a variable.
How do I achieve this with just bash or shell execution?
bash shell
add a comment |
I have a csv file with data like this:
UserName
UserName
UserName
Each piece of data is seperated by a new line.
I need that data to be converted to an array of strings and stored in a variable.
How do I achieve this with just bash or shell execution?
bash shell
Can there be multiple strings per line (separated by space or even tab or comma)? If yes, should they be stored as one or as multiple values?
– Freddy
2 hours ago
only one string per line, theyre each stored as a single value. each string is only seperated by a new line
– David
2 hours ago
add a comment |
I have a csv file with data like this:
UserName
UserName
UserName
Each piece of data is seperated by a new line.
I need that data to be converted to an array of strings and stored in a variable.
How do I achieve this with just bash or shell execution?
bash shell
I have a csv file with data like this:
UserName
UserName
UserName
Each piece of data is seperated by a new line.
I need that data to be converted to an array of strings and stored in a variable.
How do I achieve this with just bash or shell execution?
bash shell
bash shell
asked 2 hours ago
DavidDavid
53 bronze badges
53 bronze badges
Can there be multiple strings per line (separated by space or even tab or comma)? If yes, should they be stored as one or as multiple values?
– Freddy
2 hours ago
only one string per line, theyre each stored as a single value. each string is only seperated by a new line
– David
2 hours ago
add a comment |
Can there be multiple strings per line (separated by space or even tab or comma)? If yes, should they be stored as one or as multiple values?
– Freddy
2 hours ago
only one string per line, theyre each stored as a single value. each string is only seperated by a new line
– David
2 hours ago
Can there be multiple strings per line (separated by space or even tab or comma)? If yes, should they be stored as one or as multiple values?
– Freddy
2 hours ago
Can there be multiple strings per line (separated by space or even tab or comma)? If yes, should they be stored as one or as multiple values?
– Freddy
2 hours ago
only one string per line, theyre each stored as a single value. each string is only seperated by a new line
– David
2 hours ago
only one string per line, theyre each stored as a single value. each string is only seperated by a new line
– David
2 hours ago
add a comment |
3 Answers
3
active
oldest
votes
With mapfile
:
$ mapfile -t array < <(cat yourfile)
$ declare -p array # print array content
declare -a array=([0]="UserName" [1]="UserName" [2]="UserName")
mapfile -t array < yourfile
will do here. mapfile reads stdin, process substitution isn't needed to read an existing file (unless you need to transform it in some way first, e.g. with grep or sed or awk). this is a UUOC with a pretty bell and collar :-) butmapfile
is a good answer, so +1.
– cas
1 hour ago
add a comment |
$ arr=($(<file.csv))
$ declare -p arr # print array content
declare -a arr=([0]="UserName" [1]="UserName" [2]="UserName")
arr=(…)
create array
$(<file.csv)
read filefile.csv
(like$(cat file.csv)
)
The elements are split at newline, space or tab characters and trimmed.
add a comment |
i=0
while read line
do
var[$i]="$line"
i=$((i+1))
done < filename
Here var array variable stores all names. And can be accessed by
echo ${var[0]}
echo ${var[1]}
...
...
New contributor
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "106"
};
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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%2funix.stackexchange.com%2fquestions%2f537566%2fhow-to-convert-csv-file-of-strings-seperated-by-a-new-line-to-array%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
With mapfile
:
$ mapfile -t array < <(cat yourfile)
$ declare -p array # print array content
declare -a array=([0]="UserName" [1]="UserName" [2]="UserName")
mapfile -t array < yourfile
will do here. mapfile reads stdin, process substitution isn't needed to read an existing file (unless you need to transform it in some way first, e.g. with grep or sed or awk). this is a UUOC with a pretty bell and collar :-) butmapfile
is a good answer, so +1.
– cas
1 hour ago
add a comment |
With mapfile
:
$ mapfile -t array < <(cat yourfile)
$ declare -p array # print array content
declare -a array=([0]="UserName" [1]="UserName" [2]="UserName")
mapfile -t array < yourfile
will do here. mapfile reads stdin, process substitution isn't needed to read an existing file (unless you need to transform it in some way first, e.g. with grep or sed or awk). this is a UUOC with a pretty bell and collar :-) butmapfile
is a good answer, so +1.
– cas
1 hour ago
add a comment |
With mapfile
:
$ mapfile -t array < <(cat yourfile)
$ declare -p array # print array content
declare -a array=([0]="UserName" [1]="UserName" [2]="UserName")
With mapfile
:
$ mapfile -t array < <(cat yourfile)
$ declare -p array # print array content
declare -a array=([0]="UserName" [1]="UserName" [2]="UserName")
edited 1 hour ago
answered 2 hours ago
guillermo chamorroguillermo chamorro
50112 bronze badges
50112 bronze badges
mapfile -t array < yourfile
will do here. mapfile reads stdin, process substitution isn't needed to read an existing file (unless you need to transform it in some way first, e.g. with grep or sed or awk). this is a UUOC with a pretty bell and collar :-) butmapfile
is a good answer, so +1.
– cas
1 hour ago
add a comment |
mapfile -t array < yourfile
will do here. mapfile reads stdin, process substitution isn't needed to read an existing file (unless you need to transform it in some way first, e.g. with grep or sed or awk). this is a UUOC with a pretty bell and collar :-) butmapfile
is a good answer, so +1.
– cas
1 hour ago
mapfile -t array < yourfile
will do here. mapfile reads stdin, process substitution isn't needed to read an existing file (unless you need to transform it in some way first, e.g. with grep or sed or awk). this is a UUOC with a pretty bell and collar :-) but mapfile
is a good answer, so +1.– cas
1 hour ago
mapfile -t array < yourfile
will do here. mapfile reads stdin, process substitution isn't needed to read an existing file (unless you need to transform it in some way first, e.g. with grep or sed or awk). this is a UUOC with a pretty bell and collar :-) but mapfile
is a good answer, so +1.– cas
1 hour ago
add a comment |
$ arr=($(<file.csv))
$ declare -p arr # print array content
declare -a arr=([0]="UserName" [1]="UserName" [2]="UserName")
arr=(…)
create array
$(<file.csv)
read filefile.csv
(like$(cat file.csv)
)
The elements are split at newline, space or tab characters and trimmed.
add a comment |
$ arr=($(<file.csv))
$ declare -p arr # print array content
declare -a arr=([0]="UserName" [1]="UserName" [2]="UserName")
arr=(…)
create array
$(<file.csv)
read filefile.csv
(like$(cat file.csv)
)
The elements are split at newline, space or tab characters and trimmed.
add a comment |
$ arr=($(<file.csv))
$ declare -p arr # print array content
declare -a arr=([0]="UserName" [1]="UserName" [2]="UserName")
arr=(…)
create array
$(<file.csv)
read filefile.csv
(like$(cat file.csv)
)
The elements are split at newline, space or tab characters and trimmed.
$ arr=($(<file.csv))
$ declare -p arr # print array content
declare -a arr=([0]="UserName" [1]="UserName" [2]="UserName")
arr=(…)
create array
$(<file.csv)
read filefile.csv
(like$(cat file.csv)
)
The elements are split at newline, space or tab characters and trimmed.
edited 2 hours ago
answered 2 hours ago
FreddyFreddy
6,8481 gold badge6 silver badges24 bronze badges
6,8481 gold badge6 silver badges24 bronze badges
add a comment |
add a comment |
i=0
while read line
do
var[$i]="$line"
i=$((i+1))
done < filename
Here var array variable stores all names. And can be accessed by
echo ${var[0]}
echo ${var[1]}
...
...
New contributor
add a comment |
i=0
while read line
do
var[$i]="$line"
i=$((i+1))
done < filename
Here var array variable stores all names. And can be accessed by
echo ${var[0]}
echo ${var[1]}
...
...
New contributor
add a comment |
i=0
while read line
do
var[$i]="$line"
i=$((i+1))
done < filename
Here var array variable stores all names. And can be accessed by
echo ${var[0]}
echo ${var[1]}
...
...
New contributor
i=0
while read line
do
var[$i]="$line"
i=$((i+1))
done < filename
Here var array variable stores all names. And can be accessed by
echo ${var[0]}
echo ${var[1]}
...
...
New contributor
New contributor
answered 2 hours ago
NaviNavi
1
1
New contributor
New contributor
add a comment |
add a comment |
Thanks for contributing an answer to Unix & Linux Stack Exchange!
- 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%2funix.stackexchange.com%2fquestions%2f537566%2fhow-to-convert-csv-file-of-strings-seperated-by-a-new-line-to-array%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
Can there be multiple strings per line (separated by space or even tab or comma)? If yes, should they be stored as one or as multiple values?
– Freddy
2 hours ago
only one string per line, theyre each stored as a single value. each string is only seperated by a new line
– David
2 hours ago