Parsing

[jlabre01]

Hi,
I just wanted to know how to parse to string/text format?

jlabre01

 

[Banana]

Need a bit more information. What do you want to do with it? What is the input data type, or are you wanting to do something with a given string (cut off a part or insert something into it or?)

 

[missinglinq]

That's kind of an open ended question! Depends on exactly what you're trying to do! The most commonly used string functions include

• InStr()
• RevInStr()
• Left()
• Right()
• Mid()

and you generally use one or more to isolate a particular part of a string expression. Exactly what are you trying to accomplish?

 

[boblarson]

• RevInStr()

Oops - I think you meant InstrRev not RevInStr

 

[missinglinq]

You are, as usual, correct, Oregon guy! I seldom use it, but get it right the first time about 50% of the time I do use it! But at least I know it exists, which many don't, and it can be very useful!