In data prep do we have any function using which we can check length of input string

[Shaini_Gupta]

In data prep do we have any function using which we can check length of input string.And if so which function also how can we ensure only if suppose length of that string is 5 for eg then only it gets ingested to AEP.

[arijitg]

Hi @Shaini_Gupta 

You can use <Field>.length() function to get the length of the string. 

To ensure only 5 length string will be ingested you can choose either of the 2 approaches -->

• Define the length in schema level (also you can set regex pattern there if needed) and enable partial ingestion.
• In data prep you can use if-else logic to only return the string that are of  length 5 and nullify the rest which are not. So in dataset only length 5 values will be populated rest will be stored null.

Regards,

Arijit Ghosh

[NimashaJain]

@Shalini_Gupta Did you find the suggested solutions helpful? It would be great if you can mark the answer as correct for posterity. If you have found out solution yourself, share it with wider audience in the community..

[JasonAm1 · Accepted solution]

@arijitg - I can confirm that <field>.length() will work in Data Prep mapping rules, though it doesn't seem to be documented in the online Data Prep mapping functions documentation (https://experienceleague.adobe.com/docs/experience-platform/data-prep/functions.html?lang=en). 

How did you come to learn about this function?  I wonder if there are other functions that could be useful - can you share any other resources?