Replace . to ,

Help
1

How to replace 45.567.60 dot after first two nos with ,

1 Like
2

@Thi Check if this is what you needed:
“45.567.60”.Replace(“.”,“,”)

3

it works but all dots converted to ,

4

@Thi So What Should the Output look like?

5

Hi @Thi

Try to explore regex for this issue.but if you have two character before changing the “.” you can use substring and from that create again the string using the foreach loop and concatenate and the logic to add the “,”

cheers :smiley:

Happy learning :smiley:

1 Like
6

Hi @Thi,

Are you sure you want to replace only the third character everytime?

Thanks,
Karthik

7

This will work. Please mark as solution if this helped.

image
image1041×626 23.2 KB

8

“48.45.5646”.Remove(2,1).Insert(2,”,")
@Thi image

1 Like
9

This will work only if the dot is always at 3rd position. Better make it dynamic, to be in the safer side.

10

Hi @Thi,

I’m taking 1 example here for your better understanding, if Number = “45.567.60”

  1. Num2 = "."+Number.Split("."C).Last
    —> Now Num2 will hold “.60” as this is last value if we split with dot.

  2. Num1 = (Number.Replace(Num2,"")).Replace(".",",")
    —> Num1 will hold “45,567”.
    because firstly we did Text1.Replace(Num2,“”) it means —> “.60” with “” —> “45.567”
    Secondly Replace(“.”,“,”) —> so that it becomes “45,567”

  3. NewNumber = Num1+Num2 —> Concatenation of strings “45,567” & “.60” —> “45,567.60”

Note - This will always work, even on 23.44.566.78 —> 23,44,566.78
Because we’ve used .Last on splits Array so it’ll always remain last dot and replace other dots with comma.

2 Likes
11

45,567.60

12

@Thi Go for @samir 's Answer, I find it more Dynamically suitable :sweat_smile:

13

Thank you

2 Likes
14

cheers @Thi

15

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.