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

how to convert string into number

Status
Not open for further replies.
abhishekpant

abhishekpant

Programmer
Dec 21, 2004
38
0
0
US
Hi All
I am using XML and CR 10

All the data is in XML Files is not numeric
I want to convert String into Number and insert summary(count) to that field.

can any one help
Thanks
Abhi
 
Sort by date Sort by votes
Hello!
You can use the CDbl function in Crystal to do this...
Create a new formula field and enter the following formula...
CDbl ({Table.Field})
This should convert the string to a number...
Hope this helps!
Boni


Boni J. Rychener
Programmer
Hammerman Associates, Inc.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

cursedkorok
  • Question
Transpose Columns into Rows?
Replies
0
Views
87
cursedkorok
cursedkorok
LauraW
  • Locked
  • Question
Format Numbers in a String
Replies
4
Views
126
LauraW
LauraW
AleXSR700
  • Locked
  • Question
How to find first non-zero decimal place?
Replies
8
Views
109
AleXSR700
AleXSR700
mmck1964
  • Question
Using "OR" to select data
Replies
4
Views
177
mmck1964
mmck1964
socalvelo
  • Locked
  • Question
Limiting the number of records in groups and sub-reports 1
Replies
2
Views
66
socalvelo
socalvelo

Part and Inventory Search

Sponsor

Back
Top