Challenge #402: Parsing Equipment Tags

[binuacs]

Spoiler

[tsoysal]

Spoiler

 

[dwstada]

my solution :)

Spoiler

 

[Flo_P]

Spoiler

I liked this one and I like my solution

[sergejs_kutkovics]

It's a REGEX !!

Spoiler

Probably, my regex expression is overcomplicated. )

[Chris-Nienart]

Here are some hints for creating the new tags

1. PARSE the original tag for the tag ending
2. Convert CHARacters to INTegers
3. Determine rows to GENERATE based on range
4. Use some FORMULAs to create a new tag ending

I think it is important to keep the logic simple and easy to follow. If there was a follow up task, like permitting non-consecutive letters (i.e. C123A/B/D), you would need to make small modifications and wouldn't want to come up with an entirely new solution.

Spoiler

[AkimasaKajitani]

My solution for cloud!!

Designer Cloud and Trifacta don't have Generate Row tool. So I use other tool instead.

 

Designer Experience

Spoiler

Text Input tool's data is as follows.



This screenshot is Designer Desktop version.

 

Trifacta Classic 

Spoiler

 

[AYXAcademy]

Hi @Watermark , the problem lies with the Null values generated after your Text to Columns tool. If you add a Data Cleansing tool and adjust your formula a little, you can get rid of this error.  😉

I'm attaching the workflow if you want to take a look.

[phottovy]

I've always wondered how to create the alphabet using the generate rows tool and now I know thanks to this post: 

Generate Rows: increment letters like numbers 

My solution:

Spoiler

[Watermark]

Yep yep yep, the second I read your reply mention nulls I went and tweaked it. Then looked at your flow to see how you handled it, and they were identical. Thanks for the shout!