Excluding text before character

[shedboyxx]

Hi folks,

I have a feeling this is simple but I’m coming up blank. I have a field that contains text separated by backslashes. The number of backslashes are always the same

example 1
info1\info2\information3\info4\info5\here's what I want to exclude

I’m looking for a calculation that gives me all of the text that happens before the 5^th occurrence of a backslash.

example 2
info1\info2\information3\info4\info5

I tried using Find, Right and Left in different combinations but failed

Let me know if you have something that will work.

TIA

Jim

 

[T. Valko]

The ^ symbol is typically used in math to mean "to the power of".

For example:

10^3 means 10 to the 3rd power or 10 * 10 * 10 = 1000

We can express that in a formula:

=10^3

Just to add...

You may be wondering why we used that character?

We used it because there is probably a very good chance that the data you're dealing with DOES NOT CONTAIN that character.

What the formula does is it finds that 5th slash and replaces it with the ^ symbol. Then we use the ^ symbol as a unique marker to tell us where we need to parse the sting.

So, it's important to use a symbol(s), which can be any symbol(s), that will be unique to the string being examined.

Edit: symbol(s) can also mean character(s).