Excel Web Query Results have Cell with LF/CR that creates new row for each value -

-

i have iqy file i'm using consume web query. however, 1 of returned columns has values have embedded cr/lf in it, results in field creating multiple rows of cells.

what settings in iqy file, or in excel can use in order entire string remain in 1 cell.

(note: in html page view of file, entire string between on table cell)

<td> line1.... line2.... line3.... </td>

view of excel section


Comments

Post a Comment

Popular posts from this blog

ZeroMQ on Windows, with Qt Creator -

-
i have installed zmq link given below on windows 7. http://zeromq.org/distro:microsoft-windows 1) have c++ project in qt-creator , i'm using zmq c++ binding (zhelpers.hpp etc). 2) have added .lib installed zmq folder qtcreator 3) while compiling, compiler looks _imp__zmq_verion, in .dll files present in .lib have __imp_zmq_version. 4) causing undefined reference zmq_version. anyone else faced problem , has solution ?
Read more

.net - Generate assembly with Roslyn -

-
Image
is possible build .net core or better .net standard library roslyn can referenced project? my goal build assembly on server , have people download can reference , use in own visual studio projects. i'm using roslyn generate c# code , compile it. seems work ok when "emit" compilation result memory stream, load assembly , execute code using reflection. using (var ms = new memorystream()) { var compilationresult = compilation.emit(ms); if (compilationresult.success) { ms.position = 0; var assembly = assemblyloadcontext.default.loadfromstream(ms); .. .. is can "save" assembly proving path emit method. results in .dll file on disk. var compilationresult2 = compilation.emit(@"d:\testassembly.dll"); i wonder kind of format .dll file is. doesn't seem "normal" assembly. i searched internet couldn't find doing this. misunderstand something? so questions are: what kind of format file create emit? full...
Read more

batch file - filebot superstrict script: need tiny video sample or other solution -

-
seeing how filebot can make massive mistakes (even in strict mode) when renaming videos created script make sure there's no mistakes , lets me check suspicious ones manually. it uses dummy 0-size copy of video in dedicated folder figure out new name renamed , doesn't tagged video , audio info since it's not real video. it simpler , more accurate have variable tags in place need tiny part of video (with tracks) instead of 0-size dummy. what's easy way this? all unknown variables see extrapolated video filename in other script, should not relevant here ask away if need be. @echo off /f "tokens=*" %%f in ("%full%") ( set "fullpath=%%~dpf" set "file=%%~nxf" ) :: prep fake temp file set tempdir=%temp%\%date:~3,2%%date:~6,2%%date:~11,2%%time:~1,1%%time:~3,2%%time:~6,2% mkdir "%tempdir%" && copy /y nul "%tempdir%\%file%" >nul :: filebot string (to shorten lines) if "%type%"...
Read more