Get substring from text between first and second instance of a set of characters

Help
1

Here is my String it begins with ‘>>>’ but the forum browser sees that as something else:

304 Sloan Rd, Nashville, TN>For Rent>$1,600+ 1 bd>>>522 Madison St, Nashville, TN 37208>>$1,600/mo>1 bd1 ba695 sqft>>>817 3rd Ave N # 206, Nashville, TN 37201>>$1,600/mo>1 bd1 ba893 sqft>5 >>>

I need to extract a substring from the first instance of ‘>>>’ to the second instance of ‘>>>’. So essentially I’m trying to get:

304 Sloan Rd, Nashville, TN>For Rent>$1,600+ 1 bd>>>522 Madison St, Nashville, TN 37208>>$1,600/mo>1 bd1 ba695 sqft

2

Hi @css

You can use the “split” method.

Do this.

Split(Text,“>>>”)(0) or Split(Text,“>>>”) (1)

This method is returned in an array.

Based on “>>>” the front is 0 and the back is 1

3

Thank you, that worked great.

1 Like
4

@css

have a nice day :slight_smile:

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.