<div>
Just change the separator to ~ or some other unique character, then you can just do<br />
<br />

<pre><code id="code-20-35245638-1">cut -f5 -d&quot;~&quot;</code></pre>
</div>


<div>
Excel does not do that very easy. &nbsp;<br />
<br />
I was trying to figure out how to get bash to work with a real csv file<br />
<br />
this, that,&quot;the,other,thing&quot;,bea<wbr />ns,rice<br />
this should be 5 strings, not 7 ;)<br />
<br />

</div>


<div>
<div class="content wysiwyg-content">
I have data like this:<br />
<br />
<br />
bart-d,Red level content search matched,Red,None,/etc/prof<wbr />ile,&quot;Solar<wbr />is 10 - Set Path, umask, and trap in / etc / profile to: umask 022, trap 2 3, and P: / etc export PATH&quot;<br />
<br />
if I do a cut -f5 -d&quot;,&quot; &nbsp;I get the middle of the last data.<br />
<br />
Can simply make a tilde delmited file or somehow tell bash that I want to honor the &quot;&nbsp;, &quot;&nbsp;as a one string instead of two ?<br />
<br />
&nbsp;thank you <br />
<br />
I would prefer to do this in bash but I have bash &amp;&nbsp;perl on the boxes &nbsp;! 
</div>
</div>


I have data like this:


bart-d,Red level content search matched,Red,None,/etc/profile,"Solaris 10 - Set Path, umask, and trap in / etc / profile to: umask 022, trap 2 3, and P: / etc export PATH"

if I do a cut -f5 -d","  I get the middle of the last data.

Can simply make a tilde delmited file or somehow tell bash that I want to honor the " , " as a one string instead of two ?

 thank you 

I would prefer to do this in bash but I have bash & perl on the boxes  ! 

Just change the separator to ~ or some other unique character, then you can just do

(CODE)


Excel does not do that very easy.  

I was trying to figure out how to get bash to work with a real csv file

this, that,&quot;the,other,thing&quot;,beans,rice
this should be 5 strings, not 7 ;)



Trying to parse CSV in bash!

I have data like this:


bart-d,Red level content search matched,Red,None,/etc/profile,&quot;Solaris 10 - Set Path, umask, and trap in / etc / profile to: umask 022, trap 2 3, and P: / etc export PATH&quot;

if I do a cut -f5 -d&quot;,&quot;  I get the middle of the last data.

Can simply make a tilde delmited file or somehow tell bash that I want to honor the &quot; , &quot; as a one string instead of two ?

 thank you 

I would prefer to do this in bash but I have bash &amp; perl on the boxes  ! 

The term 'shell' refers to a general class of text-based command interpreters most often associated with the UNIX and Linux operating systems. Popular shells include Bourne, Debian Almquist (dash), Korn (ksh), Bourne Again (bash) and the C shell family (csh). Some view the DOS 'cmd' prompt as a minimal shell of sorts. It is also possible to install Cygwin on Windows and emulate a full Unix environment with complete shell capabilities. Terminal emulators, such as xterm, GNOME Terminal and OS X Terminal, can be used to access shell.

Shell Scripting

A Linux distribution is an operating system made as a software collection based on the Linux kernel and, often, on a package management system and are available for a variety of systems. A typical Linux distribution comprises a Linux kernel, GNU tools and libraries, additional software, documentation, a window system (the most common being the X Window System), a window manager, and a desktop environment. Most Linux systems are open-source software made available both as compiled binaries and in source code form, allowing modifications to the original software. Over three hundred distributions are in active development, including commercially backed distributions (such as Fedora, openSUSE and Ubuntu) and community-driven distributions (such as Debian, Slackware, Gentoo and Arch Linux).

Linux Distributions

Perl is a high-level, general-purpose, interpreted, dynamic programming languages with over 25 years of development. Perl 5 runs on over 100 platforms from portables to mainframes and is suitable for both rapid prototyping and large-scale development projects.  Perl gained widespread popularity as a Common Gateway Interface (CGI) scripting language, in part due to its regular expression and string parsing abilities. In addition to CGI, Perl is used for graphics programming, system administration, network programming, finance, bioinformatics, and other applications.