find last object by spliting string

[Mbakker71]

Hello,

i've a code that can split strings. but now i want the last thing he split in a string named "name".



the string what is split is folder places like C:\Users\inengine@mccain.com\Documents\Test\van\te st.txt.

now i want that text.txt comes in 'name'

who can help me?

martijn

[JoeM]

Can post post your code?

[rpeare]

DisplayValue: right([Fieldname], len([fieldname]) - (instrrev([Fieldname], "\") + 1))

if you're doing it in a query


dim sDisplayValue

sDisplayValue = right([Fieldname], len([fieldname]) - (instrrev([Fieldname], "\") + 1))

if you're doing it in code

the key here is using a combination of the LEN and INSTRREV functions innate to Access

Len gives you the length of a string
INSTRREV finds the first instance of a string starting at the END of the string
INSTR finds the first instance of a string starting at the BEGINNING of the string