In String Help (1 Viewer)

[abbaddon223]

Hi,

I'm struggling with what is no doubt something simple - any help really appreciated!!

I have a field: [comment] in which the follow value is as text:

3 from orders_10_11_13_2.csv for order 95D5KJQ8 Adref:Q3035

What I'd like back is just "95D5KJQ8" - so something to split this between "order" and "Adref:"

thanks!!

Phil.

 

[David R]

Will the comment field ALWAYS contain "order" and "adref" like that? If so, why on earth is it a single comment field in the first place... but anyway.

Play with the InStr() function. It'll help you find the end of "order" and (if necessary) the start of "adref", so you can plug them into Mid(). If your order numbers are always going to be exactly the same length you can skip the second step and just set the last parameter of Mid() to 8.