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
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
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
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
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
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
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
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
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
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
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
LEARN ABOUT FREEBSD
column
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