Sponsored Content
Top Forums Shell Programming and Scripting Help with removing embedded linefeeds Post 302539157 by stayalive on Friday 15th of July 2011 12:39:46 PM
Old 07-15-2011
Help with removing embedded linefeeds

Greetings all,

i have csv file with pipe separated columns

SSN|NAME|ADDRESS|FILLER
123|abc|myaddress|xxx
234|BBB|my
add
ress
broken up|yyy

In the example above, the second record is broken into multiple lines. I need to keep going until I find a "|" since this issue is with the non-last column and therefore there definitely will be a pipe at the end of that column text.

is there any way i can remove \n (newline) from the address column?

Thanks for the help.
 

10 More Discussions You Might Find Interesting

1. Programming

Embedded programming

Anyone know any good sources (books, urls, etc) for learning embedded programming, for example with Tornado from Wind River? (3 Replies)
Discussion started by: TioTony
3 Replies

2. Shell Programming and Scripting

Embedded list? Is this possible

I need to write a script that maintains many directories. I was wondering is there is a way to create a list of the directories inside a script so that you can then use “while read line” to perform different commands for each directory. Something like this #!/bin/sh MYLIST: /dir1 /dir2... (1 Reply)
Discussion started by: zasxes
1 Replies

3. Shell Programming and Scripting

Problems with Embedded IF-else

Hi, I am putting the finishing touches on a shell script. I have the following which works FINE: if ] && ] then /bin/mail -s "Illegal Loggon Attempts on MAIL" sysadmin@ghf.com < final_email.tmp fi However, I need to make several else clauses and the interpreter complains... (1 Reply)
Discussion started by: mojoman
1 Replies

4. Shell Programming and Scripting

Removing Embedded Newline from Delimited File

Hey there - a bit of background on what I'm trying to accomplish, first off. I am trying to load the data from a pipe delimited file into a database. The loading tool that I use cannot handle embedded newline characters within a field, so I need to scrub them out. Solutions that I have tried... (7 Replies)
Discussion started by: bbetteridge
7 Replies

5. Shell Programming and Scripting

Escaping embedded variables

I'm running into a problem with a differential backup script written in GNU Bash 3.0 - the following stripped down code demonstrates the problem quite nicely. $ DATE="last tuesday" $ date --date="$DATE" Tue Jan 6 00:00:00 PST 2009 So far so good. $ CMD="date --date=\"$DATE\"" $... (6 Replies)
Discussion started by: vertigo23
6 Replies

6. UNIX for Dummies Questions & Answers

Embedded systems

Hi, I dont know whether it is the right space to put it... but didnt found related Embedded. I want to start learning Embedded systems in Unix, It would be greatly appreciable if someone could help me to start off .... Thanks (0 Replies)
Discussion started by: Deei
0 Replies

7. Programming

Static in Qt c++ Embedded Python

i have a problem in Use static variables in Qt C++ under CentOS 5.5 i need to pass a variable from GUI to class all function are static. it always give me that error error: undefined reference to strChar class QPython : public QObject { private: public: QString strChar; static PuObject*... (1 Reply)
Discussion started by: HanyM.Magdy
1 Replies

8. Shell Programming and Scripting

Add missing linefeeds between formfeeds in reports

I need to take a report text file that is output from vendor software and there are some pages which have less then the normal amount of lines. I need to add these missing line feeds as there is a merge program that reads this file in fixed character and line mode template to output the final PDF... (6 Replies)
Discussion started by: rnygren
6 Replies

9. UNIX for Dummies Questions & Answers

Removing PATTERN from txt without removing lines and general text formatting

Hi Everybody! First post! Totally noobie. I'm using the terminal to read a poorly formatted book. The text file contains, in the middle of paragraphs, hyphenation to split words that are supposed to be on multiple pages. It looks ve -- ry much like this. I was hoping to use grep -v " -- "... (5 Replies)
Discussion started by: AxeHandle
5 Replies

10. Shell Programming and Scripting

WARNING! 16126 bare linefeeds received in ASCII mode

I am doing FTP from a server and getting below ERROR:WARNING! 16126 bare linefeeds received in ASCII mode File may not have transferred correctly. I looked into web and found that I may need to change the mode to binary, but when I do so the records are not in readable format...So need the file... (10 Replies)
Discussion started by: joshilalit2004
10 Replies
COLUMN(1)						    BSD General Commands Manual 						 COLUMN(1)

NAME
column -- columnate lists SYNOPSIS
column [-tx] [-c columns] [-s sep] [file ...] DESCRIPTION
The column utility formats its input into multiple columns. Rows are filled before columns. Input is taken from file operands, or, by default, from the standard input. Empty lines are ignored. The options are as follows: -c Output is formatted for a display columns wide. -s Specify a set of characters to be used to delimit columns for the -t option. -t Determine the number of columns the input contains and create a table. Columns are delimited with whitespace, by default, or with the characters supplied using the -s option. Useful for pretty-printing displays. -x Fill columns before filling rows. ENVIRONMENT
The COLUMNS, LANG, LC_ALL and LC_CTYPE environment variables affect the execution of column as described in environ(7). EXIT STATUS
The column utility exits 0 on success, and >0 if an error occurs. EXAMPLES
(printf "PERM LINKS OWNER GROUP SIZE MONTH DAY " ; printf "HH:MM/YEAR NAME " ; ls -l | sed 1d) | column -t SEE ALSO
colrm(1), ls(1), paste(1), sort(1) HISTORY
The column command appeared in 4.3BSD-Reno. BUGS
Input lines are limited to LINE_MAX (2048) bytes in length. BSD
July 29, 2004 BSD
All times are GMT -4. The time now is 09:33 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy