AnsweredAssumed Answered

How to find the start and end of data in a field

Question asked by PeterMontague on Sep 4, 2012
Latest reply on Sep 6, 2012 by philmodjunk

Title

How to find the start and end of data in a field

Post

I used the following script to find the start and end of the data in a field. But its not working for me. Can anyone see anything wrong with this script?

If [this:: Start Content <> ""]

Set field [this::gTempText; Middle9this::gTempText; Position9this::gTempText: this::Start Content; 1; 1) + Length9this::Start Content0; Length(this::gTempText))]

End If

If [this::End Content <> ""]

Set Field [this::gTempText; Left(this::gTempText: Position9this::gTempText: this::End Content; 1; 1) -1)]

End If

Outcomes