Check-in Date (eVar42) Classification by Classification Importer | Community
Skip to main content
S
SrikrishnaChaitanya
Level 2
November 29, 2023
Question

Check-in Date (eVar42) Classification by Classification Importer

  • November 29, 2023
  • 1 reply
  • 1241 views

Check-in Date (eVar42) - This Evar contains values like - "Fri Nov 18 2023"

I would like to have classifications built for this in the following formats

Fiscal Week (Monday – Sunday)

  • Date:                                   MM/DD/YYYY (11/18/2023)
  • Week Number:                 YYYY:FW##  (ex. 2023:FW49)
  • Month:                               YYYY:FM## (ex. 2023:FM11) - Nov
  • Quarter:                             YYYY:FQ## (ex. 2023:FQ04) - Q4
  • Year:                                    YYYY (ex. 2023)

Standard Week (Sunday – Saturday, Regular Month Calendar 1st-31st)

  • Date:                                   MM/DD/YYYY (11/18/2023)
  • Week Number:                 YYYY:SW##  (ex. 2023:SW49)
  • Month:                               YYYY:SM## (ex. 2023:SM01)
  • Quarter:                             YYYY:SQ## (ex. 2023:SQ04)
  • Year:                                    YYYY (ex. 2023)

I want this evar to classify by Date, Month, week, Week number, Year, Quarter. using Classification importer.

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

RobertBlakeley
Community Advisor
RobertBlakeleyCommunity Advisor
Community Advisor
November 29, 2023

This can be done with either the importer or the builder. In either case, someone is going to need to write a lot of parse and transform code (in regex or some other). 

It might make it a bit easier if you can modify the value passed to the evar initially to use week day and month numbers instead of alpha.

So what's the point of all these classifications?

    Jennifer_Dungan
    Community Advisor and Adobe Champion
    Jennifer_DunganCommunity Advisor and Adobe Champion
    Community Advisor and Adobe Champion
    November 29, 2023

    I agree with everything @robertblakeley said... Classification or Builder could have some issues...

     

    Particularly where you need to figure out the week of the year, there's a lot of logic that would have to be built into this with Regex... the alternative is to provide a 1 to 1 mapping for every possible date (Classification importer) which doesn't seem terribly efficient or scale-able...

     

    Also, parsing "text" values, rather than numerical is going to be more challenging...  

     

    Passing the dates in a standard ISO format would be more reliable for creating rules around them.... 

     

    You may want to consider parsing some of this info in Launch, where you have access to JavaScript and being able to use actual date logic... maybe a mix of that and classifications? 

    S
    SrikrishnaChaitanyaAuthor
    Level 2
    December 1, 2023

    Hi

    Here we are capturing the Check in Date - this is basically the booking website for Hotels. So , Does there is a way to classify using the Classification importer. Please Help

    Terms & ConditionsAccessibility statement

    Loading footer...