returning the nth character in a string

• Nov 14, 2003

• #2

GoatieEddie

Technical User

Nov 3, 2003

177

CA

mid(String,3,1) should do it.

Goatie

 

Upvote 0 Downvote

• Nov 14, 2003

• Thread starter
• #3

Luis939

MIS

Feb 28, 2003

453

US

yea i know, but i just wanted to know if theres one direct function that says return character-n , not a function like the mid function that says starts at position 3 and collect just one character, but thanks anyway!

 

Upvote 0 Downvote

• Nov 14, 2003

• #4

Zathras

Programmer

Nov 12, 2002

3,317

US

[blue]

Code:

   AChar := AString[3];

[/color]

 

Upvote 0 Downvote

• Nov 14, 2003

• #5

Zathras

Programmer

Nov 12, 2002

3,317

US

Sorry, wrong forum. Thats Pascal.

 

Upvote 0 Downvote

• Nov 14, 2003

• Thread starter
• #6

Luis939

MIS

Feb 28, 2003

453

US

Yea i knew that syntax was of another language lol!

 

Upvote 0 Downvote

• Nov 14, 2003

• #7

Zathras

Programmer

Nov 12, 2002

3,317

US

Write your own:
[blue]

Code:

  =ThirdChar(A1)

[/color]
You can implement it this way:
[blue]

Code:

Function ThirdChar(AString As String) As String
  ThirdChar = Mid(AString, 3, 1)
End Function

[/color]

 

Upvote 0 Downvote

• Nov 14, 2003

• Thread starter
• #8

Luis939

MIS

Feb 28, 2003

453

US

Oh yea i never thought about writing my own function, there so many VBA pre-defined functions, its as if you think they will cover everything you ever need, but nope cant be that trusting, thanks!

 

Upvote 0 Downvote