Hello,
I need help on how to delete a dynamic string within a path using Regex:
".\MEMBERRECORDS_SIGNATURECARD_00000000_00000000_0001\" . The last number: _0001\"
".\LOANS_ADVERSEACTION_00000000_00000000_0001\" . The last number: _0002\"
".\MEMBERRECORDS_IRADOCUMENTS_00000000_00000000_0001\" . The last number: _0003\"
So far I have use many similar Regex to this: ^[^_]*_[^_]* But definitely I am ot applying it correectly, it is not working.
Also in the 3rd column where the value is tif or pdf change it for a numeric value, per example: tif = 2, pdf = 16
143|LOANSADVERSEACTION|tif|1|.\LOANS_ADVERSEACTION_00000000_00000000_0001\613742_001.tif||713797998| 143|LOANSADVERSEACTION|tif|1|.\LOANS_ADVERSEACTION_00000000_00000000_0001\613749_001.tif||3633|||11/143|LOANSADVERSEACTION|PDF|1|.\LOANS_ADVERSEACTION_00000000_00000000_0001\613751_001.tif||713799426|143|LOANSADVERSEACTION|tif|1|.\LOANS_ADVERSEACTION_00000000_00000000_0001\613755_001.tif||5229||07/0
This is my code:
private void button2_Click(object sender, EventArgs e) { try { if (string.IsNullOrEmpty(FromFile)) { lblStatus.Text = "Missing CSV Information"; MessageBox.Show("Please select a CSV file first."); return; } if (string.IsNullOrEmpty(ToFile)) { lblStatus.Text = "Missing Save Information"; MessageBox.Show("Please enter save information."); return; } else if (File.Exists(ToFile)) { File.Delete(ToFile); } btnProcess.Enabled = false; lblStatus.Text = "Processing..."; //TIF = 2, PDF= 16 column 6 var lines = File.ReadAllLines(FromFile).Skip(1); string docId = ""; string[] oldLine = null; string pattern = @"\.\\MEMBERRECORDS_SIGNATURECARD_00000000_00000000_\d{4}\\|\.\\LOANS_ADVERSEACTION_00000000_00000000_\d{4}\\|\.\\MEMBERRECORDS_IRADOCUMENTS_00000000_00000000_\d{4}\\"; //string pattern = @"\.\\^[^_]*_[^_]*_00000000_00000000_\d{4}\\"; var sb = new StringBuilder(); foreach (var line in lines) { var newLine = Regex.Replace(line, pattern, "").Replace("\"", "").Split(','); if (docId != newLine[0]) { docId = newLine[0]; oldLine = newLine; } else { for (int i = COPY_FROM - 1; i < newLine.Length; i++) newLine[i] = oldLine[i]; } sb.AppendLine(string.Join("|", newLine)); } File.WriteAllText(ToFile, sb.ToString()); //btnProcess.Enabled = true; //lblStatus.Text = "Completed"; }
Any help will be helpful and appreciate it. Thank you.