I have a csv file with lines like the followings
123456,"ABC CO., LTD","XXX"
789012,"DEF LIMITED", "XXX"
before I bcp this file to database, the comma in "CO.," need to be removed first.
My script is cat <filename> | sed 's/"CO.,"/"CO."/g'
but it doesn't work. Can anyone here able to... (2 Replies)
Hi All,
I have a tab delimited file where each of the strings have double quotes.
The problem is that I have records which are in the following format:
"TEXAS" ""HOUSTON"" "123" "" "2625-39-39"
""MAINE"" "" "456" "I" "3737-39-82"
I would have to output... (3 Replies)
Hello,
I am using csh to read a text file and save its words into variable $word in a foreach loop. These words have small back quotes ` as integral parts of them, for example, one word would be `abc`, another would be `xyz1` etc... These quotes are always the first and last characters of the... (5 Replies)
The below code is to convert csv file to pipe delimited.
It replaces comma with pipe if it is not in double quotes; If comma is in double quotes it doesnot replace the comma with a pipe.
The code works fine except it eat away the double quotes in the output file.
BEGIN... (6 Replies)
I have not seen anything yet in your forum to answer this problem.
Here is my sed command.
I want to change
Build Apache module" off
to
Build Apache module" on
This is what I am trying.
sed "s_Build Apache module\" off_Build Apache module\" on_" /usr/ports/lang/php5/Makefile... (9 Replies)
I have a flat file sample like this -
"COURSE"|"ddddd " " dddd"|"sssddd
sdsdsdsdx" dddddddd ffffff
"aaaaa" dddddddd ffffff
sdsdsd"|"xxxxxxx"|
"COURSE"|"ffff " " bbbb"|"lllll"|
The delimiter is pipe character (|) and the text are enclosed in double quotes... (5 Replies)
Hello everyone,
I am working on a file with thousands of lines and instead of manually removing them I need a script to remove quotes within quotes. For example a line may have something such as this:
"Hey, I was ready to go on stage or "break a leg", but I failed miserably."
So I need to... (15 Replies)
Hi,
Text file has DEL character(ASCII code 127) as quotes with comma as field delimiter. If any of the field contains new line character then I need to remove it. Please help me to achieve this.
Thanks
Vikram (4 Replies)
Hi I have a .csv file and when opened in notepad looks like this
gggg,nnnn,"last,first","llll""",nnn
So, Here I would like the ouput as below
gggg,nnnn,"last,first","llll",nnn
i.e replace all two double quotes into one. How could I do that?
This file is being processed by another... (5 Replies)
Hi Experts,
Please support
I have below data in file in comma seperated, but 4th column is containing comma in between numbers, bcz of which when i tried to parse the file the column 6th value(5049641141) is being removed from the file and value(222.82) in column 5 becoming value of column6.
... (3 Replies)
Discussion started by: as7951
3 Replies
LEARN ABOUT ULTRIX
rmdir
rm(1) General Commands Manual rm(1)Name
rm, rmdir - remove (unlink) files or directories
Syntax
rm [-f] [-r] [-i] [-] file-or-directory-name...
rmdir directory-name...
Description
The command removes the entries for one or more files from a directory. If there are no links to the file then the file is destroyed. For
further information, see
The command removes entries for the named directories, which must be empty. If they are not empty, the directories remain, and displays an
error message (see EXAMPLES).
To remove a file, you must have write permission in its directory, but you do not need read or write permission on the file itself. When
you are using from a terminal, and you do not have write permission on the file, the command asks for confirmation before destroying the
file.
If input is redirected from the standard input device (your terminal), then checks to ensure that input is not coming from your terminal.
If not, sets the -f option, which overrides the file protection, and removes the files silently, regardless of what you have specified in
the file redirected as input to See EXAMPLES.
Options
- Specifies that the named files have names beginning with a minus (for example ).
-f Forces the removal of file or directory without first requesting confirmation. Only system or usage messages are displayed.
-i Prompts for yes or no response before removing each entry. Does not ask when combined with the -f option. If you type a y, followed
by any combination of characters, a yes response is assumed.
-r Recursively removes all entries from the specified directory and, then, removes the entry for that directory from its parent direc-
tory.
Examples
The following example shows how to remove a file in your current working directory.
rm myfile
This example shows use of the null option to remove a file beginning with a minus sign.
rm - -gorp
This example shows how a confirmation is requested for removal of a file for which you do not have write permission.
rm testfile
rm: override protection 400 for testfile? y
This example shows how the combination of -i and -r options lets you examine all the files in a directory before removing them. In the
example, mydirectory is a subdirectory of the current working directory. Note that the last question requests confirmation before removing
the directory itself. Although the user types ``y'', requesting removal of the directory, the command does not allow this, because the
directory is not empty; the user typed ``n'' to the question about the file file2 , so file2 was not removed.
rm -ir mydirectory
rm: remove mydirectory/file1? y
rm: remove mydirectory/file2? n
.
.
.
rm: remove mydirectory? y
rm: mydirectory: Directory not empty
This example illustrates that overrides file protection when input is redirected from the standard input device. The user creates a file
named ``alfie'', with a read-only file protection. The user then creates a file named ``ans'' to contain the character ``n''. The command
following destroys the file ``alfie'', even though the redirected input file requested no deletion.
cat > alfie
hello
^d
chmod 444 alfie
cat > ans
n
^d
rm < ans alfie
See Alsounlink(2)rm(1)