nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

split text and use parts as variables?

Anonymous User

I want to use the numbered parts of this script in the screenshot below as variables. Any suggestions?

タグ付けされた投稿をもっと見る

Accepted answers

RandyBurton

If the filename format is consistent, you could use a couple of splits:

filename <SPAN class="operator token">=</SPAN> <SPAN class="string token">'Bermuda Rd MP 0_26 102017_TestTable.xlsx'</SPAN>
f <SPAN class="operator token">=</SPAN> filename<SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">' MP '</SPAN><SPAN class="punctuation token">)</SPAN>
address <SPAN class="operator token">=</SPAN> f<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
mile <SPAN class="operator token">=</SPAN> f<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">' '</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="keyword token">print</SPAN> address
<SPAN class="comment token"># Bermuda Rd</SPAN>

<SPAN class="keyword token">print</SPAN> mile
<SPAN class="comment token"># 0_26</SPAN>

<SPAN class="comment token"># and if the underscore in mile represents a decimal point</SPAN>
<SPAN class="keyword token">print</SPAN> <SPAN class="string token">'.'</SPAN><SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>mile<SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'_'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token"># 0.26</SPAN>
<SPAN class="comment token"># or</SPAN>
mile <SPAN class="operator token">=</SPAN> <SPAN class="string token">'.'</SPAN><SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>f<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">' '</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'_'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

And using listdir to get filenames in directory:

<SPAN class="keyword token">import</SPAN> os

path <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\Users\anthonyv\Downloads\Upload"</SPAN>

files <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>listdir<SPAN class="punctuation token">(</SPAN>path<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">for</SPAN> filename <SPAN class="keyword token">in</SPAN> files<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; f <SPAN class="operator token">=</SPAN> filename<SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">' MP '</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; address <SPAN class="operator token">=</SPAN> f<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># mile = f[1].split(' ')[0] # keep underscore</SPAN>
&nbsp;&nbsp;&nbsp; mile <SPAN class="operator token">=</SPAN> <SPAN class="string token">'.'</SPAN><SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>f<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">' '</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'_'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="comment token"># convert underscore to period</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> address<SPAN class="punctuation token">,</SPAN> mile‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

All comments

Anonymous User

Randy Burton‌

I was able to integrate it into the script above but it's not listing both file names.

<SPAN class="keyword token">import</SPAN> os<SPAN class="punctuation token">,</SPAN> sys<SPAN class="punctuation token">,</SPAN> pandas <SPAN class="keyword token">as</SPAN> pd

path <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\Users\anthonyv\Downloads\Metro\New folder"</SPAN>

files <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>listdir<SPAN class="punctuation token">(</SPAN>path<SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">for</SPAN> filename <SPAN class="keyword token">in</SPAN> files<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; f <SPAN class="operator token">=</SPAN> filename<SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">' MP '</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; address <SPAN class="operator token">=</SPAN> f<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; mile <SPAN class="operator token">=</SPAN> <SPAN class="string token">'.'</SPAN><SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>f<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">' '</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'_'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="comment token"># convert underscore to period</SPAN>
&nbsp;&nbsp;&nbsp; df <SPAN class="operator token">=</SPAN> pd<SPAN class="punctuation token">.</SPAN>DataFrame<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">{</SPAN><SPAN class="string token">'MP'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"{}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>mile<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'RdNm'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"{}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>address<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">)</SPAN>

writer <SPAN class="operator token">=</SPAN> pd<SPAN class="punctuation token">.</SPAN>ExcelWriter<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'MetroReportAGOL.xlsx'</SPAN><SPAN class="punctuation token">)</SPAN>
df<SPAN class="punctuation token">.</SPAN>to_excel<SPAN class="punctuation token">(</SPAN>writer<SPAN class="punctuation token">,</SPAN> sheet_name<SPAN class="operator token">=</SPAN><SPAN class="string token">'Sheet1'</SPAN><SPAN class="punctuation token">)</SPAN>
writer<SPAN class="punctuation token">.</SPAN>save<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Complete"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Anonymous User

Randy,

The last part of this would be to use address and mile variables for use in creating a excel file. Do you know how I could use the results of the first script in some sort of loop to generate a xlsx document? Below is the script I need to combine it with. The end result would be a column of the address results and a column for the mile results.

<SPAN class="keyword token">import</SPAN> os
os<SPAN class="punctuation token">.</SPAN>remove<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"MetroReportAGOL.xlsx"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Previous Report Deleted"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">import</SPAN> os<SPAN class="punctuation token">,</SPAN> pandas <SPAN class="keyword token">as</SPAN> pd


<SPAN class="comment token"># Create a Pandas dataframe from the data.</SPAN>
df <SPAN class="operator token">=</SPAN> pd<SPAN class="punctuation token">.</SPAN>DataFrame<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">{</SPAN><SPAN class="string token">'MP'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"{}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>mile<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'RdNm'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"{}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>address<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Create a Pandas Excel writer using XlsxWriter as the engine.</SPAN>
writer <SPAN class="operator token">=</SPAN> pd<SPAN class="punctuation token">.</SPAN>ExcelWriter<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'MetroReportAGOL.xlsx'</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Convert the dataframe to an XlsxWriter Excel object.</SPAN>
df<SPAN class="punctuation token">.</SPAN>to_excel<SPAN class="punctuation token">(</SPAN>writer<SPAN class="punctuation token">,</SPAN> sheet_name<SPAN class="operator token">=</SPAN><SPAN class="string token">'Sheet1'</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Close the Pandas Excel writer and output the Excel file.</SPAN>
writer<SPAN class="punctuation token">.</SPAN>save<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Complete"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Anonymous User

This is exactly what I was looking for!

-Thanks for your help

RandyBurton

If the filename format is consistent, you could use a couple of splits:

filename <SPAN class="operator token">=</SPAN> <SPAN class="string token">'Bermuda Rd MP 0_26 102017_TestTable.xlsx'</SPAN>
f <SPAN class="operator token">=</SPAN> filename<SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">' MP '</SPAN><SPAN class="punctuation token">)</SPAN>
address <SPAN class="operator token">=</SPAN> f<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
mile <SPAN class="operator token">=</SPAN> f<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">' '</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="keyword token">print</SPAN> address
<SPAN class="comment token"># Bermuda Rd</SPAN>

<SPAN class="keyword token">print</SPAN> mile
<SPAN class="comment token"># 0_26</SPAN>

<SPAN class="comment token"># and if the underscore in mile represents a decimal point</SPAN>
<SPAN class="keyword token">print</SPAN> <SPAN class="string token">'.'</SPAN><SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>mile<SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'_'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token"># 0.26</SPAN>
<SPAN class="comment token"># or</SPAN>
mile <SPAN class="operator token">=</SPAN> <SPAN class="string token">'.'</SPAN><SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>f<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">' '</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'_'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

And using listdir to get filenames in directory:

<SPAN class="keyword token">import</SPAN> os

path <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\Users\anthonyv\Downloads\Upload"</SPAN>

files <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>listdir<SPAN class="punctuation token">(</SPAN>path<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">for</SPAN> filename <SPAN class="keyword token">in</SPAN> files<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; f <SPAN class="operator token">=</SPAN> filename<SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">' MP '</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; address <SPAN class="operator token">=</SPAN> f<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># mile = f[1].split(' ')[0] # keep underscore</SPAN>
&nbsp;&nbsp;&nbsp; mile <SPAN class="operator token">=</SPAN> <SPAN class="string token">'.'</SPAN><SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>f<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">' '</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'_'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="comment token"># convert underscore to period</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> address<SPAN class="punctuation token">,</SPAN> mile‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

DanPatterson_Retired

a <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Bermuda Rd first.py'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Bermuda Rd first.py'</SPAN><SPAN class="punctuation token">]</SPAN>

b <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>i<SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">' '</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> a<SPAN class="punctuation token">]</SPAN>&nbsp; <SPAN class="comment token"># ---- now split on the spaces</SPAN>

c <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>i<SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> b<SPAN class="punctuation token">]</SPAN>

c
<SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Bermuda'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Rd'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Bermuda'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Rd'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Anonymous User

I figured out how to call one part of the file name from the first file. I'm needing to throw this in some sort of loop that will grab the same value for each file no matter how many there are at the time. For this test there are only 2 files I'm trying to grab the variable FullNm from.

<SPAN class="keyword token">import</SPAN> os<SPAN class="punctuation token">,</SPAN> sys

path <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\Users\anthonyv\Downloads\Upload"</SPAN>
x <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">(</SPAN>os<SPAN class="punctuation token">.</SPAN>listdir<SPAN class="punctuation token">(</SPAN>path<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
xyz <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>x<SPAN class="punctuation token">)</SPAN>
words <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">(</SPAN>xyz<SPAN class="punctuation token">)</SPAN>
words2 <SPAN class="operator token">=</SPAN> words<SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">" "</SPAN><SPAN class="punctuation token">)</SPAN>
RdNm<SPAN class="punctuation token">,</SPAN>RdTyp<SPAN class="punctuation token">,</SPAN>Mp<SPAN class="punctuation token">,</SPAN>MpNm<SPAN class="punctuation token">,</SPAN>Dt <SPAN class="operator token">=</SPAN> words2<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>words2<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>words2<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>words2<SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>words2<SPAN class="punctuation token">[</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN>
OFullNm <SPAN class="operator token">=</SPAN> <SPAN class="string token">"{} {}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>RdNm<SPAN class="punctuation token">,</SPAN>RdTyp<SPAN class="punctuation token">)</SPAN>
FullNm <SPAN class="operator token">=</SPAN> OFullNm<SPAN class="punctuation token">.</SPAN>replace<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"['"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN>FullNm<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

JoshuaBixby

Can you paste the text into GeoNet? Whenever I try to copy what I see on the screenshot, the Python interpreter keeps giving invalid syntax errors.

DanPatterson_Retired

you don't split the list... you want to split what is in the list

a <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'a file with spaces.py'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'another one for some reason.py'</SPAN><SPAN class="punctuation token">]</SPAN>

b <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>i<SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">' '</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> a<SPAN class="punctuation token">]</SPAN>&nbsp; <SPAN class="comment token"># ---- now split on the spaces</SPAN>
 
b

<SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'a'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'file'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'with'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'spaces.py'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'another'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'one'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'for'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'some'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'reason.py'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Anonymous User

Yes, my filenames contain spaces in them. I tried removing the str(x) line but get the following error...

AttributeError: 'list' object has no attribute 'split'

DanPatterson_Retired

which was I was pointing out, you made a string of your list. Did you try removing your str(x) line to get your actual file names? and do you filenames actually contain spaces?

Anonymous User

DanPatterson_Retired

I am not sure why you want to make a string of a list. I suspect you want filenames from a folder.

<SPAN class="comment token">#---- get the list and slice the first two as an example</SPAN>

pth <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"c:\Temp"</SPAN>

words <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">(</SPAN>os<SPAN class="punctuation token">.</SPAN>listdir<SPAN class="punctuation token">(</SPAN>pth<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
words<SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'aust_temperature_demo.py'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'aust_temperature_demo.py.zip'</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="comment token"># ---- now see what happens when you 'str' it</SPAN>

words <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>os<SPAN class="punctuation token">.</SPAN>listdir<SPAN class="punctuation token">(</SPAN>pth<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
words<SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="string token">"['"</SPAN>&nbsp; <SPAN class="comment token"># ---- ??????</SPAN>


words&nbsp; <SPAN class="comment token"># it is now a string</SPAN>

<SPAN class="string token">"['aust_temperature_demo.py', 'aust_temperature_demo.py.zip' ... snip ...&nbsp; '__pycache__']"</SPAN>

<SPAN class="comment token"># ---- get files of a certain type ... one method</SPAN>

py_files <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>f <SPAN class="keyword token">for</SPAN> f <SPAN class="keyword token">in</SPAN> os<SPAN class="punctuation token">.</SPAN>listdir<SPAN class="punctuation token">(</SPAN>pth<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">if</SPAN> f<SPAN class="punctuation token">[</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="string token">".py"</SPAN><SPAN class="punctuation token">]</SPAN>

py_files
<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'aust_temperature_demo.py'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN> snip <SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN> <SPAN class="string token">'script1.py'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'script2.py'</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Then split up your filenames

JoshuaBixby

Can you post another shot without your boxing/highlighting? I am trying to look closer at the structure of your list, but I think there are some important quotes being covered up.

会話に参加する

サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。

クイックリンク

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.