Change specific character in field

[aka_ash]

Hi,

Looking for some guidance on the below scenario.

For the example below how can I replace the 4th character in the Input to "." if it is a "D"?

Input	Expected Output
12345678	12345678
123D5678	123.5678
123.456789	123.456789
333D444D	333.444D
919191DD	919191DD
282828R28	282828R28
AA1010101101	AA1010101101
874D1234	874.1234
54.1234	54.1234

Thanks in advance,

Ash

[MarqueeCrew · Accepted solution]

@aka_ash ,

no regex!

IIF( Substring([Input],3,1) = "D", Left([Input],3) + "." + Substring([Input],4) , [Input] )

 cheers,

 mark

[huynv96 · Accepted solution]

Hi @aka_ash ,

It may help you:

Formular:

IF Substring([Input],3,1)="D"
THEN
Substring([Input],0,3) + "." + Substring([Input],4,Length([Input])) ELSE [Input]
ENDIF

[aka_ash]

Hi @MarqueeCrew & @huynv96 ,

Thanks for your advice, great to see that there are a couple of ways to achieve the result, both methods work for me.

Thanks again,

Ash