nilshah98
commented
3 years ago Created this small SED script to resolve this issue -
sed -i 's/\(,\)\([1-9]\/\)/\10\2/g' domains.csv
Further explanation for this script can be found at - sed_regex.md
Open nilshah98 opened 3 years ago
nilshah98
commented
3 years ago Created this small SED script to resolve this issue -
sed -i 's/\(,\)\([1-9]\/\)/\10\2/g' domains.csv
Further explanation for this script can be found at - sed_regex.md
When exporting data to csv dates are inconsistent, which leads to inappropriate date detection in Excel. Example - A few dates are listed as -
07/04/2021. But some are listed as -7/14/2021.This causes issues in Excel interpreting the data,