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!
-
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!
Search results for query: *
- Users: SandyKerivan
- Order by date
-
Extract number from string field in Crystal reports
Hi, Thanks for your help, I got it to work both ways. I am going with Ido's suggestion of right({table.field},5) becuase after I got Brian's idea to work with LB's fix, I noticed not everyone inputting info into the database is putting a space between the word "quote" and the number so it still...- SandyKerivan
- Post #6
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Extract number from string field in Crystal reports
hi Brian, Thanks for the tip, I think the number is always last. I just tried it though and it is saying "This array must be subscripted. For example: Array [i]" and it is highlighting the part of the formula that says : split({SV00300.Service_Description}, " ") I've never dealt with...- SandyKerivan
- Post #3
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Extract number from string field in Crystal reports
Hi, I am trying to extract a number (a quote number which is always five numbers long) out of a string field that is not in any consistent pattern. For example, the string field could be "quote number 12345", "quote no. 12345", "approved quote 12345". I see the function VAL, but that needs the...- SandyKerivan
- Thread
- Replies: 8
- Forum: Business Objects: Crystal Reports 1 Formulas
