How do I hide the PHP explode delimiter from submitted form results

Question

I have created a form which utilizes a  txt file to pull the names of the EMPLOYEES from and breaks them up in the SELECT form option using the PHP explode function    lt select name  FakeName  id  Fake-ID  aria-required  true  required gt    lt option value    gt  lt  option gt     lt  php     options nl2br file get contents  employees txt         options explode   lt br   gt    options       for  i 0  i lt count  options   i             echo   lt option value     options  i     gt    options  i    lt  option gt            gt   lt  select gt    The  txt file appears as such   Name 1 Name 2 Name 3 ETC   Now this works in the form on the site and properly breaks it up and all looks fine  However  when the results are submitted into a SPREADSHEET  in this case a GOOGLE SPREADSHEET  the output includes the  break  and thus it goes into the spreadsheet in a format similar to   Row 1  Name 1 Row 2         Name 2 Row 3         Name 3 Row 4         ETC   I am trying to figure out how to change the code or something so that the delimiter itself does not submit as part of the results  NOTE  Using any delimiter submits  I have tried     or     and it submits with results

User · Answer

lt select name  FakeName  id  Fake-ID  aria-required  true  required gt    lt  php  options nl2br file get contents  employees txt      options explode   lt br   gt    options    foreach   options as  item array    echo   lt option value     item array   gt    item array  lt  option gt         gt   lt  select gt

User · Answer

You could try a different approach like read the file line by line instead of dealing with all this nl2br   explode stuff    fh   fopen  employees txt    r    if   fh        while    line   fgets  fh       false             line   trim  line           echo   lt option value     line    gt    line   lt  option gt            else          error opening the file  do something     Also maybe just doing a trim  remove whitespace from beginning end of string  is your issue   And maybe people are just misunderstanding what you mean by  submitting results to a spreadsheet  -- are you doing this with code  or a copy paste from an HTML page into a spreadsheet  Maybe you can explain that in more detail  The delimiter for which you split the lines of the file shouldn t be displaying in the output anyway unless you have unexpected output for some other reason

User · Answer

Instead of adding the line breaks with nl2br   and then removing the line breaks with explode    try using the line break character   r  or   n  or   r n      lt  php      options  file get contents  employees txt         options explode   n   options             try  r as well       foreach   options as  singleOption           echo   lt option value     singleOption    gt    singleOption   lt  option gt              gt    This could also fix the issue if the problem was due to Google Spreadsheets reading the line breaks

[php] How do I hide the PHP explode delimiter from submitted form results?

Examples related to php

Examples related to forms

Examples related to explode

Examples related to delimiter

Examples related to nl2br