thomaslorentsen/README.md

## README.md

      
    Raw
  

              README.md
            
          
    Example Usage

cat data.csv | sed s/","/" "/g | xargs -L 1 | split.sh


## data.csv

          
            id
            date

            
              60666
              13/01/2022

## split.sh
#!/bin/bash
if [ "$1" == "id" ]; then
        # skip line heading
        exit
fi
# Split the date string
IFS=/ read day month year <<< $2
# Format into sql date
NEWDATE=$year-$month-$day
	#!/bin/bash
	if [ "$1" == "id" ]; then
	# skip line heading
	exit
	fi
	# Split the date string
	IFS=/ read day month year <<< $2
	# Format into sql date
	NEWDATE=$year-$month-$day