Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
I need help parsing a string
daniel_mitrea_1995
Member Posts: 26
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
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
0
Best Answer
-
Options
wait
Member Posts: 53
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..5
Answers
String := Eventstatus='Calculated' and ErrorCode='0000'
String := COPYSTR(String,1,STRPOS(String,'and') - 3);
String := COPYSTR(String,STRPOS(String,'=')+2,STRLEN(String));
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..