Finding pattern using in c#

Question

I have a couple of strings and I want them to be transformed like shown below

In the first two examples " is included in the input string. But " does not comes always with the input string as shown in last two examples.

Basically I need the string between |" and "| or string between first and last occurrence of |

Can someone please let me know how to find the match for the output string that I need which will work for all of these strings? I am trying to code these in C#.

Thanks in advance for any help

Remove all quotes from the string and then drop the first 10 characters and the last one. `text = text.Replace("\"", ""); text = text.Substring(10, text.Length - 11)` — Sefe, Nov 05 '20 at 08:15

Mong Zhu · Answer 1 · 2020-11-05T08:21:36.943

I would propose an alternative to regex. Simply using Substring and Replace:

List<string> input = new List<string>
{
    "501000061|\"B084PD449Q|2088|1\"|",
    "504000585|\"B000NSIAG0|3115|0\"|",
    "508000036|B084S1FVH5|42|1|",
    "504000584|B000NSIAG0|3115|0|"
};

foreach (var element in input)
{
    string transformed = element.Substring(10, element.Length - 11)
                                .Replace("\"", string.Empty);
    Console.WriteLine(transformed);
}

Output:

B084PD449Q|2088|1
B000NSIAG0|3115|0
B084S1FVH5|42|1
B000NSIAG0|3115|0

score -1 · Answer 2 · answered Nov 05 '20 at 08:19

^[0-9]{9}\|"?([A-Z0-9]){10}\|([0-9]){2,}\|([0-9])"?\|$

This regex is a bit more rigid than the ones already proposed based on the input examples that you've provided.

I suggest you look into non-regex solutions that have already been pointed out, however, if you absolutely must use regex here's how to do it in C# for this example.

  var pattern = @"^[0-9]{9}\|"?([A-Z0-9]){10}\|([0-9]){2,}\|([0-9])"?\|$";
  var replacement = "$1|$2|$3";
  var input = "501000061|\"B084PD449Q|2088|1\"|";
  var result = Regex.Replace(input, pattern, replacement);

score -1 · Answer 3 · answered Nov 05 '20 at 08:19

Here's one without regex:

using System;
using System.Linq;
                    
public class Program
{
    public static void Main()
    {
        var inp = "504000585|\"B000NSIAG0|3115|0\"|";
        
        var res = string
            .Join("|", inp.Split(new []{'|'}, StringSplitOptions.RemoveEmptyEntries).Skip(1))
            .Replace("\"", "");
        Console.WriteLine(res);
    }
}

https://dotnetfiddle.net/i39XUY

B000NSIAG0|3115|0

Finding pattern using in c#

3 Answers3