Adding a hyphen to a string based on certain criteria

Hello Everyone, I am attempting to add a hyphen to an array of strings within my data.

In other words,I need to randomly introduce a hyphen to some fields of medications based on their alphabetical sequence.

Some medications start with "ei", hence I have to place a hyphen after the "i". Hence, I need the field to look like this (excluding the quotes) "ei-dxph"

Medication Name	Condition	Expected Results
eidxph	Hyphen after " ei "	ei-dxph
daxph	Hyphen after "d"	d-axph
oexph	Hyphen after "oe"	oe-xph
9yvhpk	Hyphen after "number and Letter"	9y-vhpk
fhyqx	Hyphen after " f "	f-hyqx

Custom Tools

Parse

Common Use Cases

Best Practices

Dynamic Processing

Accepted answers

dhtay

@ccano

Here's my solution.

I generated a list of prefixes that need to have hyphens added behind them. Then, I used Find Replace with "beginning of string" setting to replace these prefixes with themselves but with an added hyphen.

prefix hyphen.yxmd

All comments

AnthonyJ

Hi, see attached, using a batch macro and a little RegEx to find the pattern of interest and create a new column w/ Med Name, hope this helps....

Here's my solution.

Great! If you always know what the text will be that needs to be parsed then the Find Replace is perfect, if not and it needs to be more dynamic, use RegEx

ccano

Thanks for the quick feedback Anthony!

Unfortunately, my version of alteryx is not up to date (company has to update it for us). Would you mind displaying a screenshot of the solution if possible?

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335