J
John
Hi
How can I extract the first line form a multi-line string?
Many Thanks
Regards
How can I extract the first line form a multi-line string?
Many Thanks
Regards
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Stefan Hoffmann
hi John,
first line.
mfG
--> stefan <--
Use Left(yourString, InStr(yourString, Chr(13) & Chr(10))) to get theHow can I extract the first line form a multi-line string?
first line.
mfG
--> stefan <--
D
Douglas J. Steele
Stefan Hoffmann said:hi John,
Use Left(yourString, InStr(yourString, Chr(13) & Chr(10))) to get the
first line.
Or Split(yourString, Chr(13) & Chr(10))(0)
S
Stuart McCall
MyStringVariable = Left(MultiLine, Instr(MultiLine, vbCrLf) - 1)
S
Stefan Hoffmann
hi Stuart,
The VBA constant vbCrLf is not available in a query and must be replaced
with Chr(13) & Chr(10) in that case.
mfG
--> stefan <--
As the OP has posted it also in mpa.queries:Stuart said:MyStringVariable = Left(MultiLine, Instr(MultiLine, vbCrLf) - 1)
The VBA constant vbCrLf is not available in a query and must be replaced
with Chr(13) & Chr(10) in that case.
mfG
--> stefan <--