Hi Team,
Hope you are well.
I need help.
I need to create a new column based on three exiting column. The first step is to format the date column and then concatenate.
Please let me know,
Thanks,
Sri
Solved! Go to Solution.
Hi @sriniprad08
Step 1: Input
Step 2:
Step 3:
left(RIGHT([Year], 7),2)
Step 4:
[COM]+"."+[Year]+"."+[CNO]
[COM]+"-"+[Year]+"."+[CNO]
Many thanks
Shanker V
@sriniprad08 this one uses RegEx to get the Year out. No need for the intermediate step either.
This also assumes your date field structure is consistent in your full data set. I am guessing it would be seeing as it included the lead zeros on month, day and the time element. 😊
Hi @DanielG ,
Great thanks. As per the requirement i need to have two separate column as output one with "." and other with "-". But currently your solution have both in same column. how can i modify that?
@sriniprad08 Just copy the formula for the 1 column into another and swap out the punctuation to give you both output fields
Hi @sriniprad08
Sorry, couldn't save the workflow as error is prompted.
Could you please replicate my workflow as I have shared all the steps.
Many thanks
Shanker V