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:

WebCat2b13MacPlugIn - [shownext method=post] ??? (1997) WebCat and AppleShare 6.0 (1998) WebCat2: Formulas.db question (1997) Security Issue (1997) Include a big block of text (1997) Order not created error (1997) WC Database Format (1997) New public beta available (1997) ShipCost Data Base (1998) AE aware WebCatalog.acgi? (1997) Secure Server basic question... (1997) Navigator Parsing (1997) form posts expiring instantly... why? (2000) Whats wrong with this code? (1998) showif (1999) Simple way to create unique SKU (1997) Field lenght (1998) redirect with frames (1997) fieldnamesdir=ra equivalent for [sql] (2002) [WebDNA] Problem with administration (2009)