Convert phone number in specified format for ceridian integration

(0) Share

Report

Posted on by Parag Chapre

12,254 Most Valuable Professional

Hello,

I have a ceridian integration configured for my customer and I am planning to convert the phone number from worker entity specified format through transformation.

Below is my entity configuration

I want to write the transformation logic here.

I need to create an XSLT file. How can I get all content in XSLT from the worker entity and Do I need to convert the phone number using c# code.

The source phone number format is: 1234567890

The destination phone number format is: 123-456-7890

Can you please guide me how can I achieve this?

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Martin Dráb 237,967 Most Valuable Professional on at

Like (0)

Report
It can be done in XSLT. For example, you can use substring() to split the string by numeric indexes. I would try something like this:

- -

Unfortunately I don't understand what you mean by "How can I get all content in XSLT from the worker entity?".

Note that I would rather create a computed column.

Was this reply helpful? Yes No