Need to break apart string according to comma location 1

[scauffiel]

Hey fellas, I'm simply trying to get a first and last name from a field whose data is separated by a comma. My field, {@Name}, shows up as "LastName, FirstName". I want to make it normal as this is for the 'Pay To' block for checks; "FirstName LastName".

I've been playing with LEFTs and RIGHTs and INSTRs all day and it's kicking my butt. Any ideas?

Steve

 

[synapsevampire]

Depends upon your version of Crystal, try this:

split({table.field},",")[2]+" "+split({table.field},",")[1]

-k

 

[scauffiel]

DANG BROTHER!! You NAILED it!! Holy monkey! I'm gonna have to look up that whole split thing... Man, thanks very VERY much!!

You rock!

Steve