Parse Strings - Quick Guide

str = "123456"

'LEN
'Get length of entire string

len(str) 'will return 6

'LEFT
'Get characters from the left

left(str,3) 'will return 123

'RIGHT
'Get characters from the right

right(str,3) 'will return 456

'REPLACE
'Replace a part of a string

str = "This is a sample..."

replace(str, " ", "_") 'will return This_is_a_sample...

0 Comments

You must be logged in to post a comment.