TCS CPA Unix Solution | Xplore UNIX CPA Solution | Calculate Total Asset Price | 27 March

Unix CPA 27 March Calculate Total Asset Price

Asset details belonging to each department are stored in a file in the following format, Each field is comma (,)separated.

AssetName,AssetType,Department, AssetPrice

Write the UNIX command to find the total price of assets belonging to Finance department.

The output should be displayed in below format,

Total Asset Price = <"total price calculated">

In case there are no assets found belonging to Finance department, the displayed output should be "No Asset Found" excluding the quotes.

Refer to the examples below for more clarity on input and output format.

The file name input will be provided as command line argument when the script containing your command will run. You can use shell variables (e.g. $0,$1,$2) whichever is applicable for your requirement to provide the command line argument .

Note : the search for department should be case insensitive

Example 1:
Input:

AssetName,AssetType,Department,AssetPrice
lap1,laptop,finance,50000
desk1,desktop,Finance,40000
lap2,laptop,IT,70000
desk2,desktop,IT,80000
prn1,printer,Finance,10000
prn2,printer,HR,20000

Output:

Total Asset Price = 100000

Example 2:
Input:

AssetName,AssetType,Department,AssetPrice
lap1,laptop,admin,50000
des1,desktop,admin,40000
lap2,laptop,IT,70000
des2,desktop,IT,80000
prn1,printer,helpdesk, 10000
prn2,printer,HR,20000

Output:

No Asset Found

For Solution : Detailed Solution, Click Here

Python EveryDay!!!