My Assistant
Site Message
(Message will auto close in 2 seconds)
  |
 Extracting Text from a Memo Field
|
|
 Oct 27 2004, 08:38 AM
Post
#1
|
|
|
New Member Posts: 3  |
I am sure this has been requested before but I cannot find anything on the forum. I have a Memo field with varying lengths of text in it. In the middle of the text is a server name I need to extract. The text before the server name is always the same length and the server name is preceded with "Class: " then at the end of the server name is " ," (that's a space and a comma). The left/mid/right function does not work as the server name and the text after the server name is various lengths. Can anyone offer some advice
|
 |
 
|
|
Oct 27 2004, 08:59 AM
Post
#2
|
|
|
UtterAccess VIP Posts: 3,667 From: Toronto, ON |
Try this:
Trim(Left(Mid(strText,instr(strText,"Class:")+6),Instr(Mid(strText,instr(strText,"Class:")+6),",")-1)) where strText is your variable string. |
|
|
|
|
Oct 27 2004, 09:23 AM
Post
#3
|
|
|
New Member Posts: 3 |
Works a treak, Thanks
|
|
|
|
|
Oct 27 2004, 09:25 AM
Post
#4
|
|
|
UtterAccess VIP Posts: 3,667 From: Toronto, ON |
You're welcome!
|
|
|
|
|
Oct 27 2004, 09:50 AM
Post
#5
|
|
|
New Member Posts: 1 |
I'm quite new with this so please forgive me if I say something stupid...
Regarding this memo field subject, could you help me on the following? Have a memo field with several words. I currently have =[specify name] in the criteria so I can choose a different word every time. Well it doens't work. As you probably all know, that only works if all of the field value is inserted in... Any tips? Cheers Thanks |
|
|
|
 |
|
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 20th June 2013 - 05:25 AM |