Does my string full of various delimiters have a specific delimiter in use, but not in the data contained in the string? <p>If we have the new delimiter in place, I know not to use the old one. If my string uses the "," for a delimiter I will continue to use it (and not allow it in data) but if it doesn't I want to use the new delimiter "!".</p> <p>We have a string like “Web Distribution:Walnut Creek &amp; State Specialty - At Home::1757:1-1-3~1:1-1-3~2:1-1-2~0-0~=~1~Yes, complete today while at store~0.b Willing:::”</p> <p>We are doing a test to see if it used ‘!’ as a delimiter string.Contains(“!”)</p> <p>If it does then we are cool</p> <p>If it doesn’t</p> <p>We are testing to see if ‘,’ is used as a delimiter We are doing a simple test of string.Contains(“,”)</p> <p>This is where we have a problem. “Yes, complete today while at store”</p> <p>So how can I say, great it has a “,” but if it’s between two ~ don’t worry about it. Use the ! as the delimiter moving forward and let the “,” live in the question and alert plugin. </p> <p>If the text looks like “Web Distribution:Walnut Creek &amp; State Specialty - At Home::1757:1-1-3~1:1-1-3~2:1-1-2~0-0~=~1~Yes, complete today while at store~0.b Willing^1-1-2~0-0~=~2~Yes, complete later via email~0.b Willing::1-1-2~0-0~=~0~~0.b - Willing!1-1-3~0-0~=~0~~0.c - Email:”</p> <p>It has a “!” and we are cool</p> <p>my current code</p> <pre><code>Friend Const mcItemDelimiterOld As String = "," Friend Const mcItemDelimiterNew As String = "!" Public Shared mcItemDelimiter As String = "!" If sDelimitedText.Contains(mcItemDelimiterNew) Then mcItemDelimiter = mcItemDelimiterNew Else If sDelimitedText.Contains(mcItemDelimiterOld) Then mcItemDelimiter = mcItemDelimiterOld Else mcItemDelimiter = mcItemDelimiterNew End If End If </code></pre>