i have a csv file .
In the 7th column i have data that has line feed in it.
Requirement is to remove the line feed from the 7th column whenever it appears
There are 11 columns in the file
C1,C2,C3,C4,C5,C6,C7,C8,C9,C10,C11
The value in C7 contains line feed ( Alt + Enter ), since the end of the line is also line feed value is C7 is pushed to different line .
kindly advice
hi all,
i have csv file with three comma separated columns
i/p file
First_Name, Address, Last_Name
XXX, "456 New albany \n newyork, Unitedstates \n 45322-33", YYY\n
ZZZ, "654 rifle park \n toronto, canada \n 43L-w3b", RRR\n
is there any way i can remove \n (newline) from the second... (1 Reply)
Hi All,
I have a xml file and requirement is to remove the line feed and add line feed after some element.
<?xml version="1.0" ?>
<AUDITRECORDS>
<CARF>
<HED>
<VN1>20090616010622</VN1>
<VN2>0</VN2>
<VN3>1090</VN3>
<VN4>CONFIG_DATA</VN4>
... (8 Replies)
We have successfully created a comma delimited file, the results are correct from an sql database query. When using the following headers to print the file using print $data, an extra line feed is added and a blank row appears on the top of the data in Excel:
header("Expires: 0");
... (0 Replies)
Hi! I have been struggling with a large file that has stray end of line characters.
I am working on a Mac (Lion). I mention this only because I have been mucking around with fixing my problem using sed, and I have learned far more than I wanted to know about Unix and Mac eol characters.
I... (1 Reply)
Hi,
I need to remove first column from a csv file and i can do this by using below command.
cut -f1 -d, --complement Mytest.csv
I need to implement this in shell scripting, Whenever i am using the above command alone in command line it is working fine.
I have 5 files in my directory and... (3 Replies)
Please use code tags for sample data
Hi
I have a file where there are line feeds in the data. I am not able to read the file from an application. I exported this data from Access database and many columns contain line feed.
My data looks like this
abcd,efgh,ijkl,mnop
abcd,ef... (7 Replies)
Discussion started by: dnat
7 Replies
LEARN ABOUT X11R4
col
COL(1) BSD General Commands Manual COL(1)NAME
col -- filter reverse line feeds from input
SYNOPSIS
col [-bfhpx] [-l num]
DESCRIPTION
The col utility filters out reverse (and half reverse) line feeds so that the output is in the correct order with only forward and half for-
ward line feeds, and replaces white-space characters with tabs where possible. This can be useful in processing the output of nroff(1) and
tbl(1).
The col utility reads from the standard input and writes to the standard output.
The options are as follows:
-b Do not output any backspaces, printing only the last character written to each column position.
-f Forward half line feeds are permitted (``fine'' mode). Normally characters printed on a half line boundary are printed on the fol-
lowing line.
-h Do not output multiple spaces instead of tabs (default).
-l num Buffer at least num lines in memory. By default, 128 lines are buffered.
-p Force unknown control sequences to be passed through unchanged. Normally, col will filter out any control sequences from the input
other than those recognized and interpreted by itself, which are listed below.
-x Output multiple spaces instead of tabs.
In the input stream, col understands both the escape sequences of the form escape-digit mandated by Version 2 of the Single UNIX
Specification (``SUSv2'') and the traditional BSD format escape-control-character. The control sequences for carriage motion and their ASCII
values are as follows:
ESC-BELL reverse line feed (escape then bell).
ESC-7 reverse line feed (escape then 7).
ESC-BACKSPACE half reverse line feed (escape then backspace).
ESC-8 half reverse line feed (escape then 8).
ESC-TAB half forward line feed (escape than tab).
ESC-9 half forward line feed (escape then 9). In -f mode, this sequence may also occur in the output stream.
backspace moves back one column (8); ignored in the first column
carriage return (13)
newline forward line feed (10); also does carriage return
shift in shift to normal character set (15)
shift out shift to alternate character set (14)
space moves forward one column (32)
tab moves forward to next tab stop (9)
vertical tab reverse line feed (11)
All unrecognized control characters and escape sequences are discarded.
The col utility keeps track of the character set as characters are read and makes sure the character set is correct when they are output.
If the input attempts to back up to the last flushed line, col will display a warning message.
ENVIRONMENT
The LANG, LC_ALL and LC_CTYPE environment variables affect the execution of col as described in environ(7).
EXIT STATUS
The col utility exits 0 on success, and >0 if an error occurs.
SEE ALSO colcrt(1), expand(1), nroff(1), tbl(1)STANDARDS
The col utility conforms to Version 2 of the Single UNIX Specification (``SUSv2'').
HISTORY
A col command appeared in Version 6 AT&T UNIX.
BSD May 10, 2015 BSD