Shell Programming and Scripting

My guess is that file2 has some spaces at the end or is in DOS format.

try dos2unix file2.csv or sed -i 's/[[:space:]]*$//' file2.csv

@Chubler_XL, I tried dos2unix file2.csv and sed -i 's/[[:space:]]*$//' file2.csv but still receiving the same output..

---------- Post updated at 09:46 AM ---------- Previous update was at 09:22 AM ----------

@Chubler_XL, my apologies!!! you were totally right!! the code worked once I changed the file format

thanks!!

---------- Post updated at 12:08 PM ---------- Previous update was at 09:46 AM ----------

@ Chubler_XL, hey guys, just noticed a small issue with the headers with the code..

Code:

ID,ParentID,Number,Area,Volume,Dimensions
TTTG000000tXZWYIA4,2014-01-01,ABC,247,83430.33,857.84,8110.76
PPPG000000tXZWXIA4,2014-01-01,DEF,295,2904.60,139.33,102.95
,2014-02-01,ABC,146,11392.70,5017.07,800.96
UUUG000000tXZWbIAO,2014-01-01,XYZ,465,589.76,2.55,1145.33

looks like it has just replaced the "Date" with "ID" which leaves the last column header blank..

Make the row 1 assignment

Code:

$1="ID" FS $1

(as Franklin52 proposed).