Read a file line by line in shell script

How to read a file line by line in shell script ?


There are many ways to handle file operations in UNIX. here is the one way of paring the input file line by line in shell script. If you know the basic shell scripting then it will be easy to understand.


filename=$1
cat $filename | while read line 
do 
echo “$line” 
done 



Comments

Post a Comment

HTML/JAVASCRIPT

Popular posts from this blog

Teradata SQL Assistant Shortcuts

Teradata SQL Assistant Shortcuts ctrl + T This will clear all the queries in the Teradata Query Editor ctrl + Q This will format the query in the Teradata Query Editor ctrl + D This is used to comment and uncomment the selected query text in the Teradata Query Editor F11 This will get you the last error message ctrl + C This is used to copy the selected Text in the Teradata Query Editor Ctrl + P This is used to paste the copied content into the Teradata Query Editor Ctrl + F This is used to find a Text in Teradata Query Editor Ctrl + H This is used to Find and Replace the Text in Teradata Query Editor Shift + F10 + I This will get you the current date in the Teradata Query Editor F5 This will execute the Query in the Current Query Tab in the Teradata Query Editor F6 This will get you the execution plan for the query in the Query Editor F9 This is used to execute the Query in Parallel.
Read more

Remove dot in the result from decimal values in Teradata

Remove dot in the result from decimal values in Teradata In Teradata if I export decimal(18,0) values to a file the dot(.) is appended with the values.Example : If the value is 123 in a table then the 123. is stored in a file. to avoid this issue we can useCAST(CAST(SUM(a.amt) AS CHAR(20)) AS DECIMAL(18,0) FORMAT’Z(20)9′ ) as Amthere amt is a decimal(18,0) value.Z, when used with integer types implies a place holder for a digit, which if there are no digits, could be supplemented with a space. 9, on the other hand will supplement a missing digit with 0so if you do ZZ formating for 7, you get 7 99 formating will give 07 and Z9 formating will also give 7 but ZZ formating of 0 gives two space characters where as Z9 formating of 0 will give 0
Read more

Data Mart in Data warehouse

Data Mart in Data warehouse A data mart is a special purpose subset of a company’s enterprise data used by a particular department, function, or application. Often, these single-subject area data marts contain data that was aggregated or transformed in some way to better handle the requests of a specific user community. Vendors implement data marts using different architectures: Independent data marts  – Created directly from operational systems to an individual data store. Dependent data marts  – Created from detail data in the data warehouse. It still requires movement and transformation of data, but may provide better performance for some specific user queries. Logical data marts  – Existing parts of the data warehouse, not separate physical structures. Because in theory the data warehouse contains the detail data of the entire enterprise, a logical data mart would then provide the specific information for a specific user community. With the proper technology...
Read more