IMPORTANT ANNOUNCEMENT

These forums were permanently set to read-only mode on July 20, 2022. From that day onwards, no new posting or comment is allowed on the site, but the historical content remains intact and searchable.

A new location for posting questions about PlanetPress Suite is now available:

OL Learn - PlanetPress Classic (opens in new tab)

Topic Options
#42316 - 02/15/13 11:23 AM Extracting inegers from a field to seperate fields
Ian LaserDept Offline
OL Newbie

Registered: 06/20/12
Posts: 11
Loc: Cape Town, SAfrica
Hi
I need to take a number like 6789 ie, write each integer
to a seperate integer field and then multiply these seperated numbers individually by other random numbers.

Example

6789
becomes

6 field1
7 field2
8 field3
9 field4

etc, etc

then i am able to multiply these seperated fields by whatever!

I am looking for the quickest way possible. At the moment I have this code in PreS but need it to work in PlanetPress.

thanks

Top
#42327 - 02/15/13 01:45 PM Re: Extracting inegers from a field to seperate fields [Re: Ian LaserDept]
Olivier J
Unregistered


Hi Ian,

You might want to open a support ticket so we can actually teach you how to do it.

&myvar:='6789'
For(&i,0,1,length(&myvar)-1)
&myarray[&i]=left(&myvar,1)
&myvar:=trim(mid(&myvar,2,99))
endfor()
&mymultiplicationresult:=strtoint(&myarray[2])*&mymultiplicator


Edited by Olivier J (02/15/13 01:47 PM)

Top
#42332 - 02/18/13 03:45 AM Re: Extracting inegers from a field to seperate fields [Re: ]
Ian LaserDept Offline
OL Newbie

Registered: 06/20/12
Posts: 11
Loc: Cape Town, SAfrica
thanks so much Olivier J

i will see if i can wrap my head around this, if not i will open
the workticket.

thanks again.

Top
#42334 - 02/18/13 07:00 AM Re: Extracting inegers from a field to seperate fields [Re: Ian LaserDept]
Ian LaserDept Offline
OL Newbie

Registered: 06/20/12
Posts: 11
Loc: Cape Town, SAfrica
Hi Olivier

How do I open the support ticket?

Is it the OL Newsgroup Support link below?

thanks

Top
#42335 - 02/18/13 08:49 AM Re: Extracting inegers from a field to seperate fields [Re: Ian LaserDept]
Olivier J
Unregistered


Hi,

You can open a support ticket here .

You can also call at 1-866-348-5863

Regards,

Top
#42390 - 02/20/13 04:16 AM Re: Extracting inegers from a field to seperate fields [Re: ]
Ian LaserDept Offline
OL Newbie

Registered: 06/20/12
Posts: 11
Loc: Cape Town, SAfrica
Thank you

Top