Selecting specific data within a string 1

[JulesDBQ]

I would like to create a formula that selects any text that displays to the left of a static symbol within a string. For example:

manpc01|%fakjfisufasdfsdf787fs87f

In this case, I would just want to select manpc01. So, I would want to select any text left of the |% symbols. I then want to take the results of this formula (manpc01, etc) and group my report by this value. Does this seem like a possiblity?


Thanks for any help on this. I really appreciate it.

 

[lbass]

Try:

left({table.string},instr({table.string},"|%")-1)

You should be able to group on this.

-LB

 

[JulesDBQ]

Thank you so much!! That did exactly what I wanted.

 

[synapsevampire]

Another means is:

split({table.field},"|")[1]

The split and join functions are worth understanding for cheating parsing and for array functions.

-k