question

AshokKumarBollineni-5476 avatar image
0 Votes"
AshokKumarBollineni-5476 asked KranthiPakala-MSFT commented

How to convert The Amt into words in azure data factory using azure function?

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

azure-data-factoryazure-functions
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

KranthiPakala-MSFT avatar image
0 Votes"
KranthiPakala-MSFT answered KranthiPakala-MSFT commented

Hi @AshokKumarBollineni-5476,

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:

  1. Create a function in Azure with Python using Visual Studio Code

  2. Create a C# function in Azure using Visual Studio Code

  3. 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.


· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @AshokKumarBollineni-5476,

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

0 Votes 0 ·

Hi @AshokKumarBollineni-5476,

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

0 Votes 0 ·
NandanHegde-7720 avatar image
1 Vote"
NandanHegde-7720 answered NandanHegde-7720 edited

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.