Replacing Comma delimiter coming inside the data. Post: 302521489

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

comma delimiter and space

I have a csv file and there is a problem which I need to resolve. Column1,Column2,Colum3,Column4 ,x,y,z ,d,c,v t,l,m,n ,h,s,k ,k,,y z,j, ,p Now if you see column1 for row 1 and row 4 though they are null there is a space but in case of row2 and row 5 there is no space. I want row...

2. Shell Programming and Scripting

Pull Data After Comma if 2 word before comma

Hi, I am trying to truncate word after comma in a file ONLY if there are already 2 words BEFORE comma. If there is one word or 3 or more words BEFORE comma, then I have to leave the data AS IS. See below for example. Input File : John Smith, Manager Smith, John Frank J F K...

3. Shell Programming and Scripting

Exporting data into Comma Delimiter.

Hi, Requirement: Exporting data from Oracle to UNIX into "Comma" delimiter. Help Needed: I was able to connect to Oracle and import the data. But please let me know while importing the data I need to make it into Comma delimiter flat file. For Example: Source Data - 100 ABC TLead...

4. UNIX for Dummies Questions & Answers

Making a Tab delimiter file to Comma

How can i make a tab delimiter file to a comma delimiter???

5. Shell Programming and Scripting

nawk won't accept comma as delimiter

I have a text file delimited by commas, with three fields (no " marks). I want to use awk to create a fourth field which is equal to the line number + field 1 + .txt I've searched this forum and found the following nawk -v OFS=';' '{print $0, FNR}' myFile Which I've amended to change the...

6. Shell Programming and Scripting

Need Help - comma inside double quote in comma separated csv,

Hello there, I have a comma separated csv , and all the text field is wrapped by double quote. Issue is some text field contain comma as well inside double quote. so it is difficult to process. Input in the csv file is , 1,234,"abc,12,gh","GH234TY",34 I need output like below,...

7. Shell Programming and Scripting

Change the delimiter from Comma to Pipeline

Hello All, I need to convert a csv file to pipeline delimiter file in UNIX. The data in file itself contains comma with double qouted qualifier apart from the comma separator. Let me know how to do it. Appreciate any help if awk can be used to do it. Mentioned below is the sample record of...

8. Shell Programming and Scripting

Replace comma delimiter by newline

The input file is as below AR,age,marks,roll,section,evin,25,80,456,A,atch,23,56,789,B,eena,24 ,78H245,C,Ps,ot,ecessary,hat,ame comes first then age and rest AR AZ,kevin,25,80,456,A,Satch,23,56,789,Satch,23,56,789,B,Meena,24,78,H245,C,AZ ................ ................ I am writting...

9. Shell Programming and Scripting

awk facing delimiter inside data

Inpu file is as below: CMEOPT1_dump.1:1002 ZN:VTJ3J3C131 CMEOPT1_dump.1:1002 ZN:VTM4M4P123%5 CMEOPT1_dump.1:1002 ZN:VTM3M3P132%5 CMEOPT1_dump.2:1002 OZNG4 CMEOPT2_dump.3:1002 ZB:VTH4H4C132 CMEOPT2_dump.4:1002 ZN:VTK4K4P123 CMEOPT2_dump.5:1002 ZN:BOZ2Z2Z2P131%5 CMEOPT2_dump.5:1002 OZNG4 ...

10. Shell Programming and Scripting

How can awk ignore the field delimiter like comma inside a field?

We have a csv file as mentioned below and the requirement is to change the date format in file as mentioned below. Current file (file.csv) ---------------------- empname,date_of_join,dept,date_of_resignation ram,08/09/2015,sales,21/06/2016 "akash,sahu",08/10/2015,IT,21/07/2016 ...

LEARN ABOUT DEBIAN

sendemail

SendEmail(1)							   User Commands						      SendEmail(1)

NAME

       SendEmail - Lightweight, command line SMTP email client

SYNOPSIS

       SendEmail -f ADDRESS [options]

OPTIONS

       -f ADDRESS
	      from (sender) email address

	      * At least one recipient required via -t, -cc, or -bcc * Message body required via -m, STDIN, or -o message-file=FILE

	      Common:

       -t ADDRESS [ADDR ...]
	      to email address(es)

       -u SUBJECT
	      message subject

       -m MESSAGE
	      message body

       -s SERVER[:PORT]
	      smtp mail relay, default is localhost:25

	      Optional:

       -a     FILE [FILE ...]	   file attachment(s)

       -cc    ADDRESS [ADDR ...]   cc  email address(es)

       -bcc ADDRESS [ADDR ...]
	      bcc email address(es)

	      [32;1mParanormal:[m

       -xu USERNAME
	      authentication user (for SMTP authentication)

       -xp PASSWORD
	      authentication password (for SMTP authentication)

       -l     LOGFILE		    log to the specified file

       -v     verbosity, use multiple times for greater effect

       -q     be quiet (no stdout output)

       -o NAME=VALUE
	      see extended help topic "misc" for details

	      Help:

       --help TOPIC
	      The following extended help topics are available:

       addressing
	      explain addressing and related options

       message
	      explain message body input and related options

       misc   explain -xu, -xp, and others

       networking
	      explain -s, etc

       output explain logging and other output options

REPORTING BUGS

       Report bugs to <http://bugs.debian.org/sendemail>

AUTHOR

       sendemail was written by Brandon Zehm <caspian@dotconf.net> .

       This  manual  page  was written by Brandon Zehm and improved by Alejandro Garrido Mota <garridomota@gmail.com>, for the Debian project (and
       may be used by others).

sendEmail							  September 2010						      SendEmail(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

comma delimiter and space

Discussion started by: RubinPat

2. Shell Programming and Scripting

Pull Data After Comma if 2 word before comma

Discussion started by: msalam65

3. Shell Programming and Scripting

Exporting data into Comma Delimiter.

Discussion started by: arunvasu2

4. UNIX for Dummies Questions & Answers

Making a Tab delimiter file to Comma

Discussion started by: saggiboy10