String extraction

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi

How can I extract the first line form a multi-line string?

Many Thanks

Regards
 
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)
 
MyStringVariable = Left(MultiLine, Instr(MultiLine, vbCrLf) - 1)
 
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 <--
 
You must log in or register to reply here.

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
Access access vba multiline textbox 2
Extracting a number from a multiline-entry 9
undocumented alternative to module CountOfLines, Lines 3
extracting numbers from a string 6
Outlook Looking for macro to save multiple emails as .msg to folder and extracting the invoice ref. from the email body as the filename 4

Back
Top