Sponsored Content
Top Forums Shell Programming and Scripting Removing consecutive double quotes Post 303014442 by dnat on Monday 12th of March 2018 01:23:39 PM
Old 03-12-2018
Removing consecutive double quotes

Hi I have a .csv file and when opened in notepad looks like this


Code:
gggg,nnnn,"last,first","llll""",nnn

So, Here I would like the ouput as below

Code:
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 application, so i would need the file format like this..

Thanks!!

Last edited by vgersh99; 03-12-2018 at 02:25 PM.. Reason: code tags, please
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Double quotes or single quotes when using ssh?

I'm not very familiar with the ssh command. When I tried to set a variable and then echo its value on a remote machine via ssh, I found a problem. For example, $ ITSME=itsme $ ssh xxx.xxxx.xxx.xxx "ITSME=itsyou; echo $ITSME" itsme $ ssh xxx.xxxx.xxx.xxx 'ITSME=itsyou; echo $ITSME' itsyou $... (3 Replies)
Discussion started by: password636
3 Replies

2. Shell Programming and Scripting

sed removing comma inside double quotes

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)
Discussion started by: joanneho
2 Replies

3. UNIX for Dummies Questions & Answers

Removing double quotes in a file

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)
Discussion started by: kingofprussia
3 Replies

4. Shell Programming and Scripting

AWK removing away needed double quotes.

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)
Discussion started by: pinnacle
6 Replies

5. Shell Programming and Scripting

removing extra double quotes between pipe dilimeter

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)
Discussion started by: vishalzone
5 Replies

6. UNIX for Dummies Questions & Answers

grep single quotes or double quotes

Unix superusers, I am new to unix but would like to learn more about grep. I am very familiar with regular expressions as i have used them for searching text files in windows based text editors. Since I am not very familiar with Unix, I dont understand when one should use GREP with the... (2 Replies)
Discussion started by: george_vandelet
2 Replies

7. Shell Programming and Scripting

Issue with Single Quotes and Double Quotes for prompt PS1

Hi, Trying to change the prompt. I have the following code. export PS1=' <${USER}@`hostname -s`>$ ' The hostname is not displayed <abc@`hostname -s`>$ uname -a AIX xyz 1 6 00F736154C00 <adcwl4h@`hostname -s`>$ If I use double quotes, then the hostname is printed properly but... (3 Replies)
Discussion started by: bobbygsk
3 Replies

8. Shell Programming and Scripting

Replace Double quotes within double quotes in a column with space while loading a CSV file

Hi All, I'm unable to load the data using sql loader where there are double quotes within the double quotes As these are optionally enclosed by double quotes. Sample Data : "221100",138.00,"D","0019/1477","44012075","49938","49938/15043000","Television - 22" Refurbished - Airwave","Supply... (6 Replies)
Discussion started by: mlavanya
6 Replies

9. UNIX for Beginners Questions & Answers

sed command to replace consecutive double quotes

I need to replace consecutive double quotes in a csv file, the data in the file is enclosed in double quotes but there are some places where the quotes are repeating Example is below Incoming data is : "Pacific Region"|"PNG"|"Jimmy""|""| Need output as: "Pacific... (10 Replies)
Discussion started by: abhilashnair
10 Replies

10. Shell Programming and Scripting

awk to parse comma separated field and removing comma in between number and double quotes

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
appmake(1)							z88 Development Kit							appmake(1)

NAME
appmake - The z88dk application generator SYSNOPIS
appmake [+target] [options] DESCRIPIONS
This manual page documents briefly the z88dk tools. This manual page was written for the Debian GNU/Linux distribution (but may be used by others), because the original program does not have a manual page. Please refer to the z88dk documentation in /usr/share/doc/z88dk-doc/ for the complete description of the system. If /usr/share/doc/z88dk- doc not exists, please install the package z88dk-doc. This program is used to produce files which are suitable for use in emulators or on the real hardware. OPTIONS
Options used in all targets: -h --help Display help -b --binfile [file] Linked binary file -o --output [name] Name of output file +[target] generate file for target machine. Targets with additional options are: abc80 ace Generates a .byt file suitable for loading into emulators acetap Generates a .TAP for the Ace32 emulator aquarius Creates a BASIC loader file and binary stored in variable array format cpc Gegerates file for Amstrad CPC Additional options: -c --crt0file [file] crt0 file used in linking --exec [nnnn] Location address to start execution --org [nnnn] Origin of the binary hex Creates an intel hex record suitable for embedded devices Additional options: --org [nnnn] Origin of the binary msx Adds a file header to enable the program to be loaded using 'bload "file.bin",r mz nas Generates a .NAS file suitable for use by emulators Additional options: --org [nnnn] Origin of the binary rex Additional options: -n --appname [name] Application Name -c --comment [text] Application Comment --nt Don't pad out to 8k addin ti82 Creates a .82p file Additional options: --comment [text] File comment (42 chars) ti83 Creates a .83p file Additional options: --comment [text] File comment (42 chars) ti8x Creates a .8xp file Additional options: --comment [text] File comment (42 chars) ti85 Creates a .85p file Additional options: --comment [text] File comment (42 chars) ti86 Creates a .86p file Additional options: --comment [text] File comment (42 chars) ti86s Creates a .86s file Additional options: --comment [text] File comment (42 chars) svi Creates a .cas file loadable with the SVI emulator z88 Generates .63 and .62 files suitable for burning to EPROM Additional options: -c --crt0file [file] crt0 file used in linking --nt Do not truncate bank 63 z88shell Patches the header to ensure that the program is recognised by the shell Additional options: -c --crt0file [file] crt0 file used in linking zxvgs Creates a zxvgs application file Additional options: -c --crt0file [file] crt0 file used in linking zx Generates a .TAP file complete with BASIC header Additional options: -c --crt0file [file] crt0 file used in linking --org [nnnn] Origin of the binary --blockname [name] Name of the code block in tap file SEE ALSO
z88dk(1), z88dk-zcc(1), z88dk-z80asm(1), z88dk-appmake(1), z88dk-copt(1). AUTHOR
z88dk was written by Dominic Morris <dom@z88dk.org>, and others. This manual page was written by Krystian Wlosek <tygrys@waw.pdi.net> using exists documentation, for the Debian GNU/Linux system. 01 December 2009 appmake(1)
All times are GMT -4. The time now is 10:49 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy