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:

Browser Reloads and AddlineItem (1997) RE: [WebDNA] V8.6 FCGI (2018) Share Bulletin Board? (1998) Repeating Fields (1997) [LOOKUP] (1997) URGENT: WebDNA Server Not Running (2003) [index] (1997) convert characters (2003) Snake Bites (1997) webcat2b12 CGI -- Date comparisons (1997) For those of you not on the WebCatalog Beta... (1997) Press Release hit the NewsWire!!! (1997) taxTotal (1997) Bulk Linebreak Changes (2002) Online reference (1997) Quick ShowIf question (1997) [WebDNA] checking for mixed case text (2009) Hard Questions ? (1997) greater than or equal to (1997) RE: WebCatalog NT beta 18 now available (1997)