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

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

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!

CookieRevised
Elite Member

Posts: 15517
Reputation: 173
– / Male

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 '

This post was edited on 09-14-2012 at 04:41 AM by CookieRevised.

.-= A 'frrrrrrrituurrr' for Wacky =-.

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