Replace

[kirkm]

This is not working as expected

= Replace(Dat, " - ", "\", 1, 1)


I expected the first instance in Dat of " - " to be replaced with "\". But it replaces 2 instances.
What exactly does the ,1,1 do ?

 

[bob fitz]

Where are you using the expression?
What is the data type of Dat?
Show us an example of the data in Dat

 

[CJ_London]

the first 1 is the start position the second is the number of substitutions, so I would expect it to work

?replace("123 - 456 -789"," - ",1,1)
1231456 -789

perhaps show some example data and the result

 

[Cronk]

CJ, a typo, That should be (according to #1)
?replace("123 - 456 -789"," - ","\",1,1)
123\456 -789

 

[CJ_London]

oops

too early in the morning

 

[Isaac]

the first 1 is the start position the second is the number of substitutions, so I would expect it to work

?replace("123 - 456 -789"," - ",1,1)
1231456 -789

perhaps show some example data and the result

+1 on my end it also works as expected, only replaces the first instance of -

 

[Gasman]

This is not working as expected

= Replace(Dat, " - ", "\", 1, 1)


I expected the first instance in Dat of " - " to be replaced with "\". But it replaces 2 instances.
What exactly does the ,1,1 do ?

Are you running it twice by accident?