Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

line feeds in csv

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting line feeds in csv
# 8  
Old 09-01-2005
vgersh
vgersh has miss understood my problem

Input_csv_file
XXX, "456 New albany
newyork, Unitedstates
45322-33", YYY
ZZZ, "654 rifle park
toronto, canada
43L-w3b", RRR

output_csv file should like this
XXX, "456 New albany newyork, Unitedstates 45322-33", YYY
ZZZ, "654 rifle park toronto, canada 43L-w3b", RRR

Note: is there anyway i can remove the linefeed between " "
# 9  
Old 09-01-2005
Quote:
Originally Posted by gowrish
vgersh has miss understood my problem

Input_csv_file
XXX, "456 New albany
newyork, Unitedstates
45322-33", YYY
ZZZ, "654 rifle park
toronto, canada
43L-w3b", RRR

output_csv file should like this
XXX, "456 New albany newyork, Unitedstates 45322-33", YYY
ZZZ, "654 rifle park toronto, canada 43L-w3b", RRR

Note: is there anyway i can remove the linefeed between " "

Just use futurelet's suggestion. Save the posted code in a file - call it: futurelet.awk

Call sequence:

nawk -f futurelet.awk Input_csv_file

After that, read futurelet's comments. After that do 'man nawk' and read, read, read....
Last edited by vgersh99; 09-01-2005 at 04:03 PM..
# 10  
Old 09-01-2005
vgersh
hey vgersh !


Thanks alot man ! Ur suggestion ! worked out for me !

I really appreciate ur help ...
# 11  
Old 09-01-2005
Quote:
Originally Posted by gowrish
hey vgersh !


Thanks alot man ! Ur suggestion ! worked out for me !

I really appreciate ur help ...
all kudos go to futurelet.
don't forget the 'reading' part.....
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Extract Line and Column from CSV Line in ksh or bash format

Hi, I was doing some research and can't seem to find anything. I'm trying to automate a process by creating a script to read a csv line and column and assigning that value to a variable for the script to process it. Also if you could tell me the line and column if it's on another work ... (3 Replies)
Discussion started by: vpundit
3 Replies

2. Shell Programming and Scripting

Removing carriage return/line feeds on multiple lines

I would like to remove carriage returns/line feeds in a text file, but in a specific cadence: Read first line (Header Line 1), remove cr/lf at the end (replace it with a space ideally); Read the next line (Line of Text 2), leave the cr/lf intact; Read the next line, remove the cr/lf; Read... (14 Replies)
Discussion started by: tomr2012
14 Replies

3. Shell Programming and Scripting

useless line feeds in ldapsearch output. Howto remove with shell script?

Hi $ cat ad.sh ldapsearorg -x -LLL -h sb1131z.testbadbigcorp.org -D "CN=ADMINZZ,OU=AdminRoles,DC=testbadbigcorp,DC=org" -w "UT3w4f57lll--4...4" -b "OU=Test,DC=testbadbigcorp,DC=org" "(&(&(&(&(objectCategory=person)(objectClass=user)(lockoutTime:1.2.840.113556.1.4.804:=4294967295)))))" dn$... (3 Replies)
Discussion started by: slashdotweenie
3 Replies

4. Shell Programming and Scripting

remove line feeds followed by character

Hi everyone, I'm very new to using sed, run through some tutorials and everything but I've hit a problem that I'm unable to solve by myself. I need to remove all linefeeds that are followed by a particular character (in this case a semicolon). So basically, all lines starting with a semicolon... (5 Replies)
Discussion started by: fluffdasheep
5 Replies

5. Shell Programming and Scripting

Delimited data contains line feeds where they shouldn't be

I have some data, each record (line) ends with a line feed (\n). Each field is pipe (|) delimited. 1|short desc|long text|2001-01-01 01:01 2|short desc| long text |2002-02-02 02:02 3|short desc| long text | 2003-03-03 03:03 4|short desc | long text | 2004-04-04 04:04 ... (10 Replies)
Discussion started by: ericdp63
10 Replies

6. UNIX for Dummies Questions & Answers

.properties file and new line feeds

Hi, I have a .properties file that a read in some values in an .sh file but everytime I put it out on the server it fails. If I copy and paste the values of the .properties file on my local machine to the .properties file on the server it works just fine. Someone mentioned to see if it has dos... (3 Replies)
Discussion started by: vsekvsek
3 Replies

7. Shell Programming and Scripting

supressing carrige returns/line feeds

Hi gurus I am stripping lots of email addresses from a file with this grep "^To" file.log |awk '{print "1,"$2}' > recipients.out file.log looks something like this: oasndfoasnosf To: person@email.co.uk lsdfjosd sdlfnmsopdfwer dtlghodrgn To: person2@emailsss.com sldfnsdf I... (5 Replies)
Discussion started by: terry2009
5 Replies

8. Shell Programming and Scripting

Spurious line feeds

Hi all, I know this is **awfully** general but..... I have a script which does, basically... for file in `find command`; do some stuff more stuff echo '.\c' done I want to output the '.' char just to give an idea of progress. However, it works fine for a while and then I... (2 Replies)
Discussion started by: ajcannon
2 Replies

9. Shell Programming and Scripting

Remove line feeds

Hi, I have a fixed width flat file which has 1 as the first char and E as the last character. Some of the records have a carriage return /line feeds . how do I remove them? Let me know. Thanks VSK (8 Replies)
Discussion started by: vsk
8 Replies

10. Shell Programming and Scripting

carriage return/line feeds

Hello, I have a file that has got carriage returns in it and I want to take them out. Anyone know how I can do this in a ksh? thanks (4 Replies)
Discussion started by: pitstop
4 Replies
Login or Register to Ask a Question