regex - Trim extra pipes off end of text file in Windows -


so have process outputs text file pipe delimited, looks this:

|abc123|1*|004|**gobbligook|001|%|2014-01-01|||||||||||||

this example, , i'm not sure if answer involves regular expressions. if put actual line. anyways

issue

so example import process accepts file looking 8 pipes, there 20, if sees more pipes after 8 it's looking import process fails.

question

is there process can use in windows environment trim trailing pipes off end of entire file?

update

magoo supplied me great answer working keep getting error: delimiter unexpected @ time

here code:

@echo off setlocal set "sourcedir=c:\users\desktop\pipe delimiter project" set "destdir=c:\users\desktop\pipe delimiter project" (  /f "tokens=1-7delims=|" %%a in ('type "%sourcedir%\test.txt"') (  echo(^|%%a^|%%b^|%%c^|%%d^|%%e^|%%f^|%%g^|  ) )>%destdir%\newfile.txt

anyone know what's wrong? put in line question |abc123|..| pasted in file 6 times...thanks!

@echo off setlocal enabledelayedexpansion set "sourcedir=." set "destdir=u:\destdir" (  /f "delims=" %%a in ('type "%sourcedir%\q22863616.txt"') (  set "line=%%a"  echo(!line:~0,-12!  ) )>%destdir%\newfile.txt  goto :eof

i used file named q22863616.txt containing data testing. produces newfile.txt

assuming final 12 fields empty, lack of information otherwise.

another form, given additional information

@echo off setlocal set "sourcedir=." set "destdir=u:\destdir" (  /f "tokens=1-7delims=|" %%a in ('type "%sourcedir%\q22863616.txt"') (  echo(^|%%a^|%%b^|%%c^|%%d^|%%e^|%%f^|%%g^|  ) )>%destdir%\newfile.txt

ok - third time's charm.

@echo off setlocal enabledelayedexpansion set "sourcedir=." set "destdir=u:\destdir" :: remove variables starting $  /f "delims==" %%a in ('set $ 2^>nul') set "%%a=" (  /f "delims=" %%a in ('type "%sourcedir%\q22863616.txt"') (  set "$0=%%a"  set "$1=%%a"  /l %%c in (1,1,8) set "$1=!$1:*|=!"  set "$2=%%a"  set "$3="  set /a tot=0  /f "delims=:" %%e in ('set $^|findstr /o /r "$"') set /a tot=%%e - !tot! - 5  call :show !tot!  call echo %%$2:~0,-!tot!%%  ) )>%destdir%\newfile.txt  goto :eof  :show call set "$3=%%$2:~0,-%1%%" /f "tokens=1*delims==" %%y in ('set $3') echo(%%z goto :eof

this seems immune % in data, chokes on ! or &. pays money, takes choice...


Comments

Post a Comment

Popular posts from this blog

apache - Remove .php and add trailing slash in url using htaccess not loading css -

i have add following code htaccess file removing .php extension , add trailing slash urls. worked fine reduced page loading speed , css code not loading @ all. pages ugly. please help rewriteengine on rewritebase / ## hide .php extension snippet # externally redirect /dir/foo.php /dir/foo rewritecond %{the_request} ^[a-z]{3,}\s([^.]+)\.php [nc] rewriterule ^ %1/ [r,l] # add trailing slash rewritecond %{request_filename} !-f rewritecond %{request_uri} !/$ rewriterule . %{request_uri}/ [l,r=301] # internally forward /dir/foo /dir/foo.php rewritecond %{request_filename} !-d rewritecond %{request_filename}.php -f rewriterule ^(.*?)/?$ $1.php [l] we can rewrite urls using .htaccess files. before writing in .htaccess files need verify kind of server using. can check server adding a <?php phpinfo(); ?> in php page. ensure mod_rewrite module enabled in apache server. can identified checking phpinfo included page. common methods used url rewriting follows ...
Read more

inno setup - TLabel or TNewStaticText - change .Font.Style on Focus like Cursor changes with .Cursor -

is possible change .font.style on focus tlabel or tnewstatictext happens cursor when use .cursor ? there no built-in support track mouse hovering in inno setup @ time. however, intercepting window procedure of controls can track yourself. following example need innocallback library: [setup] appname=my program appversion=1.5 defaultdirname={pf}\my program outputdir=userdocs:inno setup examples output [files] source: "innocallback.dll"; destdir: "{tmp}"; flags: dontcopy [code] #ifdef unicode #define aw "w" #else #define aw "a" #endif const gwl_wndproc = -4; wm_mousemove = $0200; type wparam = uint_ptr; lparam = longint; lresult = longint; twindowproc = function(hwnd: hwnd; umsg: uint; wparam: wparam; lparam: lparam): lresult; function setcapture(hwnd: hwnd): hwnd; external 'setcapture@user32.dll stdcall'; function releasecapture: bool; external 'releasecapture@user32.dll stdcall'; func...
Read more