What happened to the Messenger Plus! forums on msghelp.net?
Shoutbox » MsgHelp Archive » Skype & Technology » Tech Talk » [?] sed/regexp remove blank spaces between single quotes

[?] sed/regexp remove blank spaces between single quotes
Author: Message:
felipEx
Scripting Contest Winner
***


Posts: 378
Reputation: 24
35 / Male / Flag
Joined: Jun 2006
O.P. [?] sed/regexp remove blank spaces between single quotes
Hi,

Could you please lend me a hand? I've got a text file that has multiple blank spaces between single quotes

e.g.
code:
UPDATE EMBARQUE_DET SET CANT_RECIBIDA = 21 WHERE FOLIO = '4801173987  ' AND PRODUCTO = '76222100083100  '
How do you remove these blank spaces by using sed or any other tool?

Any help would be appreciated!
09-14-2012 04:25 AM
Profile E-Mail PM Find Quote Report
CookieRevised
Elite Member
*****

Avatar

Posts: 15517
Reputation: 173
– / Male / Flag
Joined: Jul 2003
Status: Away
RE: [?] sed/regexp remove blank spaces between single quotes
too tired to think, so here a very "poor man's method":
1) Remove all double spaces
2) Replace all <space>' with just '

:P

This post was edited on 09-14-2012 at 04:41 AM by CookieRevised.
.-= A 'frrrrrrrituurrr' for Wacky =-.
09-14-2012 04:40 AM
Profile PM Find Quote Report
« Next Oldest Return to Top Next Newest »


Threaded Mode | Linear Mode
View a Printable Version
Send this Thread to a Friend
Subscribe | Add to Favorites
Rate This Thread:

Forum Jump:

Forum Rules:
You cannot post new threads
You cannot post replies
You cannot post attachments
You can edit your posts
HTML is Off
myCode is On
Smilies are On
[img] Code is On