Re: [WebDNA] Converting | to TAB

This WebDNA talk-list message is from

2010


It keeps the original formatting.
numero = 105058
interpreted = N
texte = --Boundary-00=_/hBoL8g+KDgKRGV Content-Type: text/plain; charset="iso-8859-15" Content-Transfer-Encoding: 7bit I ran into the same problem. Pain in the a**. I think I used convertchars with a special db to work around this bug. > 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]=%09 > > > > I am doing this on W2003 6.1 > > > > > > Regards > > > > Stuart Tremain > > IDFK Web Developments > > AUSTRALIA > > webdna@idfk.com.au > > > > > > > > > > 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|||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 > >>> webdna@idfk.com.au > >>> > >>> > >>> > >>> > >> > > > > --Boundary-00=_/hBoL8g+KDgKRGV Content-Type: text/html; charset="iso-8859-15" Content-Transfer-Encoding: 7bit I ran into the same problem. Pain in the a**. I think I used convertchars with a special db to work around this bug.



> 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]=%09
> >
> > I am doing this on W2003 6.1
> >
> >
> > Regards
> >
> > Stuart Tremain
> > IDFK Web Developments
> > AUSTRALIA
> > webdna@idfk.com.au
> >
> >
> >
> >
> > 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|||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
> >>> webdna@idfk.com.au
> >>>
> >>>
> >>>
> >>>
> >>
> >
>
>


--Boundary-00=_/hBoL8g+KDgKRGV-- 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)
--Boundary-00=_/hBoL8g+KDgKRGV Content-Type: text/plain; charset="iso-8859-15" Content-Transfer-Encoding: 7bit I ran into the same problem. Pain in the a**. I think I used convertchars with a special db to work around this bug. > 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]=%09 > > > > I am doing this on W2003 6.1 > > > > > > Regards > > > > Stuart Tremain > > IDFK Web Developments > > AUSTRALIA > > webdna@idfk.com.au > > > > > > > > > > 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|||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 > >>> webdna@idfk.com.au > >>> > >>> > >>> > >>> > >> > > > > --Boundary-00=_/hBoL8g+KDgKRGV Content-Type: text/html; charset="iso-8859-15" Content-Transfer-Encoding: 7bit I ran into the same problem. Pain in the a**. I think I used convertchars with a special db to work around this bug.



> 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]=%09
> >
> > I am doing this on W2003 6.1
> >
> >
> > Regards
> >
> > Stuart Tremain
> > IDFK Web Developments
> > AUSTRALIA
> > webdna@idfk.com.au
> >
> >
> >
> >
> > 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|||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
> >>> webdna@idfk.com.au
> >>>
> >>>
> >>>
> >>>
> >>
> >
>
>


--Boundary-00=_/hBoL8g+KDgKRGV-- Kenneth Grome

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:

syntax question, not in online refernce (1997) encrypt method=APOP broken or just not enough docs? - was:MD5 encryption (2003) List Var (2000) [OT] help with a javascript alert (2003) Fed Ex Rate Charts (2003) Javascript & Search Results (1998) [WebDNA] lookup in tables defined in functions - bug? (2016) Nesting format tags (1997) Append again (1999) [shell] (2003) Snake Bites (1997) Help! WebCat2 bug (1997) SM's Tech Help (or lack of) (2000) Free WebDNA snippets (Extending WebCatalog) (1997) [SearchString] problem with [search] context (1997) Multiple condition showif's (2004) Webcat & SIMS (1998) [OT] Friendly URL's (2004) Great product and great job ! (1997) What am I missing (1997)