Hi there,
Yup - you can do this in a formula, using the Formula Editor. When you create a Formula, you can then use it on the report page just like a field.
In this case, you would
1. Find the character position (as a number) of the separating character
2. Extract all the characters to the left/right of that position
So it would look something like this:
Left( <<yourfieldname>>, InStr(<<yourfieldname>>, "|") - 1)
This gets all characters to the left of the 'pipe' character.
Right( <<yourfieldname>>, InStr(<<yourfieldname>>, "|") -+1)
This gets all the characters to the right of the 'pipe' character
Second question:
You can do this using concatenation. The 'concatenate' operator is a &. So if you create a formula looking something like this:
<<field1>> & <<field2>> & <<field3>> ...
you'll get the values from the fields 'seamlessly' butted up against each other. If you want separating spaces,
<<field1>> & " " & <<field2>> & " " & <<field3>> ...
inside the concatenated " ... " just type anything you need to sit in between the values - in this case it's a space.
Good luck!
IP Logged
