Re: [WebDNA] Converting | to TAB

This WebDNA talk-list message is from

2010


It keeps the original formatting.
numero = 105063
interpreted = N
texte = --Apple-Mail-59-592496021 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Matthew, what is HL7 ??? Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 17/03/2010, at 1:43 PM, matthew.bohne@benetela.com wrote: > Looks like HL7=20 > =20 > -------- Original Message -------- > Subject: [WebDNA] Converting | to TAB > From: Stuart Tremain > Date: Tue, March 16, 2010 7:03 pm > To: talk@webdna.us >=20 > 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-59-592496021 Content-Transfer-Encoding: 7bit Content-Type: text/html; charset=us-ascii Matthew, what is HL7 ???

Regards

Stuart Tremain
IDFK Web Developments
AUSTRALIA




On 17/03/2010, at 1:43 PM, matthew.bohne@benetela.com wrote:

Looks like HL7 
 
-------- Original Message --------
Subject: [WebDNA] Converting | to TAB
From: Stuart Tremain <webdna@idfk.com.au>
Date: Tue, March 16, 2010 7:03 pm
To: talk@webdna.us

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|||0414169006|AU|OPSM|no


If I use grep:

[grep search=\|&replace=[tab]&ignorecase=T]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|||0414169006|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-59-592496021-- 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-59-592496021 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Matthew, what is HL7 ??? Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 17/03/2010, at 1:43 PM, matthew.bohne@benetela.com wrote: > Looks like HL7=20 > =20 > -------- Original Message -------- > Subject: [WebDNA] Converting | to TAB > From: Stuart Tremain > Date: Tue, March 16, 2010 7:03 pm > To: talk@webdna.us >=20 > 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-59-592496021 Content-Transfer-Encoding: 7bit Content-Type: text/html; charset=us-ascii Matthew, what is HL7 ???

Regards

Stuart Tremain
IDFK Web Developments
AUSTRALIA




On 17/03/2010, at 1:43 PM, matthew.bohne@benetela.com wrote:

Looks like HL7 
 
-------- Original Message --------
Subject: [WebDNA] Converting | to TAB
From: Stuart Tremain <webdna@idfk.com.au>
Date: Tue, March 16, 2010 7:03 pm
To: talk@webdna.us

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|||0414169006|AU|OPSM|no


If I use grep:

[grep search=\|&replace=[tab]&ignorecase=T]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|||0414169006|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-59-592496021-- Stuart Tremain

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:

HomePage Caution (1997) Can I do this with [grep]? (2002) webdna users.db (2005) Generating Report Totals (1997) Occasional crashes with $remove (1997) Setting user and password (1999) problem with applets embedded in tpl files (1997) [UPPERCASE] (1997) [WebDNA] [OT] the "Work in progress" thread. (2009) RE: Displaying Location (1997) Associative lookup style? + bit more (1997) [LOOKUP] (1997) Copyright ? (1997) WebCat2: multiple currency support (1997) Emailer [cart] file names (1997) Append..... doesn't (2000) [WebDNA] Putting '&search' into URL killing all search contexts on my sites (2010) updating with ProductEditor (1998) Need relative path explanation (1997) WebCat editing, SiteGuard WAS:SiteAssociative lookup style? (1997)