Timeline for Check a field for a single letter
Current License: CC BY-SA 4.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 9, 2022 at 15:01 | history | edited | Adam Spriggs | CC BY-SA 4.0 |
formatting, add marketing-cloud tag
|
| May 2, 2022 at 18:19 | vote | accept | gh0st | ||
| May 2, 2022 at 17:46 | comment | added | Gortonington |
For SQL, it would be a simple using LIKE to determine if there is any place that there is a single char surrounded by spaces. Something like WHERE fName LIKE '% _' OR fName LIKE '_ %' OR fName LIKE '% _ %'.
|
|
| May 2, 2022 at 17:38 | comment | added | gh0st | I would be interested in the SQL to check for one character in a field that could look like (John H or K Smith)? Thanks | |
| May 2, 2022 at 17:38 | answer | added | Gortonington | timeline score: 0 | |
| May 2, 2022 at 17:25 | comment | added | gh0st | It is more of a real time situation, because it's not always the same DE. | |
| May 2, 2022 at 17:21 | comment | added | Gortonington | Is this on a more schedule send that you could use SQL to put a flag in your sendable DE to use to alter the salutation or is this more 'real time' that would require it to be in the email itself? | |
| May 2, 2022 at 17:12 | comment | added | gh0st | Yes, I want to determine if there is just a single character in a name field (John J) for example. The purpose is that they want to control how the salutation looks in the emails sent. So there are some people that have John J or J John in their name, when that happens they want to change the salutation . | |
| May 2, 2022 at 17:07 | comment | added | Gortonington | so you want to be able to detect if there are any 'words' in the string that are just a single character long? This can be done somewhat in AMPscript, but likely would be tremendously easier and more performant to be done via SQL if possible. What is your purpose here? I think this may be a bit of an XY problem that there is another option beyond this ask that can better solve your problem. | |
| May 2, 2022 at 16:55 | history | asked | gh0st | CC BY-SA 4.0 |