String extraction

  • Thread starter Thread starter John
  • Start date Start date
hi John,
How can I extract the first line form a multi-line string?
Click to expand...
Use Left(yourString, InStr(yourString, Chr(13) & Chr(10))) to get the
first line.


mfG
--> stefan <--
 
Stefan Hoffmann said:
hi John,

Use Left(yourString, InStr(yourString, Chr(13) & Chr(10))) to get the
first line.
Click to expand...

Or Split(yourString, Chr(13) & Chr(10))(0)
 
hi Stuart,

Stuart said:
MyStringVariable = Left(MultiLine, Instr(MultiLine, vbCrLf) - 1)
Click to expand...
As the OP has posted it also in mpa.queries:

The VBA constant vbCrLf is not available in a query and must be replaced
with Chr(13) & Chr(10) in that case.


mfG
--> stefan <--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Extract Text from decimal separated string 6
Extracting single word from string 2
extract date from text field 1
Extracting a number from a multiline-entry 9
Access access vba multiline textbox 2
undocumented alternative to module CountOfLines, Lines 3
extracting numbers from a string 6
Counting specific characters within a field 5

Back
Top