How to change a string delimiter in Ab Initio? -

-

in ab initio graph have input file has pipe-delimited values in rows. use similar dml file parse it:

record   decimal("|",0, maximum_length=19, sign_reserved) v1 = null("");   utf8 string("|", maximum_length=10) v2 = "";   utf8 string("|", maximum_length=10) v3 = "";   utf8 string("|", maximum_length=40) v4 = "";   utf8 string("|", maximum_length=255) v5 = "";   utf8 string("\n", maximum_length=40) v6 = ""; end

for use in later equality comparisons other data want make strings pipe-delimited, need change v6 value.

i tried simple reformat changing output dml one, , leaving transform function empty:

record   decimal("|",0, maximum_length=19, sign_reserved) v1 = null("");    utf8 string("|", maximum_length=10) v2 = "";   utf8 string("|", maximum_length=10) v3 = "";   utf8 string("|", maximum_length=40) v4 = "";   utf8 string("|", maximum_length=255) v5 = "";   utf8 string("|", maximum_length=40) v6 = "";   string(1) newline = "\n"; end

however, left trash character inside v6. later needed filter v6 value make contain proper characters. solution doesn't seem neat.

to avoid trash left inside v6 tried use reinterpret_as, string_concat , others nothing ended nice solution. how should change delimiter of v6 in simple way?

a == b compares value of value of b. comparison returns same result regardless of whether , b have same delimiter or not. if need change delimiter of field, reformat method suggest correct one. if you're seeing garbage in v6 values coming out, means there garbage in v6 going in.

more broadly speaking, stack overflow isn't right venue discussing things ab initio. you'd better off posing question ab initio support or on dedicated ab initio forum accessible through gde. forum monitored numerous ab initio users , employees, , you're pretty guaranteed prompt response.


Comments

Post a Comment

Popular posts from this blog

how to insert data php javascript mysql with multiple array session 2 -

-
i have method method discussed , successful data entered 1 when more 1 can not database this programs my php form : <form class="form-horizontal" id="form-produk"> <div class="control-group" > <label class="control-label" for="kelas">kategori</label> <div class="controls"> <select class='form-control' name='id_kategori'> <?php $tampil=mysql_query("select * kategori order nama_kategori"); if ($id_kat==0){ echo "<option value=0 selected>- pilih kategori -</option>"; } while($w=mysql_fetch_array($tampil)){ if ($id_kat==$w[id_kategori]){ echo "<option value=$w[id_kategori] selected>$w[nama_kategori]</option>"; } else{ echo "<option value=$w[id_kategori]>$...
Read more

multithreading - Exception in Application constructor -

-
i wanna write snake game javafx , there exception don't know , want know how fix it. ( know it's not complete yet ) and want know , class extends application ( start override ) main in other programs? see , here not static void main bc didn't need, if want add main shoud do? it's exeption... exception in application constructor exception in thread "main" java.lang.nosuchmethodexception: main_snake.main([ljava.lang.string;) @ java.lang.class.getmethod(class.java:1819) @ com.intellij.rt.execution.application.appmain.main(appmain.java:125) and code : import javafx.animation.animationtimer; import javafx.application.application; import javafx.event.eventhandler; import javafx.scene.scene; import javafx.scene.canvas.canvas; import javafx.scene.canvas.graphicscontext; import javafx.scene.input.keyevent; import javafx.scene.layout.borderpane; import javafx.scene.paint.color; import javafx.stage.stage; import java.util.arraylist; /** * creat...
Read more

windows - CertCreateCertificateContext returns CRYPT_E_ASN1_BADTAG / 8009310b -

-
i realize similar post others (e.g. this one ), there details missing posts might significant case. to start with, here's simplified program: #include "stdafx.h" #include <windows.h> #include <wincrypt.h> int _tmain(int argc, _tchar* argv[]) { // usage: certextract certpath char keyfile[] = "c:\\certificates\\public.crt"; byte lp[65536]; security_attributes sa; handle hkeyfile; dword bytes; pccert_context certcontext; sa.nlength = sizeof(sa); sa.lpsecuritydescriptor = null; sa.binherithandle = false; hkeyfile = createfile(keyfile, generic_read, file_share_read, &sa, open_existing, file_attribute_normal, null); if (hkeyfile) { if (readfile(hkeyfile, lp, getfilesize(hkeyfile, null), &bytes, null) && bytes > 0) { certcontext = certcreatecertificatecontext(x509_asn_encoding, lp, bytes); if (certcontext) { printf("yay...
Read more