다음을 통해 공유

Expressions

  • 아티클

Introduction

This article lists some useful expressions for Strings, Datetime, finding specific days and more.

Do comment if you want to add/require any additional expressions or if you have any blogs on same topic. I will add them in this article.
Also I will keep on adding more expressions in this article in future.

Handling Strings

 

Scenario and Expression

1

Expression to Get the first name from Full Name

FullName: Vaibhav Chaudhari
Output: Vaibhav

@split(pipeline().parameters.FullName, ' ') [0]

2

Expression to Get the last name from Full Name

FullName: Vaibhav Chaudhari
Output: Chaudhari

@split(pipeline().parameters.FullName, ' ') [1]

3

Expression to Get the string between second and third slash

FolderPath: Sales/Products/2019/12/10
Output: 2019

@split(pipeline().parameters.FolderPath, '/') [2]

4


Expression to Remove Spaces from a String

Title: The First King
Output: TheFirstKing

@replace(pipeline().parameters.Title, ' ', '')

5


Expression to Pass Pipeline details in WHERE clause of a SQL Query

SELECT PipelineName, Column1, Column2
FROM MyTable
WHERE PipelineName = '@{pipeline().Pipeline}'

6


Expression to Append current timestamp to file name

FilePath: Sales/Products/2019/12/10/product.txt
Output:  Sales/Products/2019/12/10/product_2019-12-16.txt

@concat(replace(pipeline().parameters.FilePath, '.txt', ''), 
'_', formatDateTime(utcnow(), 'yyyy-MM-dd'), '.txt')
 7
Expression to remove file extension from a file name

FilePath: product_2019-12-16.txt
Output:  product_2019-12-16.
@substring(pipeline().parameters.FileName, 0, 
lastindexof(pipeline().parameters.FileName, '.'))

 

Scenario & Expression

1


Expression to Find first Day of current Month:

@startOfMonth(utcnow(), 'yyyy-MM-dd')

2


Expression to Find last day of Current Month:

@adddays(startOfMonth(addToTime(utcnow(), 1, 'Month')), - 1, 
'yyyy-MM-dd')

3

Expression to Find first Day of Next Month

@startOfMonth(addToTime(utcnow(), 1, 'Month'), 'yyyy-MM-dd')

4


Expression to Find last day of Next Month

@adddays(addToTime(startOfMonth(utcnow()), 2, 'Month'), - 1, 
'yyyy-MM-dd')

5

Expression to Find first Day of Previous Month

@startOfMonth(addToTime(utcnow(), - 1, 'Month'), 'yyyy-MM-dd')

6

Expression to Find last day of Previous Month:

@adddays(startOfMonth(utcnow()), - 1, 'yyyy-MM-dd')

I hope it works .....