I need to split my data when in finds 100000000 at the beginning of the line. I have tried the following, but data isn't being separated.

define(&marker,string,'100000000')
if(mid(&str,9,length(&marker))=&marker)
if(&current.line>0)
doform()
clearpage()
endif
endif

set(&current.line,&current.line + 1)
store(&current.line,&str)
if(&current.line>=&current.lpp)
doform()
clearpage()
endif()

Hi,

You can tray this example:

if(left(&str,9)='100000000')
set(&current.line,&current.line + 1)
store(&current.line,&str)
doform()
clearpage()
endif()
set(&current.line,&current.line + 1)
store(&current.line,&str)
if(ge(&current.line,&current.lpp))
doform()
clearpage()
endif()


CSP

I mean "try" not "tray".

CSP

That did not separate the data either. It gave me the first line, but all other data was merged.

the following seems to be working, be rather search for 1000 and not just 1

define(&marker,string,'1')
if(mid(&str,1,length(&marker))=&marker)
if(&current.line>0)
doform()
clearpage()
endif
endif

set(&current.line,&current.line + 1)
store(&current.line,&str)
if(&current.line>=&current.lpp)
doform()
clearpage()
endif()

Hi,

This worked for me!

if(left(&str,9)='100000000')
doform()
clearpage()
endif()

set(&current.line,&current.line + 1)
store(&current.line,&str)

if(ge(&current.line,&current.lpp))
doform()
clearpage()
endif()


CSP

Data not splitting with that.

Here is the code I entered:
[img]https://onedrive.live.com/redir?resid=81C066941585FBAB!120232&authkey=!AMC3onL1FwteuDs&v=3&ithint=photo%2cjpg[/img]

Here is the result
https://onedrive.live.com/redir?resid=81C066941585FBAB!120230&authkey=!ANqgqPB1QgMIBVI&v=3&ithint=photo%2cjpg

Here is what I need:
[img]https://onedrive.live.com/redir?resid=81C066941585FBAB!120231&authkey=!ABQpQdrcPX-ijxs&v=3&ithint=photo%2cjpg[/img]

GBowlsby,

Now it's clear. Test it with this code. I believe it will work now.

if(left(&str,1)='1')
doform()
clearpage()
endif()

set(&current.line,&current.line + 1)
store(&current.line,&str)

if(ge(&current.line,&current.lpp))
doform()
clearpage()
endif()

CSP

Just had a chance to try this code. The first data page is blank, but the data is separating. Is there a way to skip blank pages?

You can apply a condition on every page. On the property pages, condition, type:

@ = (1,1,1) = '1'

So the pages will be run only when there is the character "1" in the first position of the data page.

Or you can also set on the property of the document check the option "skip blank data pages".