Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
awk with sed? 1
- Thread starter BIS
- Start date
-
1
- #2
Hi
Sure is possible. At least with GNU Awk. However it is abit lengthy because the two way communication :
Or with any standard compliant Awk :
But I strongly recommend to never do that - never alter the data just to satisfy the storage or transport layer.
What kind of database is that ? For SQL databases ( and most of the NoSQL databases too ) you must escape text data. Escaping may depend on the database type and internal encoding and beside the string delimiters may require the escaping of the escape character too. For this reason, escaping solutions are provided for most of the databases/drivers/libraries.
So better give use details on your database and the intended use.
Feherke.
feherke.ga
Sure is possible. At least with GNU Awk. However it is abit lengthy because the two way communication :
Code:
[teal]{[/teal]
[b]print[/b] [i][green]"BEFORE"[/green][/i][teal],[/teal] [navy]$0[/navy]
p [teal]=[/teal] [i][green]"sed [/green][/i][lime]\"[/lime][i][green]s/'//[/green][/i][lime]\"[/lime][i][green]"[/green][/i]
[b]print[/b] [teal]|&[/teal] p
[b]close[/b][teal]([/teal]p[teal],[/teal] [i][green]"to"[/green][/i][teal])[/teal]
p [teal]|&[/teal] [b]getline[/b]
[b]close[/b][teal]([/teal]p[teal],[/teal] [i][green]"from"[/green][/i][teal])[/teal]
[b]print[/b] [i][green]"AFTER "[/green][/i][teal],[/teal] [navy]$0[/navy]
[teal]}[/teal]
Code:
[blue]master #[/blue] gawk -f ask-sed-to-remove-single-quote.awk <<< "Subject: Don't play with fire"
BEFORE Subject: Don't play with fire
AFTER Subject: Dont play with fireOr with any standard compliant Awk :
Code:
[b]gsub[/b][teal]([/teal][fuchsia]/'/[/fuchsia][teal],[/teal] [i][green]""[/green][/i][teal])[/teal]But I strongly recommend to never do that - never alter the data just to satisfy the storage or transport layer.
What kind of database is that ? For SQL databases ( and most of the NoSQL databases too ) you must escape text data. Escaping may depend on the database type and internal encoding and beside the string delimiters may require the escaping of the escape character too. For this reason, escaping solutions are provided for most of the databases/drivers/libraries.
So better give use details on your database and the intended use.
Feherke.
feherke.ga
- Thread starter
- #3
Sorry for the late reply...
The gsub was all I needed - many thanks for pointing me in the right direction.
I agree with you that this is not the proper way to go about the issue, but it is a quick and dirty solution that will work until they get their database issues resolved
The gsub was all I needed - many thanks for pointing me in the right direction.
I agree with you that this is not the proper way to go about the issue, but it is a quick and dirty solution that will work until they get their database issues resolved
- Status