Today, i will discuss about the “How to remove extra delimiters in a file” using shell script. Below is the content of the file. a|b||c d||e|||f Post execution of shell script, the output will be a|b|c d|e|f Below is the script which is created to remove extra delimiter in a file. #file is assigned to variable INPUT . Here we used two files text1.txt and text2.txt to manipulate the source file data. INPUT=”Path of the file”/file.txt #Truncating text1.txt. Make sure this file exists. >text1.txt #Reading character by character using while…
Month: March 2019
CASE Statement in Pentaho
Today, I will discuss about how to create ETL(Pentaho) Equivalent of case statement in Database. In Pentaho, we have component “Number Range”. See the ETL Design for the same. In this, I have considered csv file input ,Number Range,Write to log components. In CSV file input, FEB-SAL.csv file which we have considered. See the below SS for the same. See the below SS for the Number Range Component. Number Range works on x1 less than equal to(<=) x greater than(<) x2 logic. Here, if you see, 1000 to 5000 ,…