String modification operations in X++

(0) Share

Report

Posted on by AnoopNair

Hi Experts,

I have a table column with datatype EdtString with String Size Memo and few number of records with different values.

Tried with strReplace() & StrKeep() but didn't worked out since the value of properties will be different for different records.

Example for a particular row of record.

String Stored in Table :

{"Source":"D365A","JobTypeId":"Clerical","Description":"Clerical","ExemptStatus":"NonExempt","PaidHourly":"No","ExtIntId":16928090031}

Is there a way to remove the below highlighted property and values (values may be different for different rows in table) for Source & ExtIntId and display it in UI.

{"Source":"D365A","JobTypeId":"Clerical","Description":"Clerical","ExemptStatus":"NonExempt","PaidHourly":"No","ExtIntId":16928090031}

So, the expected result string looks like

{"JobTypeId":"Clerical","Description":"Clerical","ExemptStatus":"NonExempt","PaidHourly":"No"}

Thanks Much

Anoop

I have the same question (0)

All responses (4)

Answers (1)

Martin Dráb 237,965 Most Valuable Professional on at

Like (1)

Report

You have two main options: Either you'll work with it just as with a generic text, or you'll utilize the fact that it's JSON (e.g. you deserialize JSON to an object and work with the object).

I think the best solution may be using System.Text.RegularExpressions.Regex::Replace().

Let us know if you need help with writing the regular expressions.

Was this reply helpful? Yes No
AnoopNair 85 on at

Like (0)

Report

Thanks much for the input Martin!

Yes i was thinking of deserialize JSON as an object as one of the solution option.

Can you please help me to understand more on writing the regular expressions as that may be one of the best solution approach for this scenario to proceed on.

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,965 Most Valuable Professional on at

Like (2)

Report
Try the following pattern:

"Source":"[^"]*",|,"ExtIntId":\d

To test it, you can use an online Regex tester (which is what I did). Tick "Replace matches with.." checkbox and leave the replacement value empty, which will replace texts matching the pattern with an empty string.

If you're not familiar with regular expressions, it'll help you if I explain the pattern a little bit...

The pattern consists of two sub-patterns; one for Source and one for ExtIntId. It'll find texts matching either of these two patterns.

The first pattern is

"Source":"[^"]*",

It finds texts starting with "Source":" (nothing complicated here), followed by any number of characters (including zero) except of ". If we included ", we would match more than what we wanted. And then the string must continue with ", (we want to match the comma as well, so it gets removed when we replaced the matching string with an empty string).

The other pattern is even simpler:

,"ExtIntId":\d

\d matches one or more digits.

Was this reply helpful? Yes No
AnoopNair 85 on at

Like (0)

Report

Thanks Much Martin!

Details provided helps lot for me to understand more on Regex and proceed with the solution

Was this reply helpful? Yes No

Join the conversation

Community site session details

String modification operations in X++

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

String modification operations in X++

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates