Change specific character in field

Question

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"?

InputExpected Output1234567812345678123D5678123.5678123.456789123.456789333D444D333.444D919191DD919191DD282828R28282828R28AA1010101101AA1010101101874D1234874.123454.123454.1234

Thanks in advance,

Ash

MarqueeCrew · Accepted Answer

@aka_ash ,

no regex!

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

cheers,

mark

huynv96 · Accepted Answer

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