Separator in data itself - The UNIX and Linux Forums

		The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
Separator in data itself

google unix.com

Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
thousands separator	ynixon	Shell Programming and Scripting	11	04-13-2008 11:43 AM
record separator	rochitsharma	Shell Programming and Scripting	7	03-04-2006 10:37 AM
field separator as regexp	Abhishek Ghose	Shell Programming and Scripting	2	02-15-2006 08:49 PM
Help with unix separator	Black mage2021	UNIX for Dummies Questions & Answers	2	01-02-2006 11:49 PM
Separator in Makefile?	laila63	Shell Programming and Scripting	2	07-01-2004 11:11 AM


	Powered by

LinkBack

Thread Tools

Search this Thread

Rate Thread

Display Modes

#1 (permalink)

06-17-2008

kolesunil

Registered User

Join Date: May 2008

Posts: 8

Separator in data itself

Following is the CSV file, separated by ","

Code:

100,sunil,$1,000,mumbai
101,amit,$10,000,mumbai
102,sailesh,$10,000,00,mumbai

I want the following output:

Code:

100,sunil,$1000,mumbai
101,amit,$10000,mumbai
102,sailesh,$1000000,mumbai

Note: I know the number of fields in the file in advance. In this case it is 4.

Any help is highly appreciated.

Thanks,
SK

Last edited by Yogesh Sawant; 06-17-2008 at 08:39 AM.. Reason: added code tags

Bookmarks

Tags

csv, perl

« To pass the .sql file as a paramter to sqlplus through shell programming | parsing large CDR XML file »

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules

All times are GMT -4. The time now is 09:21 PM.