In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Parse String Field

bertal34
9 - Comet

Hi Alteryx Community!

 

I am trying to extract information from a Customer Care "Notes" field.  I have attached sample data of the Input and Desired Output.

The sku number can always be found after #sku and adjustment can always be found after #adj.  These can be upper or lower case so the solution has to be case insensitive.  Also, it will always be indicated if adjustment is $ or %.

 

Any help is GREATLY appreciated!

3 REPLIES 3
Jean-Balteryx
16 - Nebula
16 - Nebula

Hi @bertal34 ,

 

I completed your workflow. Tell me if it helps you !

 

Cheers,

 

Jean-Baptiste

bertal34
9 - Comet

@Jean-Balteryx 

 

Thank you for your help.  Your solution is close however needs to work when there are multiple sku/adj in the same Notes field.  In my example, record number 3 has 2 pairs of sku/adj and therefore needs 2 output records.  Any ideas?

bertal34
9 - Comet

I have found a solution for this.

Labels
Top Solution Authors