CODEWITHSUNDEEP
azure-data-factory
user2841795
user2841795

Reputation: 405

Extract table name from more than one schema length in Data Factory Expression

I need to extract table name from schema.table_name, I have more than one schema where length is unknown. e.g. Finance.Reporting or Setup.System. I want to extract Reporting and System from these string using Expression in Data Factory.

Upvotes: 1

Views: 154

Answers (1)

NiharikaMoola
NiharikaMoola

Reputation: 5074

You can use the split() function to split the string based on delimiter which returns the array and get the second value from the string.

Note: Array index starts from 0.

@split('Finance.Reporting','.')[1]

enter image description here

Upvotes: 2

Related Questions