Bash array variable into single space elements

Question

I'm trying to print a word from variable with multiple elements using array. Here is a script:

location=($(here mysql query to extract name of locations))
for i in "${location[@]}"; do
    echo "$i"
done

But these location name contains spaces: MUMBAI - BORIVALI, DELHI - LAJPATNAGAR and so on. So it prints like: Output in debug mode:

   + for i in '"${LOCATION[@]}"'
+ echo DELHI
DELHI
+ for i in '"${LOCATION[@]}"'
+ echo -
-
+ for i in '"${LOCATION[@]}"'
+ echo LAJPATNAGAR
LAJPATNAGAR
+ for i in '"${LOCATION[@]}"'
+ echo MUMBAI
MUMBAI
+ for i in '"${LOCATION[@]}"'
+ echo -
-
+ for i in '"${LOCATION[@]}"'
+ echo BORIVLI
BORIVLI

I've tried with double quotes:

location=("$(here mysql query to extract name of locations)")

then output is

+ for i in '"${LOCATION[@]}"'
+ echo 'DELHI - LAJPATNAGAR
MUMBAI - BORIVLI'

together.

I want output:

+ echo 'DELHI - LAJPATNAGAR'
DELHI - LAJPATNAGAR
+ echo 'MUMBAI - BORIVLI'
MUMBAI - BORIVLI

Your edit shows commas between fields, is that correct? In that case you can set IFS to a comma. Please ensure that you show exactly what is produced by mysql. — cdarke
– cdarke, Commented May 16, 2018 at 7:08
@cdarke commas only in the question to show different location name — Lnux
– Lnux, Commented May 16, 2018 at 7:10
Your new edit shows hyphens between the fields, is that correct? — cdarke
– cdarke, Commented May 16, 2018 at 7:10
Why don't we eliminate the guessing and you post the first 10-lines of $(here mysql query to extract name of locations)? — David C. Rankin
– David C. Rankin, Commented May 16, 2018 at 7:21
yes there is hyphens and mysql query only contains the name of table and conditions. You can consider MUMBAI - BORIVLI and DELHI - LAJPATNAGAR as different value in column for better understanding. — Lnux
– Lnux, Commented May 16, 2018 at 7:25

choroba · Accepted Answer · 2018-05-16 08:31:05Z

1

If the locations don't contain newlines, you can try

while read -r location ; do
    echo "$location"
done < <(mysql ...)

read reads line by line if given just one parameter. By default, it reads from stdin, but with process substitution, we redirected output of the mysql command to it.

edited May 16, 2018 at 8:31

answered May 16, 2018 at 7:08

choroba

245k27 gold badges221 silver badges304 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

choroba Over a year ago

@Lnux: Updated.

iBug · Accepted Answer · 2018-05-16 07:11:24Z

0

Try setting IFS to newline-only:

IFS="$(echo)"
location=($(here mysql query to extract name of locations))
for i in "${location[@]}"; do
    echo "$i"
done

Example with test.txt:

A B C
D E
F

Run the above code, replacing the MySQL query with cat test.txt. Output:

A B C
D E
F

If you drop the IFS="$(echo)" line, you will get each letter on a separate line.

edited May 16, 2018 at 7:11

answered May 16, 2018 at 7:03

iBug

37.6k8 gold badges101 silver badges155 bronze badges

4 Comments

Lnux Over a year ago

No wait. .. the actual name of locations are different. Let me modify the questions. Its not llike 1 2

iBug Over a year ago

@Lnux Then just group them by three. If the number of spaces are not the same across all names, you're out of luck or need some other tricks.

iBug Over a year ago

@Lnux Updated and changed to another solution.

Lnux Over a year ago

Output is still together

cdarke · Accepted Answer · 2018-05-16 07:19:14Z

0

Just count 3 fields:

location=($(here mysql query to extract name of locations))

for ((i=0; i <= ${#location}; i+=3))
do
    echo "${location[i]} ${location[i+1]} ${location[i+2]}"
done

answered May 16, 2018 at 7:19

cdarke

44.8k8 gold badges85 silver badges86 bronze badges

Collectives™ on Stack Overflow

Bash array variable into single space elements

3 Answers 3

1 Comment

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related