Sponsored Content
Top Forums Shell Programming and Scripting Splitting comma separated values into an array Post 76130 by tmarikle on Friday 24th of June 2005 04:50:33 PM
Old 06-24-2005
Splitting comma separated values into an array

I'm attempting to create a KSH array out of a string like this: ",,,value1,value2,,"

I have created the array but I only get two elements, one for value1 and one for value2.

I have ended up with something like this but I don't like it:
Code:
set -A JUNK
xx=0
for i in $(print ",,,value1,value2,,"  | nawk '{gsub(/,/," \n",$0);print}')
do
    print ".$i."
    JUNK[xx]=$i
    (( xx += 1 ))
done
for i in "${JUNK[@]}"
do
    print ".$i."
done

The results:
Code:
. .
. .
. .
.value1 .
.value2 .
. .
. .

If i leave out the space character before the newline in this gsub command:
Code:
gsub(/,/," \n",$0);

...I get this output:
Code:
.value1 .
.value2 .

I really don't want the spaces at the end of each string and I nead an array of every CSV field (even the empty values).

I have tried several approaches including changing IFS and looping through the fields but this doesn't seem to work at all.

What am I missing here?

Thomas
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Extracting the values separated by comma

Hi, I have a variable which has a list of string separated by comma. for ex , Variable=/usr/bin,/usr/smrshbin,/tmp How can i get the values between the commas separately using shell scripts.Please help me. Thanks, Padmini. (6 Replies)
Discussion started by: padmisri
6 Replies

2. Shell Programming and Scripting

script to store comma separated values in different variables

Hello friends, I need ur help.I want to write a script. The script should read contents from a file namely xyz. e.g xyz abcd,1234,efgh,7854378 dhnsa,dsakjkdl,43432,ZXDsa the script should store comma (,) seperated values in different variables. Once pointer will reach end of line (\n), it should... (1 Reply)
Discussion started by: akhtar.bhat
1 Replies

3. Shell Programming and Scripting

Input Validation of comma separated values

Hello all, I am working on a script and have the first part solved of numerical input validation. Below the code validates that the input is a numerical value between 100 and 1000. If not, it errors out. Now I need to be able to read values separated by a comma. For example, instead of my... (5 Replies)
Discussion started by: LinuxRacr
5 Replies

4. Shell Programming and Scripting

Assigning Multiple Comma Separated IP's To A Bash Array

I am in the process of creating a BASH shell scripts for a project at work. So the scenario is as such: I have a file with each line entry separated by ':' ... (3 Replies)
Discussion started by: metallica1973
3 Replies

5. Shell Programming and Scripting

To agregate Comma separated values

Hi pls help me to get the code: i have a file in which content is : 2.01304E+11 2.01304E+11 ori 2 01:00 2.01304E+11 2.01304E+11 ori 2 01:02 2.01304E+11 2.01304E+11 ori 3 01:02 2.01304E+11 2.01304E+11 ori 3 ... (7 Replies)
Discussion started by: Aditya.Gurgaon
7 Replies

6. UNIX for Dummies Questions & Answers

[solved] Comma separated values to space separated

Hi, I have a large number of files which are written as csv (comma-separated values). Does anyone know of simple sed/awk command do achieve this? Thanks! ---------- Post updated at 10:59 AM ---------- Previous update was at 10:54 AM ---------- Guess I asked this too soon. Found the... (0 Replies)
Discussion started by: lost.identity
0 Replies

7. Shell Programming and Scripting

Needs help in parsing comma separated values

hello experts, i am retrieving values in variables jobKey and jobName within my shell script. these values are returned to me within braces and i am using following command to remove those braces: jobKeys=`echo $jobKeys | sed 's:^.\(.*\).$:\1:'` jobNames=`echo $jobNames | sed... (1 Reply)
Discussion started by: avikaljain
1 Replies

8. Shell Programming and Scripting

Comma separated values to individual lines

My OS : RHEL 6.7 I have a text file with comma separated values like below $ cat testString.txt 'JOHN' , 'KEITH' , 'NEWMAN' , 'URSULA' , 'ARIANNA' , 'CHENG', . . . . I want these values to appear like below 'JOHN' , 'KEITH' , 'NEWMAN' , 'URSULA' , 'ARIANNA' , 'CHENG', .... (4 Replies)
Discussion started by: kraljic
4 Replies

9. Shell Programming and Scripting

Assign comma separated values to a variable

Hi All, I wrote a database command that queries our application and outputs a whole bunch of values to a text file. I need to assign the output to two values. Here is a sample of the output: valueOne, checkOne valueTwo, checkTwo valueThree, checkThree I would like... (9 Replies)
Discussion started by: jeffs42885
9 Replies

10. Shell Programming and Scripting

Convert fixed value fields to comma separated values

Hi All, Hope you are doing Great!!!. Today i have came up with a problem to say exactly it was for performance improvement. I have written code in perl as a solution for this to cut in specific range, but it is taking time to run for files thousands of lines so i am expecting a sed... (9 Replies)
Discussion started by: mad man
9 Replies
Dumpvalue(3pm)						 Perl Programmers Reference Guide					    Dumpvalue(3pm)

NAME
Dumpvalue - provides screen dump of Perl data. SYNOPSIS
use Dumpvalue; my $dumper = Dumpvalue->new; $dumper->set(globPrint => 1); $dumper->dumpValue(*::); $dumper->dumpvars('main'); my $dump = $dumper->stringify($some_value); DESCRIPTION
Creation A new dumper is created by a call $d = Dumpvalue->new(option1 => value1, option2 => value2) Recognized options: "arrayDepth", "hashDepth" Print only first N elements of arrays and hashes. If false, prints all the elements. "compactDump", "veryCompact" Change style of array and hash dump. If true, short array may be printed on one line. "globPrint" Whether to print contents of globs. "dumpDBFiles" Dump arrays holding contents of debugged files. "dumpPackages" Dump symbol tables of packages. "dumpReused" Dump contents of "reused" addresses. "tick", "quoteHighBit", "printUndef" Change style of string dump. Default value of "tick" is "auto", one can enable either double-quotish dump, or single-quotish by setting it to """ or "'". By default, characters with high bit set are printed as is. If "quoteHighBit" is set, they will be quoted. "usageOnly" rudimentally per-package memory usage dump. If set, "dumpvars" calculates total size of strings in variables in the package. unctrl Changes the style of printout of strings. Possible values are "unctrl" and "quote". subdump Whether to try to find the subroutine name given the reference. bareStringify Whether to write the non-overloaded form of the stringify-overloaded objects. quoteHighBit Whether to print chars with high bit set in binary or "as is". stopDbSignal Whether to abort printing if debugger signal flag is raised. Later in the life of the object the methods may be queries with get() method and set() method (which accept multiple arguments). Methods dumpValue $dumper->dumpValue($value); $dumper->dumpValue([$value1, $value2]); Prints a dump to the currently selected filehandle. dumpValues $dumper->dumpValues($value1, $value2); Same as "$dumper->dumpValue([$value1, $value2]);". stringify my $dump = $dumper->stringify($value [,$noticks] ); Returns the dump of a single scalar without printing. If the second argument is true, the return value does not contain enclosing ticks. Does not handle data structures. dumpvars $dumper->dumpvars('my_package'); $dumper->dumpvars('my_package', 'foo', '~bar$', '!......'); The optional arguments are considered as literal strings unless they start with "~" or "!", in which case they are interpreted as regular expressions (possibly negated). The second example prints entries with names "foo", and also entries with names which ends on "bar", or are shorter than 5 chars. set_quote $d->set_quote('"'); Sets "tick" and "unctrl" options to suitable values for printout with the given quote char. Possible values are "auto", "'" and """. set_unctrl $d->set_unctrl('unctrl'); Sets "unctrl" option with checking for an invalid argument. Possible values are "unctrl" and "quote". compactDump $d->compactDump(1); Sets "compactDump" option. If the value is 1, sets to a reasonable big number. veryCompact $d->veryCompact(1); Sets "compactDump" and "veryCompact" options simultaneously. set $d->set(option1 => value1, option2 => value2); get @values = $d->get('option1', 'option2'); perl v5.12.1 2010-05-13 Dumpvalue(3pm)
All times are GMT -4. The time now is 04:27 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy