error the string is non numeric, how can I solve this problem?

Question

1.00/5 (1 vote)

See more:

Hi, I have this problem in crystal report. I get this error the string is no numeric. How can I solve this problem?

VB

if {SelOperActivityView.UserActivity} like "Added Card : *" then
    ToNumber (mid ({SelOperActivityView.UserActivity},26,11))
 else if {SelOperActivityView.UserActivity} like "Modified Card*" then
        ToNumber(mid({SelOperActivityView.UserActivity},29,(instr (29,{SelOperActivityView.UserActivity},":")-29)))
 else if {SelOperActivityView.UserActivity} like "Deleted Card :*" then
    ToNumber(mid({SelOperActivityView.UserActivity},28,8));

Posted 2-Feb-15 1:57am

Member 11420569

Updated 2-Feb-15 2:18am

CHill60

v2

Add a Solution

Comments

CHill60 2-Feb-15 8:18am

For what value of SelOperActivityView.UserActivity is it failing?

Member 11420569 2-Feb-15 8:28am

the {SelOperActivityView.UserActivity}is an text and number so I use this function to get only the number ToNumber (mid ({SelOperActivityView.UserActivity},26,11)). there is were it fails.

CHill60 2-Feb-15 8:33am

As I said - what is the value of that at the time it is failing?

Member 11420569 2-Feb-15 8:40am

the string is non numeric. And this the value exp mid({SelOperActivityView.UserActivity},26,11):"19571111,0"

CHill60 2-Feb-15 8:44am

Well that comma will make it non-numeric unless you have your culture set up as one that uses commas for decimal point

Member 11420569 2-Feb-15 9:25am

Ok so the comma is giving me this problem. where can I change the set up to use the commas for decimal point or how can delete the comma?

CHill60 2-Feb-15 9:43am

It would probably be far easier just to amend the ToNumber function to take the whole of SelOperActivityView.UserActivity - what form is that in? I know it's a string but in what format?
The split function might work but I'll need to see what that variable looks like "in the raw"

Member 11420569 2-Feb-15 9:59am

Hmmm it is in a nvarchar format.

CHill60 2-Feb-15 10:09am

Sorry I meant how it looks ... e.g. "XXXXXX,99999999,99". You've already set that the first bit is text and then a number - is the text fixed length, is the number fixed length, are the portions separated by commas (or anything else)

Member 11420569 2-Feb-15 10:27am

Added Card: Card Number: 75860 this is the format then
and the length:2049
It is not by commas separated

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CHill60 · Accepted Answer · 2015-02-02T05:54:00

The problem is in your ToNumber function and the way you are extracting the numbers.

There are a few ways of doing it - these samples are in C# but you should get the idea...

If you are able to use Linq then

C#

private string ToNumber1(string parm)
{
    var num = parm.ToCharArray().Where(c => Char.IsDigit(c)).ToArray();
    return new String(num);
}

If you are able to use Regex then

C#

private string ToNumber2(string parm)
{
    //You will need using or imports System.Text.RegularExpressions or the equivalent
    var num = Regex.Match(parm, @"\d+").Value;
    return num;
}

Worst case scenario you can step through the string extracting the numbers "manually"

C#

private string ToNumber3(string parm)
{
    //NB as strings are immutable this is not really a good way of doing this
    //If you are able then use the StringBuilder class instead
    string num = string.Empty;
    for (int i = 0; i < parm.Length; i++)
        if (char.IsDigit(parm[i]))
            num += parm[i];
    return num;
}

Alternatively, post the code for your ToNumber function and I'll see if I can fix it.

In Crystal Syntax the function would look something like this (Warning - not tested nor syntax checked)

//parm is the input string

Local StringVar num  := "";
Local NumberVar i;
For i := 0 To Length(Parm) - 1 Do
(
    Local StringVar parmChar := parm [i];
    Local BooleanVar isDigit := parmChar in "0" to "9";
    If IsDigit Then
    (
        num := num + parmChar;
    )
);
num