Hi All,
I want to convert amount to words in Azure Data Factory.
E.g.
Rs. 287.06 -> TWO HUNDRED EIGHTY-SEVEN AND 06/100 RUPEES
Requesting you to suggest how can we achieve in Azure data factory.
Regards,
Ashok
Hi All,
I want to convert amount to words in Azure Data Factory.
E.g.
Rs. 287.06 -> TWO HUNDRED EIGHTY-SEVEN AND 06/100 RUPEES
Requesting you to suggest how can we achieve in Azure data factory.
Regards,
Ashok
Welcome to Microsoft Q&A forum and thanks for your query.
We do not have out of box feature/function for this conversion from amount number to word. You will have to write your own transformation logic and use that in Function activity or Custom activity of your ADF pipeline to achieve your requirement.
Please refer to below sources on how to use function activity in ADF pipeline:
Video: Run Azure Functions from Azure Data Factory pipelines
Blog by community expert (Disclaimer: Not MSFT owned) : https://www.mssqltips.com/sqlservertip/6208/integrate-azure-function-into-azure-data-factory-pipeline/
Please refer to below few docs which can help to write Azure function:
Create a function in Azure with Python using Visual Studio Code
Create a PowerShell function in Azure using Visual Studio Code
Also please refer to this sample program to convert a given number to words (Source: From public blog - Not MSFT owned) : Program to convert a given number to words
Hope this information helps.
Thank you
Please do consider to click on "Accept Answer" and "Upvote" on the post that helps you, as it can be beneficial to other community members.
Just checking in to see if the above suggestion was helpful. If this answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.
Thank you
We still have not heard back from you. Just wanted to check if the above information from me or @NandanHegde-7720 was helpful? If so, please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members. If you have further query, do let us know.
Thank you
Hey @AshokKumarBollineni-5476 ,
As suggested by @KranthiPakala-MSFT , you can use Azure functions(Python) in integration with ADF to achieve this.
There is an inflect package in python that can help you achieve this.
number_to_words is the function
or you can write your own functions to achieve this
9 people are following this question.