Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.filemaker > #1698 > unrolled thread

parse

Back to article view | Back to comp.databases.filemaker

Contents

  parse ilhalilaz <ilhalilaz@mail.telepac.pt> - 2014-01-31 11:52 -0600
    Re: parse Helpful Harry <HelpfulHarry@BusyWorking.com> - 2014-02-01 13:38 +1300
      Re: parse Howard Schlossberg <howard@nospam.fmprosolutions.com> - 2014-01-31 16:56 -0800
        Re: parse Helpful Harry <HelpfulHarry@BusyWorking.com> - 2014-02-01 14:06 +1300

#1698 — parse

how can I pass a block of text with paragraph five fields to return and remove the left.
example
A proibição de transitar, imposta pelo sinal vertical, de
forma circular, que se encontra do meu lado direito,
aplica-se:

 Aos automóveis de mercadorias e veículos a motor com
reboque.

 Aos automóveis de mercadorias e veículos de tracção animal.

 Aos automóveis pesados e veículos a motor com reboque

[toc] | [next] | [standalone]

#1707

In article <ca-dnRazMPR8f3bPnZ2dnUVZ_j-dnZ2d@giganews.com>, ilhalilaz
<ilhalilaz@mail.telepac.pt> wrote:
> 
> how can I pass a block of text with paragraph five fields to return and
> remove the left.
> example
> A proibição de transitar, imposta pelo sinal vertical, de
> forma circular, que se encontra do meu lado direito,
> aplica-se:
> 
 Aos automóveis de mercadorias e veículos a motor com
> reboque.
> 
 Aos automóveis de mercadorias e veículos de tracção animal.
> 
 Aos automóveis pesados e veículos a motor com reboque

I'm not sure I understand this one. I can only see data for four
possible fields: one starting with "A proibi" and three starting with
"Aos autom".

Anyway, all you need to do is look for the carriage return charaters
using the Postition function.

The first field copies all the characters up to the first carriage
return.
e.g.

    Field1 = 
      Left(DataField & "RET"; 
           Position(DataField & "RET";"RET";1;1)-1)

where "RET" should be the carriage return charcter (still inside speech
marks). The extra carriage return appended to the end of DataField in
the functions is to make sure the last lot of data can be found.

The second field copies all the character from the first carriage
return to the second carriage return.
e.g.

   Field2 =
     Middle(DataField & "RET"; 
            Position(DataField & "RET";"RET";1;1) + 1; 
            Position(DataField & "RET";"RET";1;2) 
            - Position(DataField & "RET";"RET";1;1))

The third field copies all the character from the second carriage
return to the third carriage return.
e.g.

   Field3 =
     Middle(DataField & "RET"; 
            Position(DataField & "RET";"RET";1;2) + 1; 
            Position(DataField & "RET";"RET";1;3) 
            - Position(DataField & "RET";"RET";1;2))

The fourth field copies all the character from the third carriage
return to the fourth carriage return.
e.g.

   Field4 =
     Middle(DataField & "RET"; 
            Position(DataField & "RET";"RET";1;3) + 1; 
            Position(DataField & "RET";"RET";1;4) 
            - Position(DataField & "RET";"RET";1;3))

The fifth field (if needed) copies all the character from the fourth
carriage return to the fifth carriage return.
e.g.

   Field5 =
     Middle(DataField & "RET"; 
            Position(DataField & "RET";"RET";1;4) + 1; 
            Position(DataField & "RET";"RET";1;5) 
            - Position(DataField & "RET";"RET";1;4))


Helpful Harry  :o)

[toc] | [prev] | [next] | [standalone]

#1708

On 1/31/2014 4:38 PM, Helpful Harry wrote:
> In article <ca-dnRazMPR8f3bPnZ2dnUVZ_j-dnZ2d@giganews.com>, ilhalilaz
> <ilhalilaz@mail.telepac.pt> wrote:
>>
>> how can I pass a block of text with paragraph five fields to return and
>> remove the left.
>
> I'm not sure I understand this one. I can only see data for four
> possible fields: one starting with "A proibi" and three starting with
> "Aos autom".
>
> Anyway, all you need to do is look for the carriage return charaters
> using the Postition function.

Harry may have done a better job at understanding the question than I 
did.  If Harry's translation is correct and you are using FIleMaker 8 or 
later, it would be easier to use the GetValue() function.

Field1 = GetValue( DataField, 1)
Field2 = GetValue( DataField, 2)
Field3 = GetValue( DataField, 3)
Field4 = GetValue( DataField, 4)
Field5 = GetValue( DataField, 5)

[toc] | [prev] | [next] | [standalone]

#1710

In article <lchgn7$g1b$3@news.motzarella.org>, Howard Schlossberg
<howard@nospam.fmprosolutions.com> wrote:

> On 1/31/2014 4:38 PM, Helpful Harry wrote:
> > In article <ca-dnRazMPR8f3bPnZ2dnUVZ_j-dnZ2d@giganews.com>, ilhalilaz
> > <ilhalilaz@mail.telepac.pt> wrote:
> >>
> >> how can I pass a block of text with paragraph five fields to return and
> >> remove the left.
> >
> > I'm not sure I understand this one. I can only see data for four
> > possible fields: one starting with "A proibi" and three starting with
> > "Aos autom".
> >
> > Anyway, all you need to do is look for the carriage return charaters
> > using the Postition function.
> 
> Harry may have done a better job at understanding the question than I 
> did.
<snip>

Probably not, I was only guessing at what was wanted.

Helpful Harry  :o)

[toc] | [prev] | [standalone]

Back to top | Article view | comp.databases.filemaker

csiph-web