sergiandreplace

drop table if exists medicines_import;

CREATE TABLE medicines_import (
	country text NOT NULL,
	code text NOT NULL,
	name text NOT NULL,
	quantity int4 NOT NULL,
	unit text NOT NULL,
	CONSTRAINT medicines_pkey PRIMARY KEY (code, country)
);

sergiandreplace

xsv join --no-case PRODUCTNDC product.txt PRODUCTNDC package.txt -d '\t' \
  |xsv  select NDCPACKAGECODE,PROPRIETARYNAME,PACKAGEDESCRIPTION,DOSAGEFORMNAME \
  |xsv sample 10 \
  |xsv table

sergiandreplace

import org.junit.Test
import java.time.*
import java.time.format.DateTimeFormatter
import java.time.format.FormatStyle
import java.time.temporal.ChronoField
import java.time.temporal.ChronoUnit
import java.time.temporal.TemporalAdjusters
import java.util.*
import kotlin.time.days
import kotlin.time.minutes

sergiandreplace

private val accentRegex = Regex("\\p{InCombiningDiacriticalMarks}+")
Normalizer.normalize("camión", Normalizer.Form.NFD)
  .replace(accentRegex, "")
  .toLowerCase(Locale.getDefault())
  .split(" ")