Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 06-04-2013, 04:07 PM
BobBridges's Avatar
BobBridges BobBridges is offline extract text with formula Windows 7 64bit extract text with formula Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

You gave your own examples, but you ignored mine, so I still don't know whether my examples reveal any special needs. Let me ask again, but more wordily:

a) You say in the case of 'N' you "don't want to have anything". But (to be ridiculously technical about it) there's no such thing as not having anything; your program can take a number of different actions. It can skip that line and not react to it (which I guess can be thought of as not having anything, after all). Some people think of the space character as "not anything"—not most people, but it does happen. The most obvious candidate for "not anything" is the null string, ""; but more knowledgeable programmers would insist that the correct value is Null, which is something different. In Excel I think the Empty value is another one again. So my first question is this: When there's an 'N' in the second position (ie between the first and second slash), do you want your program to come up with "", or what?

b) I didn't ask this before, but what about 'n' (lower case); should it be treated as data, or the same as 'N'?

c) I assume that there's no situation in which you want 'N' to be the data itself?

d) Is there ever a case where the string is "-DR//FRU/2574/C.Q6"? Because if there is, I sort of assume your logic should treat it identically to "-DR/N/FRU/2574/C.Q6".

e) What about when the string is "-DR/"? Again, should it be treated the same as "-DR/N"?

If your answer is the same in all cases, then I think the Split function (as I described in my last entry) should work for you.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert Formula Result to Static Text MYGS Excel 16 01-21-2013 08:18 AM
extract text with formula If formula result is negative then display text oxicottin Excel 3 12-03-2012 02:12 AM
Formula that references cell with text in different workbook no1texan Excel 3 07-17-2012 05:58 AM
Extract numbers from a text string aleale97 Excel 4 02-10-2011 10:33 AM
Extract Photographs The Gap PowerPoint 4 04-22-2010 07:00 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:09 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft