RegEx help needed

[Brad1]

Hi,

I'm trying to place a comma and a space after the letter 'X' whenever it is found.  Also the last character will be an 'X' - I'm not wanting a comma or space there.  Example.

123X7QAX40Z1X

becomes

123X, 7QAX, 40Z1X

Thanks in advance for any help.

[binuacs · Accepted solution]

@Brad1 one way of doing this with the replace() function

[Brad1]

Works great.  Very nice.  Thanks.