community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Dynamic Rename

Meteor

Hi All,

 

Hoping someone can point me in the right direction.

I have a dataset that comes with column headings with a numerical prefix (1. , 2.  3. etc). 

 

What I need to is remove the number, full stop, and the space after the full stop from the field name across all headings.

 

I believe the Dynamic Rename tool would be the best thing to use but I'm unclear on the best way to achieve this, either through Rename Mode: Formula, or Remove Prefix/Suffix.

 

Any help / guidance that can be offered would be greatly appreciated.

 

Cheers

Highlighted
Bolide

Hi

 

Yes that would be the way to go about this. 

 

Firstly, don't be afraid to just try stuff, it's the best way of learning and as long as you are not overwriting any source files then it's a pretty harmless... 

 

You will also find there is normally more than one way to get things done. 

 

Given that the prefix is not uniform you ill need to go down the formula route, using a regex replace with a pattern like this; '^\d{1,2}\.\s'

 

Hope that helps. 

 

Gavin

 

Alteryx Everything, Leave no one behind.
Meteor

Hi,

Thanks for the solution, that worked perfectly. WAsn't familiar with the syntax for regex so your assistance is greatly appreciated.

 

Cheers

Labels