data moving around on a line - Objectif Lune Tech Support Self Help

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)

You are not logged in. [Log In] Objectif Lune » Forums » PlanetPress Suite 5 » PlanetPress 5.x - Read-Only » data moving around on a line

Topic Options

#19167 - 11/14/05 01:08 PM data moving around on a line
FormMaster OL Expert Registered: 05/12/03 Posts: 193 Loc: Los Angeles	Hi there. I have a customer number that moves around on line 15. The number always shows up in this format: No: ##### How do I choose this piece of data when it moves all over the line? Is there a way to look for the "No: " and then grab the 5 digits after it? Thanks.
Top

#19168 - 11/14/05 01:25 PM Re: data moving around on a line
Anonymous Unregistered	Hi: The "mid" function is a good choice here: Code: mid(string, start position, number of characters) mid(@(15,1,132),pos('No:',@(15,1,132))+3,5) The pos function returns the position of the 'No:' string, so the number starts 3 positions after. Hope this helps.
Top

Previous Topic

Index

Next Topic

Hop to:

Moderator: cosimo, OL Newsgroup Support