split field 1

[Durango122]

hi
cr 9.0
ms qsl
i have a field that has this
46893028875272320000-Cue Financial Group Inc

i want to see only this
Cue Financial Group Inc

Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40

 

[1973kk]

try the split formula
Split (inputString, delimiter)

 

[lbass]

That would be:

split({table.field},"-")[2]

If the field can be null or missing the "-", use

if ubound(split({table.field},"-")) >=2 then
split({table.field},"-")[2] else
{table.field}

-LB