Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Formatting of String

Status
Not open for further replies.
Corres

Corres

Technical User
Jun 13, 2006
87
CA
CR 9 Oracle 9i

Hi to all!

Would you please help me how to format the field

System - Antas
System - Brasil

to be displayed as Antas or Brasil.

Thank you.
 
Sort by date Sort by votes
Try:

if ubound(split({table.string}," - ")) > 1 then
split({table.string}," - ")[2]

Or you could use:

mid({table.string},instr({table.string},"- ")+3)

-LB
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

B
  • Locked
  • Question
Difference of a field between 2 variable dates
Replies
1
Views
377
hilfy
hilfy
Corinne30
  • Locked
  • Question
Division of currency formula with/without rounding
Replies
7
Views
1K
dgillz
dgillz
LauraW
  • Locked
  • Question
Format Numbers in a String
Replies
4
Views
733
LauraW
LauraW
tlbrown88
  • Locked
  • Question
How does one get the results of a Calculation (SharedVar) on the same line as the Sub Report?
Replies
4
Views
597
tlbrown88
tlbrown88
jchewsmith
  • Locked
  • Question
Formatting an embedded field in Crystal 2016 Support Pack 5 1
Replies
3
Views
443
BobSuruncle
BobSuruncle

Part and Inventory Search

Sponsor

Back
Top