How do I remove specific text in a string using substring

Question

My string is this:

fileName, callDateTime, sum(callDuration) AS 'Call Duration', callRecorder, equipmentId, errorMessage, extractionDateTime, interactionId, interrupted, extractionSuccess, stitching, bytes, conversionTime, stitchingTime, transferTime, remoteErrorMessage, remoteTransferDateTime, size, remoteTimeToTransfer, extractionStartDate, extractionEndDate, purpose, ruleName, ruleSession, fileOutputFormat, extractedBy, vaultName, vaultType, vaultRemotePath, stitchingTime

I want to remove this part of the text:

"sum (callDuration) AS 'Call Duration',"

I am using this piece of code to try to address this problem:

 var getSumIndex = resultAggOrField.IndexOf($"{rowGroup.AggFunc}");
 var getFieldIndex = resultAggOrField.IndexOf($"'{rowGroup.DisplayName}'");
 var delete = resultAggOrField.Substring(getSumIndex, getFieldIndex);
 resultAgg = resultAggOrField.Replace(delete, string.Empty);

But for some reason, he takes this part of the text:

sum(callDuration) AS 'Call Duration', callRec

When you debug, what is the value of rowGroup.AggFunc? Of rowGroup.DisplayName? Of getSumIndex? Of getFieldIndex? Of delete? Basically, which specific operation is producing an unexpected result? — David
– David, Commented Nov 19, 2019 at 20:25
Result of the delete variable: "sum(callDuration) AS 'Call Duration', callRec" I want it to be: "sum (callDuration) AS 'Call Duration'," — Thiago Simão
– Thiago Simão, Commented Nov 19, 2019 at 20:30

David · Accepted Answer · 2019-11-19 20:33:15Z

2

Your variable names imply that you misunderstand how the Substring(int, int) method works. The second argument is not an index, it's a length.

Whether you want to hard-code the length for "sum (callDuration) AS 'Call Duration'," or dynamically calculate it (and how you'd dynamically calculate it) is really up to you. But you need to tell the Substring() method the size of the substring to remove, not the ending index of the substring to remove.

answered Nov 19, 2019 at 20:33

David

221k42 gold badges246 silver badges338 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How do I remove specific text in a string using substring

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related