The Fix_User_Table code parses both development and last-merge databases, extracts the last time stamp id, and then puts it in the development database. During this process, the fields are not correctly detected. As a result, users with text in the "data" column have all their spaces stripped out after them.
The code on line 242 detects all commas as fields:
awk -f $script_path/helpers/csv.awk -f $script_path/helpers/convert.awk
So data within the data array are considered fields. Functionally this is not a problem since data is all the way at the end of the array and it will not be mistaken with other fields, who ever when recombining these columns, spaces are not preserved. For a quick fix, I modified convert.awk to not trim the result:
num_fields = parse_csv($0, csv, ",", "\"", "\"", "\\n", 0);
and it works fine.
Comments
Comment #1
hefox commentedHave you had issues with your patch since doing it?
Patch for others to test would be grand; if you get to making a patch it please upload and mark this as needs review.
Comment #2
xenophyle commentedmcpuddin,
Could you give an example of data in the 'data' column that has a problem with the trimming? I would like to test your fix.