Cut command Post: 302908566

Sponsored Content

Top Forums Shell Programming and Scripting Cut command Post 302908566 by drl on Tuesday 8th of July 2014 06:01:50 PM

07-08-2014

Registered User

Hi.

I think that the central problem is the topic of comma-separated-value files, csv, not awk, cut, etc..

Here's a script that simply handles such files, along with the utility csvtool:

Code:

#!/usr/bin/env bash

# @(#) s1	Demonstrate csv manipulation, csvtool.

# Utility functions: print-as-echo, print-line-with-visual-space, debug.
# export PATH="/usr/local/bin:/usr/bin:/bin"
LC_ALL=C ; LANG=C ; export LC_ALL LANG
pe() { for _i;do printf "%s" "$_i";done; printf "\n"; }
pl() { pe;pe "-----" ;pe "$*"; }
db() { ( printf " db, ";for _i;do printf "%s" "$_i";done;printf "\n" ) >&2 ; }
db() { : ; }
C=$HOME/bin/context && [ -f $C ] && $C csvtool

FILE=${1-data1}

pl " Input data file $FILE:"
cat $FILE

pl " Results:"
csvtool col 1,3,4 $FILE

exit 0

producing:

Code:

$ ./s1

Environment: LC_ALL = C, LANG = C
(Versions displayed with local utility "version")
OS, ker|rel, machine: Linux, 2.6.26-2-amd64, x86_64
Distribution        : Debian 5.0.8 (lenny, workstation) 
bash GNU bash 3.2.39
csvtool - ( /usr/bin/csvtool, 2008-05-22 )

-----
 Input data file data1:
abc,"an,ab",cde,efg
abc,anab,cde,efg

-----
 Results:
abc,cde,efg
abc,cde,efg

The command csvtool is in the Debian repositories. Perhaps it is in yours:

Code:

Description: A handy command line tool for handling CSV files
 OCaml CSV is a library to read and write CSV (comma-separated values)
 files.  It also supports all extensions used by Excel - eg. quotes,
 newlines, 8 bit characters in fields, etc.
 .
 This package contains csvtool, a handy command line tool for handling
 CSV files from shell scripts.
Homepage: http://merjis.com/developers/csv

Best wishes ... cheers, drl

This User Gave Thanks to drl For This Post:

drl

View Public Profile for drl

Find all posts by drl

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

CUT Command

Hi, Can anyone tell me if I can apply multiple cut on a single variable like below in a sh script: tmp=`cut -c 1-4 $val` tmp1=`cut -c 5-12 $val` tmp2=`cut -c 13-18 $val` If not, what is the other way to do this. Thanks and Best Regards Shoeb

2. UNIX for Dummies Questions & Answers

Cut Command help

Hi , I am new to Unix.I have a shell script whenere I wnat to find if a particular server is running and kill all the instances of it (running on different ports) script filename to start the srever is say abcd If i do ps -eaf | grep abc I get all the instances of srever running .In the...

3. AIX

Use of Cut Command

Hi All, Can anyone tell me how to use cut command?I have tried but its not working...Please find the details below : $ cat file1 SlNo. E_ID E_Name Age Dept 1 123 A 20 Electrical 2 124 B 20 Electronics 3 125 C 24 Computer 4 126 D 23 Mechanical ...

4. Shell Programming and Scripting

cut command help

n2=user1 pts/3 2010-06-29 01 Now i want to split this string with space(' ') character. After splitting output would be: use1 pts/3 2010-06-29 01 I did: nn=${n2} | cut -d ' ' -f2 echo ${nn} It prints nothing. I want the output: pts/3

5. Shell Programming and Scripting

Cut Command error cut: Bad range

Hi Can anyone what I am doing wrong while using cut command. for f in *.log do logfilename=$f Log "Log file Name: $logfilename" logfile1=`basename $logfilename .log` flength=${#logfile1} Log "file length $flength" from_length=$(($flength - 15)) Log "from...

6. UNIX for Dummies Questions & Answers

Cut pid from ps using cut command

hay i am trying to get JUST the PID from the ps command. my command line is: ps -ef | grep "mintty" | cut -d' ' -f2 but i get an empty line. i assume that the delimiter is not just one space character, but can't figure out what should i do in order to do that. i know i can use awk or cut...

7. AIX

Need help on cut command

HI, i have data in one variable like out=/usr/sbin/filename and i want output like only out=filename how to do

8. Shell Programming and Scripting

Cut command

Hi All, I am a beginner learning shell script, Would it be possible to use -c and -f in cut command together ? Example : /opt/oracle/work/Antony/Shell_Script> cat shortlist 2233|a.k. shukula |g.m. |sales2 |12/12/52 |6000 1006|chanchal singhvi ...

9. UNIX for Beginners Questions & Answers

Cut command: can't make it cut fields

I'm a complete beginner in UNIX (and not a computer science student either), just undergoing a tutoring course. Trying to replicate the instructions on my own I directed output of the ls listing command (lists all files of my home directory ) to My_dir.tsv file (see the screenshot) to make use of...

LEARN ABOUT OPENSOLARIS

tee

tee(1)								   User Commands							    tee(1)

NAME

       tee - replicate the standard output

SYNOPSIS

   /usr/bin/tee
       /usr/bin/tee [-ai] [file]...

   ksh93
       tee [-ail] [file]...

DESCRIPTION

   /usr/bin/tee
       /usr/bin/tee  copies  standard  input  to standard output, making a copy in zero or more files. tee does not buffer its output. The options
       determine if the specified files are overwritten or appended to.

   ksh93
       The tee built-in in ksh93 is associated with the /bin and /usr/bin paths. It is invoked when tee is executed without a pathname prefix  and
       the pathname search finds a /bin/tee or /usr/bin/tee executable.

       tee  copies  standard input to standard output and to zero or more files. The options determine whether the specified files are overwritten
       or appended to. The tee utility does not buffer output. If a write to a file fails, tee continues to write to other files although it exits
       with a non-zero exit status.

       The number of file operands that can be specified is limited by the underlying operating system.

OPTIONS

   /usr/bin/tee
       The following options are supported by /usr/bin/tee:

       -a    Appends the output to the files rather than overwriting them.

       -i    Ignores interrupts.

   ksh93
       The following options are supported by the tee built-in command in ksh93:

       -a		      Appends the output to the files rather than overwriting them.
       --append

       -i		      Ignores SIGINT signal.
       --ignore-interrupts

       -l		      Sets the standard output to be line buffered.
       --line-buffer

OPERANDS

       The following operands are supported:

       file    A path name of an output file. Processing of at least 13 file operands are supported.

USAGE

       See largefile(5) for the description of the behavior of tee when encountering files greater than or equal to 2 Gbyte ( 2^31 bytes).

ENVIRONMENT VARIABLES

       See  environ(5)	for  descriptions of the following environment variables that affect the execution of tee: LANG, LC_ALL, LC_CTYPE, LC_MES-
       SAGES, and NLSPATH.

EXIT STATUS

   /usr/bin/tee
       The following exit values are returned by /usr/bin/tee:

       0     The standard input was successfully copied to all output files.

       >0    The number of files that could not be opened or whose status could not be obtained.

   ksh93
       The following exit values are returned by tee in ksh93:

       0     Successful completion.

       >0    An error occurred.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

   /usr/bin/tee
       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWcsu			   |
       +-----------------------------+-----------------------------+
       |CSI			     |Enabled			   |
       +-----------------------------+-----------------------------+
       |Interface Stability	     |Committed 		   |
       +-----------------------------+-----------------------------+
       |Standard		     |See standards(5). 	   |
       +-----------------------------+-----------------------------+

   ksh93
       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWcsu			   |
       +-----------------------------+-----------------------------+
       |Interface Stability	     |See below.		   |
       +-----------------------------+-----------------------------+

       The ksh93 built-in binding to /bin and /usr/bin is Volatile. The built-in interfaces are Uncommitted.

SEE ALSO

       cat(1), ksh93(1), attributes(5), environ(5), largefile(5), standards(5)

SunOS 5.11							    20 Nov 2007 							    tee(1)

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

CUT Command

Discussion started by: shoeb_syed

2. UNIX for Dummies Questions & Answers

Cut Command help

Discussion started by: shradham

3. AIX

Use of Cut Command

Discussion started by: Puja Sharma

4. Shell Programming and Scripting

cut command help

Discussion started by: cola

5. Shell Programming and Scripting

Cut Command error cut: Bad range

Discussion started by: dgmm

6. UNIX for Dummies Questions & Answers

Cut pid from ps using cut command

Discussion started by: ran ber

7. AIX

Need help on cut command

Discussion started by: sumanthupar

8. Shell Programming and Scripting

Cut command

Discussion started by: Antony Ankrose

9. UNIX for Beginners Questions & Answers

Cut command: can't make it cut fields

Discussion started by: scrutinizerix

LEARN ABOUT OPENSOLARIS

tee