Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
iDear Expert,
do you know if there is a way to extract a string between two specific characters?
row1 : ' year=2017, name=Peter, surname=Jon, address= herenstrasse '
row2 : ' surname=Dario, name=Andrea , address= boundstrasse'
I would like to extract for instance all the surname in my table. The order or the data in the string can be casual
Thanks for any helps
try this:
textbetween(YourFieldName,'surname=',',') as Surname
Hi,
can you try something like this:
=SubField( Mid(YourField,Index(YourField, 'surname')+8) ,',',1)
example:
=SubField( Mid('year=2017, name=Peter, surname=Jon, address= herenstrasse',Index('year=2017, name=Peter, surname=Jon, address= herenstrasse', 'surname')+8) ,',',1)
2.
=SubField( Mid('year=2017, name=Peter, surname=Jon, address= herenstrasse',Index('year=2017, name=Peter, surname=Jon, address= herenstrasse', 'surname')+8) ,',',1)
Thanks,
Mohammed Mukram