Viraj
Data Storage
Joined 5 years ago
User Profile
User Widgets
Contributions
Re: Is there any way to convert a string to a number?
Then you can use SUBSTRING to extract number from string. Formula: SUBSTRING(string,index,length) Returns the substring of a specified length, starting at a specified index. sample : Input string is : ABC123 Formula: TOINT(SUBSTRING('ABC123',3,3) Output: 123 No, you cannot convert 'ABC123' to Double or Integer.7.7KViews2likes0CommentsRe: Is there any way to convert a string to a number?
Hey, Try to create custom column for your table and use following formula. Source: Sisense Mathematical functions TOBIGINT(string) Converts a string representing a valid BigInt value to BigInt type. TODOUBLE(string) Converts a string representing a valid double value to Double type. TOINT(string) Converts a string representing a valid Int value to Int type.7.7KViews2likes2Comments