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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Insert commas into a string

Status
Not open for further replies.
JodyAmy

JodyAmy

Programmer
Feb 12, 2001
21
US
Using Crystal Reports 5.0 (unfortunately) in a Peoplesoft environment using Oracle 7. I need to be able to insert a comma after each alphanumeric value in a string field. I'm thinking this will be very complex since I will not know how many values will be entered or the format that they are entered. I was thinking of using a For Loop to go through the string field and add a comma before every blank space. Is a For Loop possible to include in a formula?? Does anyone know of an easier way to do this.

TIA!!

Jody
 
Status
Not open for further replies.

Similar threads

JustMe24
  • Locked
  • Question
How to select from 2 rows in a table
Replies
1
Views
245
SoftwareRT
SoftwareRT
PremHealth1
  • Locked
  • Question
How do I drill into a report footer summary value to display all detail data?
Replies
5
Views
177
lbass
lbass
Ajmal N
  • Locked
  • Question
Compare a field from main report against a field from a subreport on CRYSTAL REPORT
Replies
7
Views
323
kray4660
kray4660
Ajmal N
  • Locked
  • Question
Compare a field from main report against a field from a subreport on CRYSTAL REPORT
Replies
5
Views
230
dgillz
dgillz
cpjeffm
  • Locked
  • Question
Need the ability to paste in a list of values into a parameter in Crystal XI
Replies
4
Views
323
hilfy
hilfy

Part and Inventory Search

Sponsor

Back
Top