diff options
| author | Munyoki Kilyungi | 2023-05-23 16:07:11 +0300 |
|---|---|---|
| committer | BonfaceKilz | 2023-05-26 08:40:22 +0300 |
| commit | 7d9964474deaea4e06dcc8a415c0bcbc316c24b4 (patch) | |
| tree | 2215235d96daceb9ec8ca74e132182a91863433e /examples/dump-phenotype.scm | |
| parent | 8076e5c096d709e707927b1bad7090063dc68ce0 (diff) | |
| download | gn-transform-databases-7d9964474deaea4e06dcc8a415c0bcbc316c24b4.tar.gz | |
Return an empty string if a dataset doesn't have a name
Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
Diffstat (limited to 'examples/dump-phenotype.scm')
| -rwxr-xr-x | examples/dump-phenotype.scm | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/examples/dump-phenotype.scm b/examples/dump-phenotype.scm index 08d5127..5f8cd94 100755 --- a/examples/dump-phenotype.scm +++ b/examples/dump-phenotype.scm @@ -91,9 +91,10 @@ (set gn:sequence (annotate-field (field PublishXRef Sequence) '^^xsd:int)) (set gn:phenotypeOfDataset (ontology 'dataset: - (regexp-substitute/global #f "[^A-Za-z0-9:]" - (field PublishFreeze Name) - 'pre "_" 'post))) + (regexp-substitute/global + #f "[^A-Za-z0-9:]" + (field ("IFNULL(PublishFreeze.Name, '')" DatasetName)) + 'pre "_" 'post))) (set gn:phenotypeOfPublication (let ((pmid (field ("IF(Publication.PubMed_ID IS NULL, '', CONVERT(Publication.PubMed_Id, INT))" |