Transform the headers to The required Format

Hi,

I want to transform my Headers Input to the Desired Header format.

Basically need to replace the "_" from the headers except for few of them which has the same header name only a no 2 is added after it with "_".

example : Turlock 0621_2. Apart from this types rest all "_" needs to be removed. The sample Data with headers are attached below. Can someone help me out in this.

headers Transform.yxmd

Transformation

Accepted answers

gautiergodard

@DataPirate26 here you go!

headers Transformsolution.yxmd

binu_acs

@DataPirate26 One way of doing this

IIF(EndsWith([_CurrentField_], '_2'),Replace(REGEX_Replace([_CurrentField_], '(.*)(_.*)', '$1'),'_','-')+'_2',Replace([_CurrentField_],'_','-'))

headers Transform.yxmd

All comments

gautiergodard

hello @DataPirate26

See solution attached!

headers Transformsolution.yxmd

DataPirate26

@gautiergodard You missed out one point which I mentioned. That there are few exceptions in which I need the underscores. Example Turlock 0621_2. There are 3 4 cases in which a no 2 is added at the last. In those cases I need to keep the underscores. Can you check the desired headers Sample once.

DataPirate26

@gautiergodard When the Headers are exact same but only at last the No 2 is added in that case i need to keep the underscore before the number 2. Apart from that all underscores to be removed

gautiergodard

@DataPirate26 here you go!

headers Transformsolution.yxmd

DataPirate26

@gautiergodard This worked perfectly fine. Thanx a lot for your quick response.

binu_acs

@DataPirate26 One way of doing this

IIF(EndsWith([_CurrentField_], '_2'),Replace(REGEX_Replace([_CurrentField_], '(.*)(_.*)', '$1'),'_','-')+'_2',Replace([_CurrentField_],'_','-'))

headers Transform.yxmd

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235