Re: [WebDNA] Converting | to TAB

This WebDNA talk-list message is from

2010


It keeps the original formatting.
numero = 105057
interpreted = N
texte = --Apple-Mail-23-565321731 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii It seems that the comma in here >> 18 ORWELL LODGE, MAIN ST Was causing the problem. WHY !!!!!! Hours and hours and hours of pulling my hair out !! Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 17/03/2010, at 10:16 AM, Stuart Tremain wrote: > Brian, I have [tab]=3D%09 >=20 > I am doing this on W2003 6.1 >=20 >=20 > Regards >=20 > Stuart Tremain > IDFK Web Developments > AUSTRALIA > webdna@idfk.com.au >=20 >=20 >=20 >=20 > On 17/03/2010, at 10:13 AM, Brian Fries wrote: >=20 >> 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. >>=20 >> Tested on OS X 10.6.2 with WebDNA 6.2 and on OS X 10.4.11 with WebDNA = 5.1c >>=20 >> Brian Fries >> BrainScan Software >>=20 >>=20 >> On Mar 16, 2010, at 4:03 PM, Stuart Tremain wrote: >>=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 >>=20 >=20 --Apple-Mail-23-565321731 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii It = seems that the comma in here

18 ORWELL LODGE, MAIN = ST

Was causing the problem.

WHY = !!!!!!

Hours and hours and hours of pulling my = hair out = !!




<= br>
Regards

Stuart = Tremain
IDFK Web Developments
AUSTRALIA
webdna@idfk.com.au




On 17/03/2010, at 10:16 AM, Stuart Tremain wrote:

Brian, I have = [tab]=3D%09

I am doing this on W2003 =  6.1


Regards

Stuart = Tremain
IDFK Web Developments
AUSTRALIA




On 17/03/2010, at 10:13 AM, Brian Fries wrote:

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-23-565321731-- 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-23-565321731 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii It seems that the comma in here >> 18 ORWELL LODGE, MAIN ST Was causing the problem. WHY !!!!!! Hours and hours and hours of pulling my hair out !! Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 17/03/2010, at 10:16 AM, Stuart Tremain wrote: > Brian, I have [tab]=3D%09 >=20 > I am doing this on W2003 6.1 >=20 >=20 > Regards >=20 > Stuart Tremain > IDFK Web Developments > AUSTRALIA > webdna@idfk.com.au >=20 >=20 >=20 >=20 > On 17/03/2010, at 10:13 AM, Brian Fries wrote: >=20 >> 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. >>=20 >> Tested on OS X 10.6.2 with WebDNA 6.2 and on OS X 10.4.11 with WebDNA = 5.1c >>=20 >> Brian Fries >> BrainScan Software >>=20 >>=20 >> On Mar 16, 2010, at 4:03 PM, Stuart Tremain wrote: >>=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 >>=20 >=20 --Apple-Mail-23-565321731 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii It = seems that the comma in here

18 ORWELL LODGE, MAIN = ST

Was causing the problem.

WHY = !!!!!!

Hours and hours and hours of pulling my = hair out = !!




<= br>
Regards

Stuart = Tremain
IDFK Web Developments
AUSTRALIA
webdna@idfk.com.au




On 17/03/2010, at 10:16 AM, Stuart Tremain wrote:

Brian, I have = [tab]=3D%09

I am doing this on W2003 =  6.1


Regards

Stuart = Tremain
IDFK Web Developments
AUSTRALIA




On 17/03/2010, at 10:13 AM, Brian Fries wrote:

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-23-565321731-- 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:

Location of Browser Info.txt file (1997) Generating Report Totals (1997) format_to_days on NT (1997) List of consultants/programmers (2001) Reversed words (1997) Erotic Sites (1997) Re:Problem displaying search result (1997) Simple search, perhaps (2002) Stopping NT WebCat service (1998) selectively replacing records within a [founditems] (2000) problems with 2 tags (1997) text conversions (1999) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) Multiple fields on 1 input (1997) Save Word/Excel Docs to Server (2002) [WebDNA] v7.x [thisurl] (2010) showif... (2000) Unix 4.0.2b5 (2000) Newbie problem blah blah blah (1997) OT: Amazon Patents (2000)