Shoutbox

[?] sed/regexp remove blank spaces between single quotes - Printable Version

-Shoutbox (https://shoutbox.menthix.net)
+-- Forum: MsgHelp Archive (/forumdisplay.php?fid=58)
+--- Forum: Skype & Technology (/forumdisplay.php?fid=9)
+---- Forum: Tech Talk (/forumdisplay.php?fid=17)
+----- Thread: [?] sed/regexp remove blank spaces between single quotes (/showthread.php?tid=99620)

[?] sed/regexp remove blank spaces between single quotes by felipEx on 09-14-2012 at 04:25 AM

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!
RE: [?] sed/regexp remove blank spaces between single quotes by CookieRevised on 09-14-2012 at 04:40 AM

too tired to think, so here a very "poor man's method":
1) Remove all double spaces
2) Replace all <space>' with just '

:P