I'm using the replace function to select a "," and put in an "&". I only want to replace once and I need it to to start after x characters, we will say 5 just for this example.
Replace([string],",","&",5,1)
That is the command I am using.
The problem is that if I use that function, it deletes all characters before 5
This is what I start with
This is what I end with
Any idea why the start attribute for replacing is removing all characters before it? I would like to keep all characters, but just begin searching and replacing after 5.
Replace([string],",","&",5,1)
That is the command I am using.
The problem is that if I use that function, it deletes all characters before 5
This is what I start with
- Alfaro, L., Charlton
- Baum, J. R., Locke, E. A.
This is what I end with
- ro & L., Charlton
- & J. R., Locke, E. A.
Any idea why the start attribute for replacing is removing all characters before it? I would like to keep all characters, but just begin searching and replacing after 5.