Link to home
Start Free TrialLog in
Avatar of Eduardo Fuerte
Eduardo FuerteFlag for Brazil

asked on

How to manipulate a memo field to extract string contents?

Hi Experts!

I'm facing a challenge in edit a memo field accordingly to:

User generated image
So, I need to extract string parts to include in another table.

Could you point a way on doing that ?
(maybe a manipulation memo class you know)

Thanks in advance!
ASKER CERTIFIED SOLUTION
Avatar of Pavel Celba
Pavel Celba
Flag of Czechia image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of jrbbldr
jrbbldr
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Eduardo Fuerte
Eduardo Fuerte
Flag of Brazil image

ASKER

Thanks for the replies

I found elsewhere this function to tranform a memo into string
Function memo2string(memovar)
Private cErgebnis As String

cErgebnis = ''

For i=0 To Memlines(memovar)
	cErgebnis = cErgebnis + Mline(memovar, i)
Endfor

Return cErgebnis
Endfunc

Open in new window


And then use AT(),  STRTRAN() and SUBSTR()   to do the job