cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Discovery is online this week, April 16 and 18. Join us for these exciting interactive sessions.
Choose Language Hide Translation Bar
twillkickers
Level III

Replace Third Character from Left in a String in JSL

I would like to take a column with a string in it, and in each row, replace the third character from the left with a "9." How might I go about this using JSL?

1 REPLY 1
txnelson
Super User

Re: Replace Third Character from Left in a String in JSL

Here is the simple script

Names Default To Here( 1 );

dt = Current Data Table();

For Each Row(
	dt:YourColumn = Substr( dt:YourColumn, 1, Length( dt:YourColumn ) - 4 ) || "9" ||
	Right( dt:YourColumn, -2 )
);

I strongly suggest that you take the time to read the Scripting Guide, so that you will have the background knowledge that will allow you to solve these questions

Jim