How to select characters inside a field (String)

(0) Share

Report

Posted on by Josh_

126

Hi guys!

I had job to update this field that will include new emails, now the new requirement is I have to delete some of those email names but confronted with this issue, since those emails on one field only (type is String), how do I select this field logicaly? kindly see my example below,

email name to delete: john@example.com

example record1: james@exampe.com;john@example.com;fox@example.com

example record2: john@example.com;james@example.com;fox@example.com

your help guys is much appreciated, Thank you!

I have the same question (0)

All responses (3)

Answers (3)

Verified answer

Satish Panwar 14,671 Moderator on at

Like (0)

Report

Hi Kenneth,

Can you see if function below works for you.

imdaxershiv.blogspot.com/.../string-functions-in-ax-2014-1.html

docs.microsoft.com/.../xpp-string-run-time-functions

Was this reply helpful? Yes No
Verified answer

Blue Wang on at

Like (0)

Report

Hi Kenneth,

You can use strScan to first confirm the existence of the character (note that it is case sensitive), and then use strReplace to process it.

Crude code example:

Note: When the destination email address is at the end, there will be ";" residues, so also need to confirm in advance.

Was this reply helpful? Yes No
Verified answer

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

Like (0)

Report
I'm not sure what you mean by to "logically" select a field.

If you mean how to select records where a certain string is somewhere inside a field, use the like operator.

select myTable where myTable.MyField like '*value*';

Nevertheless note that it's very slow and that the whole problem is caused by a wrong database design (violating the first normal form). Instead of having a single field containing three addresses (for example), the correct design would be having a relation table with three records. Selecting data from such a table is trivial and very fast (because you can easily index the field). This is what relational databases are designed for.

Was this reply helpful? Yes No