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

convert string to number

Status
Not open for further replies.

mart10

MIS
Nov 2, 2007
394
GB
How can I convert this string to a number and format with commas

extractstring({T320.F320X2},"BIPLIM:",";")


I am using CR10
 
mart10,

Code:
ToNumber(extractstring({T320.F320X2},"BIPLIM:",";"))
should do the trick.

Hope this helps!

Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top