Print Page | Close Window

Finding out the IP address from the description

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=8981
Printed Date: 03 May 2024 at 7:39pm


Topic: Finding out the IP address from the description
Posted By: aneel
Subject: Finding out the IP address from the description
Date Posted: 28 Jan 2010 at 10:52pm
Hi Team,
 
I'm having one field name called "Description", it does't contain fixed lenght data. With in this I want to take out the IP address and should show  it in one column.
 
I tried substring and split function options, but these are only for fixed length data.. do we have any other option to find out this?? plz help
 
 
Regards,
Aneel


-------------
Anee Chandanam


Replies:
Posted By: lockwelle
Date Posted: 01 Feb 2010 at 11:42am
as far as I know, neither substring nor split cares about length.  The issue is being able to find the data that you want and determining where that data ends. Instr() should be able to find the start of the information, maybe the end as well, Mid() can use the info from Instr() to select the piece of information that you are looking for.
 
HTH

Posted By: kevlray
Date Posted: 01 Feb 2010 at 12:23pm

And do not forget using Len() to find the lenght of a string.  Very helpful if you want to split off part of a string using the above functions.


Print Page | Close Window