I need help parsing a string

daniel_mitrea_1995

I have this connection string.
String := Eventstatus='Calculated' and ErrorCode='0000'

This string will always have this format but can differ the number of the fields and the operator (it can be 'AND' or 'OR')

How I can parse this string in order to get those fields and values and then to filter a specific record accordingly ?
I should take all the table fields and compare with the spllitted strings ?

In the end I have to filter the record with those values. For example in this case:
Rec.SETRANGE(EventStatus,'Calculated');
Rec.SETRANGE(ErrorCode,'0000');

Thank you

wait

daniel_mitrea_1995 wrote: »

Correct, but my question was about the table fields. Maybe I mispronounced it.
How do I know which table field corresponds to the splited string. Do I have to take all the fields in the table, one at a time, and compare them to the string?
or is there another solution?

Ok I see, I missed the part where you said there can be different fields in the string

There are many way's you can do it but what I would do is to split the string on AND's and OR's then Parse each field name and value. Next step would be to filter on the fields that are in the string.

ex. how I would do it


WHILE (STRPOS(String,'AND') > 0) OR (String,STRPOS('OR') > 0) DO BEGIN
//Get next field name and field value and insert into temp table
//Delete the field from the string
END;


IF TmpTable.FINDFIRST THEN
REPEAT
CASE TmpTable."My Field Name" OF
'Eventstatus' : Rec.SETRANGE(EventStatus,TmpTable."My Field Value");
'ErrorCode' : Rec.SETRANGE(ErrorCode,'0000');
END;
UNTIL TmpTable.NEXT = 0;

IF Rec.FINDFIRT THEN
Do Stuff..

wait

You can do this using COPYSTR and STRPOS, something like the following should work I would think

String := Eventstatus='Calculated' and ErrorCode='0000'

String := COPYSTR(String,1,STRPOS(String,'and') - 3);
String := COPYSTR(String,STRPOS(String,'=')+2,STRLEN(String));

daniel_mitrea_1995

Correct, but my question was about the table fields. Maybe I mispronounced it.
How do I know which table field corresponds to the splited string. Do I have to take all the fields in the table, one at a time, and compare them to the string?
or is there another solution?

wait

daniel_mitrea_1995 wrote: »

Correct, but my question was about the table fields. Maybe I mispronounced it.
How do I know which table field corresponds to the splited string. Do I have to take all the fields in the table, one at a time, and compare them to the string?
or is there another solution?

Ok I see, I missed the part where you said there can be different fields in the string

There are many way's you can do it but what I would do is to split the string on AND's and OR's then Parse each field name and value. Next step would be to filter on the fields that are in the string.

ex. how I would do it


WHILE (STRPOS(String,'AND') > 0) OR (String,STRPOS('OR') > 0) DO BEGIN
//Get next field name and field value and insert into temp table
//Delete the field from the string
END;


IF TmpTable.FINDFIRST THEN
REPEAT
CASE TmpTable."My Field Name" OF
'Eventstatus' : Rec.SETRANGE(EventStatus,TmpTable."My Field Value");
'ErrorCode' : Rec.SETRANGE(ErrorCode,'0000');
END;
UNTIL TmpTable.NEXT = 0;

IF Rec.FINDFIRT THEN
Do Stuff..

daniel_mitrea_1995

You did it.. again. Thank you