Batch script How to add space on a numerical variable -

-

first of approaches, excuse me if not express myself in english.

i'm debutante in batch , need make script

i articles.txt retrieves document in there many lines. lines of document

"t0047" ;"tuyau 1km";"marque2";"jardinage";"75 000";"promo" "t00747";"tuyau 1m";marque2";"jardinage";"30 000";"promo"

first, have remove quotation marks in file. done with:

@echo off setlocal enabledelayedexpansion /f "delims=" %%a in (articles.txt) (         set a=%%a         set a=!a:"=!         echo !a!     echo !a! >>resultat.txt )

the result

t0047 ;tuyau 1km;marque2;jardinage;75 000;promo t00747;tuyau 1m;marque2;jardinage;30 000;promo

then have perform multiplication on column. this, have problem if space not mutiplication realize made script removes spaces.

@echo off setlocal enabledelayedexpansion /f "delims=; tokens=1-8" %%a in (resultat.txt) (         set a=%%e     set a=!a: =!         echo %%a;%%b;%%c;%%d;!a!;%%f;%%g;%%h     echo %%a;%%b;%%c;%%d;!a!;%%f;%%g;%%h >>resultat2.txt )

the result

t0047 ;tuyau 1km;marque2;jardinage;75000;promo t00747;tuyau 1m;marque2;jardinage;30000;promo

then made multiplication.

@echo off setlocal enabledelayedexpansion /f "delims=; tokens=1-8" %%a in (resultat2.txt) (         set a=%%e         :: set /a a=!a!/0.6          set /a a=!a!*16666/10000     echo %%a;%%b;%%c;%%d;!a!;%%f;%%g;%%h     echo  %%a;%%b;%%c;%%d;!a!;%%f;%%g;%%h >>resultat3.txt )

the result 

t0047 ;tuyau 1km;marque2;jardinage;124995;promo t00747;tuyau 1m;marque2;jardinage;49998;promo

now, add text after first colomn

set champ2=magasin_1;t /f "delims=; tokens=1,*" %%a in (resultat3.txt) (         echo %%a;%champ2%;%%b         echo %%a;%champ2%;%%b >>resultat_final.txt )

the actual result is:

t0047 ;magasin_1;t;tuyau 1km;marque2;jardinage;124995;promo t00747;magasin_1;t;tuyau 1m;marque2;jardinage;49998;promo

now add space figure more readable.

t0047 ;magasin_1;t;tuyau 1km;marque2;jardinage;124 995;promo t00747;magasin_1;t;tuyau 1m;marque2;jardinage;49 998;promo

this way it:

@echo off setlocal enabledelayedexpansion  /f "delims=" %%a in (articles.txt) (    set "a=%%a"    set a=!a:"=!    /f "delims=; tokens=1-8" %%a in ("!a!") (       set /a "g1=%%g*16666/10000"       set "g2="       /l %%i in (1,1,3) if defined g1 (          set "g2= !g1:~-3!!g2!"          set "g1=!g1:~0,-3!       )       echo %%a;%%b;%%c;%%d;%%e;%%f;!g2:~1!;%%h       echo %%a;%%b;%%c;%%d;%%e;%%f;!g2:~1!;%%h >> result.txt    ) )

articles.txt:

"t0047" ;"magasin_1";"t";"tuyau 1km";"marque2";"jardinage";"75000";"promo" "t00747";"magasin_1";"t";"tuyau 1m";marque2";"jardinage";"30000";"promo"

result.txt:

t0047 ;magasin_1;t;tuyau 1km;marque2;jardinage;124 995;promo  t00747;magasin_1;t;tuyau 1m;marque2;jardinage;49 998;promo

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