Re: [WebDNA] Converting | to TAB

This WebDNA talk-list message is from

2010


It keeps the original formatting.
numero = 105055
interpreted = N
texte = --Apple-Mail-20-563717496 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Assuming the variable "tab" is set to %09, your code works fine for me. = Runs of multiple pipes are replaced with runs of multiple tabs. Tested on OS X 10.6.2 with WebDNA 6.2 and on OS X 10.4.11 with WebDNA = 5.1c Brian Fries BrainScan Software On Mar 16, 2010, at 4:03 PM, Stuart Tremain wrote: > I am having a hell of a time replacing pipes to tabs in this: >=20 > 6161530035322|90776|1304|MR|JOHN|JONES|18 ORWELL LODGE, MAIN ST|JIMMYS = POINT||NSW|2011||13/07/1970|M|262614001|262614001|1|1|NONE|15/02/2010|138|= 27.6|09/02/2010|30/09/2010|1|4301|OP|HOLDSWORTH|SHARON|s||||||57728|0|||04= 14169006|AU|OPSM|no >=20 >=20 > If I use grep: >=20 > [grep = search=3D\|&replace=3D[tab]&ignorecase=3DT]6161530035322|90776|1304|MR|JOH= N|JONES|18 ORWELL LODGE, MAIN ST|JIMMYS = POINT||NSW|2011||13/07/1970|M|262614001|262614001|1|1|NONE|15/02/2010|138|= 27.6|09/02/2010|30/09/2010|1|4301|OP|HOLDSWORTH|SHARON|s||||||57728|0|||04= 14169006|AU|OPSM|no[/grep] >=20 > It replaces 2 or more pipes with only 1 tab >=20 > If i put a letter between the pipes, I get the result required. >=20 > Any hints ??? >=20 > Regards >=20 > Stuart Tremain > IDFK Web Developments > AUSTRALIA > webdna@idfk.com.au >=20 >=20 >=20 >=20 --Apple-Mail-20-563717496 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii Assuming the variable "tab" is set to %09, your code works fine for = me. Runs of multiple pipes are replaced with runs of multiple = tabs.

Tested on OS X 10.6.2 with WebDNA 6.2 and on OS = X 10.4.11 with WebDNA 5.1c

Brian = Fries
BrainScan Software

On Mar 16, 2010, at 4:03 PM, Stuart Tremain = wrote:

I am having a hell of a = time replacing pipes to tabs in this:

6161530035322|90776|1304|MR|JOHN|JONES|18 ORWELL LODGE, MAIN = ST|JIMMYS = POINT||NSW|2011||13/07/1970|M|262614001|262614001|1|1|NONE|15/02/2010|138|= 27.6|09/02/2010|30/09/2010|1|4301|OP|HOLDSWORTH|SHARON|s||||||57728|0|||04= 14169006|AU|OPSM|no


If I use grep:

[grep search=3D\|&replace=3D[tab]&ignorecase=3DT]6161530035322|90776|1304|MR|JOHN|JONES|18 = ORWELL LODGE, MAIN ST|JIMMYS = POINT||NSW|2011||13/07/1970|M|262614001|262614001|1|1|NONE|15/02/2010|138|= 27.6|09/02/2010|30/09/2010|1|4301|OP|HOLDSWORTH|SHARON|s||||||57728|0|||04= 14169006|AU|OPSM|no[/grep]

It replaces 2 or more pipes = with only 1 tab

If i put a letter between the pipes, = I get the result required.

Any hints ???

Regards

Stuart = Tremain
IDFK Web Developments
AUSTRALIA





= --Apple-Mail-20-563717496-- Associated Messages, from the most recent to the oldest:

    
  1. RE: [WebDNA] Converting | to TAB (matthew.bohne@benetela.com 2010)
  2. Re: [WebDNA] Converting | to TAB (Stuart Tremain 2010)
  3. RE: [WebDNA] Converting | to TAB (matthew.bohne@benetela.com 2010)
  4. Re: [WebDNA] Converting | to TAB (Kenneth Grome 2010)
  5. Re: [WebDNA] Converting | to TAB (Stuart Tremain 2010)
  6. Re: [WebDNA] Converting | to TAB (Stuart Tremain 2010)
  7. Re: [WebDNA] Converting | to TAB (Brian Fries 2010)
  8. [WebDNA] Converting | to TAB (Stuart Tremain 2010)
--Apple-Mail-20-563717496 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Assuming the variable "tab" is set to %09, your code works fine for me. = Runs of multiple pipes are replaced with runs of multiple tabs. Tested on OS X 10.6.2 with WebDNA 6.2 and on OS X 10.4.11 with WebDNA = 5.1c Brian Fries BrainScan Software On Mar 16, 2010, at 4:03 PM, Stuart Tremain wrote: > I am having a hell of a time replacing pipes to tabs in this: >=20 > 6161530035322|90776|1304|MR|JOHN|JONES|18 ORWELL LODGE, MAIN ST|JIMMYS = POINT||NSW|2011||13/07/1970|M|262614001|262614001|1|1|NONE|15/02/2010|138|= 27.6|09/02/2010|30/09/2010|1|4301|OP|HOLDSWORTH|SHARON|s||||||57728|0|||04= 14169006|AU|OPSM|no >=20 >=20 > If I use grep: >=20 > [grep = search=3D\|&replace=3D[tab]&ignorecase=3DT]6161530035322|90776|1304|MR|JOH= N|JONES|18 ORWELL LODGE, MAIN ST|JIMMYS = POINT||NSW|2011||13/07/1970|M|262614001|262614001|1|1|NONE|15/02/2010|138|= 27.6|09/02/2010|30/09/2010|1|4301|OP|HOLDSWORTH|SHARON|s||||||57728|0|||04= 14169006|AU|OPSM|no[/grep] >=20 > It replaces 2 or more pipes with only 1 tab >=20 > If i put a letter between the pipes, I get the result required. >=20 > Any hints ??? >=20 > Regards >=20 > Stuart Tremain > IDFK Web Developments > AUSTRALIA > webdna@idfk.com.au >=20 >=20 >=20 >=20 --Apple-Mail-20-563717496 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii Assuming the variable "tab" is set to %09, your code works fine for = me. Runs of multiple pipes are replaced with runs of multiple = tabs.

Tested on OS X 10.6.2 with WebDNA 6.2 and on OS = X 10.4.11 with WebDNA 5.1c

Brian = Fries
BrainScan Software

On Mar 16, 2010, at 4:03 PM, Stuart Tremain = wrote:

I am having a hell of a = time replacing pipes to tabs in this:

6161530035322|90776|1304|MR|JOHN|JONES|18 ORWELL LODGE, MAIN = ST|JIMMYS = POINT||NSW|2011||13/07/1970|M|262614001|262614001|1|1|NONE|15/02/2010|138|= 27.6|09/02/2010|30/09/2010|1|4301|OP|HOLDSWORTH|SHARON|s||||||57728|0|||04= 14169006|AU|OPSM|no


If I use grep:

[grep search=3D\|&replace=3D[tab]&ignorecase=3DT]6161530035322|90776|1304|MR|JOHN|JONES|18 = ORWELL LODGE, MAIN ST|JIMMYS = POINT||NSW|2011||13/07/1970|M|262614001|262614001|1|1|NONE|15/02/2010|138|= 27.6|09/02/2010|30/09/2010|1|4301|OP|HOLDSWORTH|SHARON|s||||||57728|0|||04= 14169006|AU|OPSM|no[/grep]

It replaces 2 or more pipes = with only 1 tab

If i put a letter between the pipes, = I get the result required.

Any hints ???

Regards

Stuart = Tremain
IDFK Web Developments
AUSTRALIA





= --Apple-Mail-20-563717496-- Brian Fries

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

More on the email templates (1997) a new bug? (1999) Whats wrong with this code? (1998) customizing the color of user's pages (1997) Variable in a variable (2002) Protect (1997) FW: 2.01 upgrade problems (1997) WebCat2b13MacPlugIn - More limits on [include] (1997) Adding Header Values with [SetHeader] (1998) No Data Results (1997) WebCat2 - Getting to the browser's username/password data (1997) Re:Email Problem (1997) 2 databases problem (1997) [WebDNA] agree? --> also broken when we compare against something with a "!" in it. (2009) OFF TOPIC: help wanted (1997) RE: ShowNext Command (1997) Emailer [cart] file names (1997) [WebDNA] [if] or [case] or something else (2012) question: webmerchant connection (1997) Webstar 1.3.1 PPC (1997)