10.3.33 getCsvColumn (gets a column in consideration of blank line of CSV data)

Syntax

getCsvColumn  [-c column] [-d] [file-path-name]

Description

This command outputs the column of the CSV file specified for the argument.

Arguments

-c column

This command outputs the data of the specified column. Specify a value not less than 1 for column. If this option is not specified, data for all column is output.

-d

Delete a blank line and outputs data.

file-path-name

This command specifies the path of the CSV file. If you do not specify the file path name, input from the standard input.

The size of CSV data that can be input is 100KB or less. If you input data larger than 100KB, the execution time of the job may become longer.

Return codes

Notes

A value of more than 1 can be specified for column of argument, but whether the character string can be specified is not verified.

Examples

CSV data(data.csv)
name,value,id

Yokohama,200,1
Kawasaki,100,2

# Outputs data at the first column.
getCsvColumn -c 1 data.csv
#The following contents are output:
name

Yokohama
Kawasaki

#Outputs data that the blank line is deleted from the first column.
getCsvColumn -c 1 -d data.csv
# The following contents are output:
name
Yokohama
Kawasaki

# Outputs data that the blank line is deleted from the first line.
"${ADSH_DIR_CMD}awk" '{if(FNR!=1){print $0}}' data.csv | getCsvColumn -d
# Outputs the following contents:
Yokohama,200,1
Kawasaki,100,2