The Big Programming Thread - Page 719

$string = 'AB.6740.D.336.2011.AP';
$regex = '/\.(\D)\./';
$alphabet = range('a', 'z');

preg_match($regex, $string, $matches);

if (!empty($matches)) {
    $letter = strtolower($matches[1]);
    $num = array_search($letter, $alphabet) + 1;
   
    $string = preg_replace($regex, sprintf('.%d.', $num), $string);
}

echo $string;

update table set column = left(column, 4) + 
 case charAt(column, 5) 
  when '0' then 'A'
  when '1' then 'B'
  when '2' then 'C'
  when '3' then 'D'
  ...
 end + 
 case charAt(column, 6) 
  when '0' then 'A'
  when '1' then 'B'
  when '2' then 'C'
  when '3' then 'D'
  ...
 end + ... + ...

set key="HKCU\Software\Sketchup\Sketchup 2016\File Locations"

set sketchpart1=%USERPROFILE%

set sketchpart1=%sketchpart1:\=\\%

set sketchloc2="\"%sketchpart1%\\AppData\\Roaming\\SketchUp\\SketchUp 2016\\SketchUp\\Classifications\""

reg add %key% /v Classifications /d %sketchloc2% /f

\"C:\\user\\lilwisper\\AppData\\Roaming\\SketchUp\\SketchUp 2016\\SketchUp\\Classifications\"

> echo %USERPROFILE%
C:\users\lilwisper

> echo %USERPROFILE:\=\\%
C:\\users\\lilwisper

> echo "%USERPROFILE%"
"C:\users\lilwisper"

> echo "\"%USERPROFILE:\=\\%\\AppData\\Roaming\\SketchUp\\SketchUp 2016\\SketchUp\\Classifications\""
"\"C:\\users\\lilwisper\\AppData\\Roaming\\SketchUp\\SketchUp 2016\\SketchUp\\Classifications\""

> echo "%USERPROFILE%\AppData\Roaming\SketchUp\SketchUp 2016\SketchUp\Classifications"               
"C:\users\lilwisper\AppData\Roaming\SketchUp\SketchUp 2016\SketchUp\Classifications"

> set key="HKCU\Software\Sketchup\Sketchup 2016\File Locations"

> reg query %key% /v Classifications

Classname1.doSomethingWhichAccessesAttributes();

Classname1 myClass = Classname2.doSomethingWhichAccessesAttributes();