I Need REGEX Replace, I just dont know how

[AL3XE167]

Hi,

I have concatenated a number of fields and set them out in a very particular format, to be later included in an automated email via Alteryx. My data before concatenation looked like this;

Record ID	Field 1	Field 2	Field 3	Field 4	Field 5
1	Monthly Spend	Monthly Finance Position	Directorate Finance Position	Capital Position	Resource Position
2	BAME	Fixed Term Contracts	Headcount

I have then added a formula to Add each field together

"- "+ [Field 1] +",

- " + [Field 2 +",

-" etc.

This gives me what I want for Record ID 1 but gives me the following for Record ID 2;

- BAME,

- Fixed Term Contracts,

- Headcount,

-,

-,

How do I get rid of the unnecessary characters at the end "-,-," ? I assume REGEX will do it but I am unsure of how to do this.

Thanks in advance

[Greg_Murray · Accepted solution]

hi @AL3XE167,

I might take a slightly different approach, see attached.

[AL3XE167]

Thanks Greg, I was so intent on using REGEX I couldnt even think of any other option. 

Thanks

Alex

[Thableaus · Accepted solution]

Hi @AL3XE167 

@Greg_Murray's solution is definitely elegant and much more helpful, but here's a REGEX that would work:

Using Formula Tool

REGEX_Replace(Field], "(.*\w),.*", "$1")

This would capture everything until your last "word" character.

Cheers,