File over SFTP shows additonal chars at the beginning












2















I've a function in symfony 3.4 which throws chars that do not exist in file:



use Exception;

use phpseclibNetSFTP;

use SymfonyComponentDependencyInjectionContainerInterface;

use SymfonyComponentVarDumperVarDumper;



public static function getInfoFile(string $fileName, ContainerInterface $container)

{

    $host = $container->getParameter('host');

    $sftp = new SFTP($host);

    if (!$sftp->login($container->getParameter('user'), $container->getParameter('pass'))) {

        throw new Exception('Cannot connect to ' . $host);

    }

    $file = $sftp->get("/info/$fileName");



    vardumper::dump($file); // See Response below



    $file = preg_split('/R/', $file);

    reset($file);



    // vardumper::dump($file); // This would now return each array element prepended with b"""



    return $file;

}


This returns:




Service.php on line 30: b""" A;B;C;D;E;Frn 1;2;3;4;5;6rn




This b""" is nowhere in the file. I've tried to open with Notepad++ and Excel and this cannot be seen.



When I try to use substr with this, then b""" stays and real file is cut.



What am i doing wrong?
I would like to read the csv file for each line into an array without these cryptic b"""






php symfony csv sftp phpseclib







share|improve this question





























    2















    I've a function in symfony 3.4 which throws chars that do not exist in file:



    use Exception;
    
use phpseclibNetSFTP;
    
use SymfonyComponentDependencyInjectionContainerInterface;
    
use SymfonyComponentVarDumperVarDumper;
    

    
public static function getInfoFile(string $fileName, ContainerInterface $container)
    
{
    
    $host = $container->getParameter('host');
    
    $sftp = new SFTP($host);
    
    if (!$sftp->login($container->getParameter('user'), $container->getParameter('pass'))) {
    
        throw new Exception('Cannot connect to ' . $host);
    
    }
    
    $file = $sftp->get("/info/$fileName");
    

    
    vardumper::dump($file); // See Response below
    

    
    $file = preg_split('/R/', $file);
    
    reset($file);
    

    
    // vardumper::dump($file); // This would now return each array element prepended with b"""
    

    
    return $file;
    
}


    This returns:




    Service.php on line 30: b""" A;B;C;D;E;Frn 1;2;3;4;5;6rn




    This b""" is nowhere in the file. I've tried to open with Notepad++ and Excel and this cannot be seen.



    When I try to use substr with this, then b""" stays and real file is cut.



    What am i doing wrong?
    I would like to read the csv file for each line into an array without these cryptic b"""






    php symfony csv sftp phpseclib







    share|improve this question



























      2












      2








      2








      I've a function in symfony 3.4 which throws chars that do not exist in file:



      use Exception;
      
use phpseclibNetSFTP;
      
use SymfonyComponentDependencyInjectionContainerInterface;
      
use SymfonyComponentVarDumperVarDumper;
      

      
public static function getInfoFile(string $fileName, ContainerInterface $container)
      
{
      
    $host = $container->getParameter('host');
      
    $sftp = new SFTP($host);
      
    if (!$sftp->login($container->getParameter('user'), $container->getParameter('pass'))) {
      
        throw new Exception('Cannot connect to ' . $host);
      
    }
      
    $file = $sftp->get("/info/$fileName");
      

      
    vardumper::dump($file); // See Response below
      

      
    $file = preg_split('/R/', $file);
      
    reset($file);
      

      
    // vardumper::dump($file); // This would now return each array element prepended with b"""
      

      
    return $file;
      
}


      This returns:




      Service.php on line 30: b""" A;B;C;D;E;Frn 1;2;3;4;5;6rn




      This b""" is nowhere in the file. I've tried to open with Notepad++ and Excel and this cannot be seen.



      When I try to use substr with this, then b""" stays and real file is cut.



      What am i doing wrong?
      I would like to read the csv file for each line into an array without these cryptic b"""






      php symfony csv sftp phpseclib







      share|improve this question
















      I've a function in symfony 3.4 which throws chars that do not exist in file:



      use Exception;
      
use phpseclibNetSFTP;
      
use SymfonyComponentDependencyInjectionContainerInterface;
      
use SymfonyComponentVarDumperVarDumper;
      

      
public static function getInfoFile(string $fileName, ContainerInterface $container)
      
{
      
    $host = $container->getParameter('host');
      
    $sftp = new SFTP($host);
      
    if (!$sftp->login($container->getParameter('user'), $container->getParameter('pass'))) {
      
        throw new Exception('Cannot connect to ' . $host);
      
    }
      
    $file = $sftp->get("/info/$fileName");
      

      
    vardumper::dump($file); // See Response below
      

      
    $file = preg_split('/R/', $file);
      
    reset($file);
      

      
    // vardumper::dump($file); // This would now return each array element prepended with b"""
      

      
    return $file;
      
}


      This returns:




      Service.php on line 30: b""" A;B;C;D;E;Frn 1;2;3;4;5;6rn




      This b""" is nowhere in the file. I've tried to open with Notepad++ and Excel and this cannot be seen.



      When I try to use substr with this, then b""" stays and real file is cut.



      What am i doing wrong?
      I would like to read the csv file for each line into an array without these cryptic b"""






      php symfony csv sftp phpseclib




      php symfony csv sftp phpseclib






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Jan 1 at 18:33









      neubert

      9,1781656130




      9,1781656130










      asked Dec 28 '18 at 12:43









      DasBenDasBen

      516




      516
























          1 Answer
          1






          active

          oldest

          votes


















          2














          I've found the solution....



          $file = $sftp->get("/info/$fileName");
          
$file = mb_convert_encoding($file, "UTF-8", "ISO-8859-15" ); // Add this


          The problem was the encoding.






          share|improve this answer























            Your Answer






            StackExchange.ifUsing("editor", function () {
            StackExchange.using("externalEditor", function () {
            StackExchange.using("snippets", function () {
            StackExchange.snippets.init();
            });
            });
            }, "code-snippets");

            StackExchange.ready(function() {
            var channelOptions = {
            tags: "".split(" "),
            id: "1"
            };
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function() {
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled) {
            StackExchange.using("snippets", function() {
            createEditor();
            });
            }
            else {
            createEditor();
            }
            });

            function createEditor() {
            StackExchange.prepareEditor({
            heartbeatType: 'answer',
            autoActivateHeartbeat: false,
            convertImagesToLinks: true,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: 10,
            bindNavPrevention: true,
            postfix: "",
            imageUploader: {
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            },
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            });


            }
            });














            draft saved

            draft discarded


















            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53958819%2ffile-over-sftp-shows-additonal-chars-at-the-beginning%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown

























            1 Answer
            1






            active

            oldest

            votes








            1 Answer
            1






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes









            2














            I've found the solution....



            $file = $sftp->get("/info/$fileName");
            
$file = mb_convert_encoding($file, "UTF-8", "ISO-8859-15" ); // Add this


            The problem was the encoding.






            share|improve this answer




























              2














              I've found the solution....



              $file = $sftp->get("/info/$fileName");
              
$file = mb_convert_encoding($file, "UTF-8", "ISO-8859-15" ); // Add this


              The problem was the encoding.






              share|improve this answer


























                2












                2








                2







                I've found the solution....



                $file = $sftp->get("/info/$fileName");
                
$file = mb_convert_encoding($file, "UTF-8", "ISO-8859-15" ); // Add this


                The problem was the encoding.






                share|improve this answer













                I've found the solution....



                $file = $sftp->get("/info/$fileName");
                
$file = mb_convert_encoding($file, "UTF-8", "ISO-8859-15" ); // Add this


                The problem was the encoding.







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Dec 28 '18 at 13:11









                DasBenDasBen

                516




                516






























                    draft saved

                    draft discarded




















































                    Thanks for contributing an answer to Stack Overflow!


                    • Please be sure to answer the question. Provide details and share your research!

                    But avoid …



                    • Asking for help, clarification, or responding to other answers.

                    • Making statements based on opinion; back them up with references or personal experience.


                    To learn more, see our tips on writing great answers.




                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function () {
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53958819%2ffile-over-sftp-shows-additonal-chars-at-the-beginning%23new-answer', 'question_page');
                    }
                    );

                    Post as a guest















                    Required, but never shown





















































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown

































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown







                    -

                    Popular posts from this blog

                    Angular Downloading a file using contenturl with Basic Authentication

                    Image
                    0 I have a contentUrl when user clicks on that,file should be downloaded. If I try to browse the contentUrl in the browser it asks for Userid and password.I believe this is Basic Authentication.I dont want user to enter UserId and Password so I am passing it Authorization(Please see below code). Url looks some thing like this: http://XXX.XXX.XX.XXX:8080/flowable-rest/service/runtime/tasks/90875/attachments/90555/content let username : string = 'admin'; let pwd : string = 'test'; let headers = new Headers(); headers.set('Accept', 'text/json'); headers.append('Content-Type', 'application/json'); headers.set('Access-Control-Allow-Origin', '*'); headers.set('Access-Control-Allow-Methods','POST, GET, OPTIONS, PUT, DELETE'); head
                    Read more

                    Olmecas

                    Image
                    Monumento 1, uma das quatro cabeças colossais encontradas em La Venta, com altura aproximada de 3 metros Olmecas é a designação do povo e da civilização que estiveram na origem da antiga cultura pré-colombiana da Mesoamérica e que se desenvolveram nas regiões tropicais do centro-sul do atual México durante o pré-clássico, próximo de onde hoje estão localizados os estados mexicanos de Veracruz e Tabasco, no Istmo de Tehuantepec, numa zona designada área nuclear olmeca. A cultura olmeca floresceu nesta região aproximadamente entre 1500 e 400 a.C., [ 1 ] e crê-se que tenha sido a civilização-mãe de todas as civilizações mesoamericanas que se desenvolveram posteriormente. [ 2 ] No entanto, desconhece-se a sua exacta filiação étnica, ainda que existam numerosas hipóteses colocadas para tentar resolver esta questão. O etnónimo olmeca foi cunhado pelos arqueólogos do século XX, e não devem confundir-se com os muito posteriores olmecas-xicalancas que ocuparam vários locais do México
                    Read more

                    Can't read property showImagePicker of undefined in react native iOS

                    Image
                    1 I have tired with this issue npm install react-native-image-picker@latest --save react-native link react-native-image-picker import ImagePicker from 'react-native-image-picker'; const options = { quality: 1.0, maxWidth: 500, maxHeight: 500, storageOptions: { skipBackup: true } }; ImagePicker.showImagePicker(options, (response) => { console.log('Response = ', response); if (response.didCancel) { console.log('User cancelled image picker'); } else if (response.error) { console.log('ImagePicker Error: ', response.error); } else if (response.customButton) { console.log('User tapped custom button: ', response.customButton); } else {
                    Read more