is it possible to do substring on multiple characters? in this example i only replacing the 14th character with x
but how about i want to replace more than 1 character? is possible?
TIA
we can chain statements as long it will return a value and references get not lost
We would suggest following:
- provide some sample input text
- the variables involved
- expected output
maybe also alternate strategies can be applied
Hi @joscares
Is selection of the character position and number of character random or is following any pattern?
But we will look for more simple alternates as well. just give us some little time
yes as much as possible the character position(index) and number of characters will be configurable
nice but how about on multiple characters? TIA
Can you be more specific as we masked multiple characters
Yeah i mean is is it possible to masked different position characters like this
some protoype here:
And another approach here:
all can also dynamically calculated e.g. by length / length and randoms…
okay the second one might work let me try it ill tell you my results
i’m having an issue writing down that code.
(
From a In dt_Internal
Let Date1 = a(“Date”).ToString
Let TransID = a(“Trans ID”).ToString
Let MSISDN = a(“MSISDN”).ToString
Let Type = a(“Type”).ToString
Let Channel = a(“Channel”).ToString
Let State1 = a(“State”).ToString
Let Amount = a(“Amount”).ToString
Let Target1 = a(“Target”).ToString
Let LongTransID =a(“Long Trans ID”).ToString
Let Details = a(“Details”).ToString
Let TraceNo = Details.Substring(9,6).ToString
Let UniqueIdentifier = TraceNo+ “-” + Target1.ToString
Let New String(UniqueIdentifier.Select(Function (x, i) If({5,2,3,1}.Contains(i), "*"c,x)).ToArray)
Select dt_InternalUID.Rows.Add( UniqueIdentifier, Date1, TransID, MSISDN, Type, Channel, State1, Amount, Target1, LongTransID, TraceNo ,MaskedUniqueIdentifier)
).CopyToDatatable
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.