title: Need to read location.txt vs Tableau and process lines with '&' as a string, not escape in .bat file
body: <p>I have been playing around with a code my colleague sent me, Here is the issue I am running into.
  This code logs me into Tableau and runs the names of certain locations against my Tableau sheet &amp; if it finds a matching name in the LOCATION.txt it PDFs that locations information off of Tableau into my AutomatePars folder. WORKS AMAZING for all locations EXCEPT the locations who's names contain an &amp;
  The names of all the locations are pulled from a separate text file (the locations I am interested change all the time) and all spaces are already removed.</p>
  
  <p>I NEED to read in each name as a string even when they have "&amp;" in them. I can't escape or forget the &amp; because the name of the location has an '&amp;' in it...I have tried escaping and I get the same null read in my PDF....very frustrating for sure.
  Another colleague suggested creating some other variable &amp; then using replace, but I have no idea how to do that...any help would be greatly appreciated as I am not sure how to fix this!</p>
  
  <pre><code>@echo off
  set CUR_YYYY=%date:~10,4%
  set CUR_MM=%date:~4,2%
  set CUR_DD=%date:~7,2%
  set CUR_HH=%time:~0,2%
  if %CUR_HH% lss 10 (set CUR_HH=0%time:~1,1%)
  set CUR_NN=%time:~3,2%
  set CUR_SS=%time:~6,2%
  set CUR_MS=%time:~9,2%
  set SUBFILENAME=%CUR_YYYY%-%CUR_MM%-%CUR_DD%-%CUR_HH%%CUR_NN%%CUR_SS%
  if exist C:\Users\USER\Automate_Pars\%CUR_YYYY%-%CUR_MM%-%CUR_DD%-%CUR_HH%%CUR_NN%%CUR_SS% RMDIR /s /Q C:\Users\USER\Automate_Pars\%CUR_YYYY%-%CUR_MM%-%CUR_DD%-%CUR_HH%%CUR_NN%%CUR_SS%
  md "C:\Users\USER\Automate_Pars\%SUBFILENAME%"
  for /f "tokens=*" %%a in (C:\Users\USER\Automate_Pars\LOCATION.txt) do call :processline %%a
  rem using the live database, add “?:refresh=yes” after the URL in order to get the latest snapshot as an output.
  
      :processline
      tabcmd export "ParForm/ParLevelSheet?Location=%*&amp;:refresh=yes" --pdf --pagelayout landscape --pagesize unspecified -f "C:\Users\USER\Automate_Pars\%SUBFILENAME%\%*.pdf" -t "Moda"
      if EXIST "C:\Users\USER\Automate_Pars\%SUBFILENAME%\.pdf" DEL /F "C:\Users\USER\Automate_Pars\%SUBFILENAME%\.pdf"
      echo "complete"
  </code></pre>