Change format name with comma 1

[TheLazyPig]

Hi!

How can I change Lastname;Firstname;mi to Lastname, Firstname mi?


Thanks in advance.

 

[Andrzejek]

If you have this data in your table:
[tt]
table: People
Person
Brown; Jack; X
White; Susie; Q[/tt]

and you want to have:
[tt]
table: People
Person
Brown, Jack, X
White, Susie, Q[/tt]

You can simply do:[tt]
Update People Set Person = Replace(Person, ';', ',')[/tt]

Unless you want something completely different...

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

 

[carp]

If you want the first semicolon changed to a comma and the rest changed to a blank, I think this will do it.
Full disclosure - not tested.

... substr(Person, 1, instr(person,';')- 1 )||', '||REPLACE(substr(person,instr(person,';')+1),';',' ') ...

 

[TheLazyPig]

The code was working. Maybe the problem is where I run it. I'm running it on foxpro v9 but the tables I used is from an oracle db.