Subject: Re: [Name Mangler Talk] Reame Based on List

From: Caio Costa <[email-masked]>
Date: Fri, 3 Jul 2020 23:36:58 -0700 (PDT)

Hi Amy,

I'm facing the same issue you described in the original post.

Do you mind sharing the code you used? I don't know how to do it.

Thanks

Em sexta-feira, 20 de abril de 2018 às 16:48:05 UTC-3, Amy Redfern escreveu:

> Hi Hal,
>
> That worked much better! 
>
> Thanks again,
> Amy
>
>
> On Thursday, April 19, 2018 at 7:11:24 PM UTC-7, hrh3 wrote:
>>
>> You’re quite welcome!  Glad it worked out. 
>>
>> I’m using Excel 2011 on another computer and it looks like it works 
>> better with four double quotes in a row instead of three towards the end of 
>> the formula: 
>>
>> =“[find """&A2&""" <name.extension> """&B2&""""&"]" 
>>
>> cheers, 
>>
>> -Hal 
>>
>> > On Apr 19, 2018, at 5:28 PM, Amy Redfern <[email-masked]> wrote: 
>> > 
>> > Hi Hal, 
>> > 
>> > Thank you so much for this brilliant idea! 
>> > 
>> > The formula for Name Mangler advanced mode works perfectly. 
>> > [find "folderA" <name> "folderB"] 
>> > 
>> > The excel formula didn't quite work as planned, perhaps because of my 
>> version or OS. When I used the formula provided, Excel seemed to complain 
>> that I was using a Find function incorrectly. What I ended up doing was 
>> separating out different components of the Name Mangler expression and then 
>> concatenating them together (and then hiding the excess rows for neatness). 
>> > 
>> > Thank you Hal & Rob for your quick responses and great ideas - it's 
>> very much appreciated! 
>> > 
>> > Best, 
>> > Amy 
>> > 
>> > On Thursday, April 19, 2018 at 5:43:28 AM UTC-7, hrh3 wrote: 
>> > Try using a formula in Excel to build FIND functions that would work in 
>> the Advanced section of Name Mangler. 
>> > 
>> > Using your table as an example: 
>> > 
>> > Column A         Column B 
>> > abc.ari              def.ari 
>> > etc. 
>> > 
>> > 
>> > Assuming cell A2 contains abc.ari and cell B2 contains def.ari, enter 
>> this formula in cell C2: 
>> > 
>> > ="[find """&A2&""" <name.extension> """&B2&""”]" 
>> > 
>> > 
>> > Cell C2 should produce this result: 
>> > 
>> > [find "abc.ari" <name.extension> "def.ari”] 
>> > 
>> > 
>> > Copy cell C2 down for as many rows as you need, then copy those cells 
>> and paste them into the Advanced section of Name Mangler. 
>> > 
>> > 
>> > When you populate Name Mangler with the files you want to rename, they 
>> should show the correct results regardless of sort order. 
>> > 
>> > 
>> > -Hal 
>> > 
>> > 
>> > 
>> > 
>> > > On Apr 18, 2018, at 6:06 PM, Amy Redfern <[email-masked]> wrote: 
>> > > 
>> > > Ok, thanks so much for your quick reply. 
>> > > 
>> > > Best, 
>> > > Amy 
>> > > 
>> > > On Wednesday, April 18, 2018 at 2:54:25 PM UTC-7, Many Tricks wrote: 
>> > > On Apr 18, 2018, at 2:21 PM, Amy Redfern <[email-masked]> wrote: 
>> > > 
>> > > > I am so glad to have found this program - it's much faster & better 
>> than any other such program we have used. It will save us THOUSANDS of 
>> hours at my work. 
>> > > 
>> > > Thanks! I'll pass your kind words on to Peter, Many Tricks' founder 
>> and programmer extraordinaire. 
>> > > 
>> > > > Is there a way for the program to find the original name in a .csv 
>> or .txt file and find the new name? 
>> > > 
>> > > There is not. 
>> > > 
>> > > > I realize I could sort by name in Excel & in Name Mangler & copy 
>> and paste, but I'm dealing with hundreds of folders & fear that may be room 
>> for error. 
>> > > 
>> > > At present, that's the only way: Sort the list in Excel so that it 
>> matches the sort in Name Mangler, then apply the terms list. At present, 
>> Name Mangler doesn't know how to do anything with a multi-column terms 
>> list. 
>> > > 
>> > > > Is there a way to do something like this in Advanced Mode? 
>> > > 
>> > > There isn't, because you can't use the terms as elements of an array, 
>> for example, to compare them against filenames in a loop. 
>> > > 
>> > > regards; 
>> > > -rob. 
>> > > 
>> > > 
>> > > -- 
>> > > -- 
>> > > You received this message because you are subscribed to the Name 
>> Mangler Talk group. To post to this group, send email to 
>> [email-masked]. To unsubscribe from this group, send email 
>> to [email-masked]. 
>> > >   
>> > > For more options, visit the Name Mangler Talk web page at <
>> http://groups.google.com/group/name-mangler-talk> 
>> > > 
>> > > --- 
>> > > You received this message because you are subscribed to the Google 
>> Groups "Name Mangler Talk" group. 
>> > > To unsubscribe from this group and stop receiving emails from it, 
>> send an email to [email-masked]. 
>> > > For more options, visit https://groups.google.com/d/optout. 
>> > 
>> > 
>> > -- 
>> > -- 
>> > You received this message because you are subscribed to the Name 
>> Mangler Talk group. To post to this group, send email to 
>> [email-masked]. To unsubscribe from this group, send email 
>> to [email-masked]. 
>> >   
>> > For more options, visit the Name Mangler Talk web page at <
>> http://groups.google.com/group/name-mangler-talk> 
>> > 
>> > --- 
>> > You received this message because you are subscribed to the Google 
>> Groups "Name Mangler Talk" group. 
>> > To unsubscribe from this group and stop receiving emails from it, send 
>> an email to [email-masked]. 
>> > For more options, visit https://groups.google.com/d/optout. 
>>
>>

---

From: Amy Redfern <[email-masked]>
Date: Fri, 20 Apr 2018 12:48:04 -0700 (PDT)

Hi Hal,

That worked much better! 

Thanks again,
Amy

On Thursday, April 19, 2018 at 7:11:24 PM UTC-7, hrh3 wrote:
> I’m using Excel 2011 on another computer and it looks like it works better 
> with four double quotes in a row instead of three towards the end of the 
> formula: 
>
> > On Apr 19, 2018, at 5:28 PM, Amy Redfern <[email-masked] 
> <javascript:>> wrote: 
> > 
> > Hi Hal, 
> > 
> > Thank you Hal & Rob for your quick responses and great ideas - it's very 
> much appreciated! 
> > 
> > Best, 
> > Amy 
> > 
> > > > I realize I could sort by name in Excel & in Name Mangler & copy and 
> paste, but I'm dealing with hundreds of folders & fear that may be room for 
> error. 
> > > 
> > You received this message because you are subscribed to the Name Mangler 
> Talk group. To post to this group, send email to 
> [email-masked] <javascript:>. To unsubscribe from this 
> group, send email to [email-masked] <javascript:>. 
> >   
> an email to [email-masked] <javascript:>.

---

From: Hal Hunnicutt <[email-masked]>
Date: Thu, 19 Apr 2018 22:11:21 -0400

I’m using Excel 2011 on another computer and it looks like it works better with four double quotes in a row instead of three towards the end of the formula:

cheers,

-Hal

> On Apr 19, 2018, at 5:28 PM, Amy Redfern <[email-masked]> wrote:
> 
> Hi Hal,
> 
> The excel formula didn't quite work as planned, perhaps because of my version or OS. When I used the formula provided, Excel seemed to complain that I was using a Find function incorrectly. What I ended up doing was separating out different components of the Name Mangler expression and then concatenating them together (and then hiding the excess rows for neatness). 
> 
> Thank you Hal & Rob for your quick responses and great ideas - it's very much appreciated!
> 
> Best,
> Amy
> 
> Try using a formula in Excel to build FIND functions that would work in the Advanced section of Name Mangler. 
> 
> Assuming cell A2 contains abc.ari and cell B2 contains def.ari, enter this formula in cell C2: 
> 
> Copy cell C2 down for as many rows as you need, then copy those cells and paste them into the Advanced section of Name Mangler. 
> 
> 
> When you populate Name Mangler with the files you want to rename, they should show the correct results regardless of sort order. 
> 
> 
> -Hal 
> 
> 
> 
> 
> > > I am so glad to have found this program - it's much faster & better than any other such program we have used. It will save us THOUSANDS of hours at my work. 
> > 
> > Thanks! I'll pass your kind words on to Peter, Many Tricks' founder and programmer extraordinaire. 
> > 
> > > Is there a way for the program to find the original name in a .csv or .txt file and find the new name? 
> > 
> > There is not. 
> > 
> > > I realize I could sort by name in Excel & in Name Mangler & copy and paste, but I'm dealing with hundreds of folders & fear that may be room for error. 
> > 
> > At present, that's the only way: Sort the list in Excel so that it matches the sort in Name Mangler, then apply the terms list. At present, Name Mangler doesn't know how to do anything with a multi-column terms list. 
> > 
> > There isn't, because you can't use the terms as elements of an array, for example, to compare them against filenames in a loop. 
> > 
> > regards; 
> > -rob. 
> > 
> > 
> > -- 
> > -- 
> > You received this message because you are subscribed to the Name Mangler Talk group. To post to this group, send email to [email-masked]. To unsubscribe from this group, send email to [email-masked]. 
> >   
> > For more options, visit the Name Mangler Talk web page at <http://groups.google.com/group/name-mangler-talk> 
> > 
> > --- 
> > You received this message because you are subscribed to the Google Groups "Name Mangler Talk" group. 
> > To unsubscribe from this group and stop receiving emails from it, send an email to [email-masked]. 
> You received this message because you are subscribed to the Name Mangler Talk group. To post to this group, send email to [email-masked]. To unsubscribe from this group, send email to [email-masked].
>  
> For more options, visit the Name Mangler Talk web page at <http://groups.google.com/group/name-mangler-talk>
> 
> --- 
> You received this message because you are subscribed to the Google Groups "Name Mangler Talk" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to [email-masked].

---

From: Amy Redfern <[email-masked]>
Date: Thu, 19 Apr 2018 14:28:06 -0700 (PDT)

Hi Hal,

Best,
Amy

On Thursday, April 19, 2018 at 5:43:28 AM UTC-7, hrh3 wrote:
> Copy cell C2 down for as many rows as you need, then copy those cells and 
> paste them into the Advanced section of Name Mangler. 
>
>
> > On Apr 18, 2018, at 6:06 PM, Amy Redfern <[email-masked] 
> <javascript:>> wrote: 
> >

---

From: Rob Griffiths <[email-masked]>
Date: Thu, 19 Apr 2018 05:47:48 -0700

> Try using a formula in Excel to build FIND functions that would work in the Advanced section of Name Mangler.

Hal, that's brilliant! Also, we may be able to add two-column support in a future release of Name Mangler, so thanks Amy for the suggestion—we're looking into it.

-rob.

---

From: Hal Hunnicutt <[email-masked]>
Date: Thu, 19 Apr 2018 08:43:26 -0400

Column A         Column B
abc.ari              def.ari
etc.

-Hal

> On Apr 18, 2018, at 6:06 PM, Amy Redfern <[email-masked]> wrote:
>

---

From: Amy Redfern <[email-masked]>
Date: Wed, 18 Apr 2018 15:06:36 -0700 (PDT)

Best,
Amy

On Wednesday, April 18, 2018 at 2:54:25 PM UTC-7, Many Tricks wrote:
>
> On Apr 18, 2018, at 2:21 PM, Amy Redfern <[email-masked] <javascript:>> 
> wrote: 
>
> > I am so glad to have found this program - it's much faster & better than 
> any other such program we have used. It will save us THOUSANDS of hours at 
> my work. 
>
> At present, that's the only way: Sort the list in Excel so that it matches 
> the sort in Name Mangler, then apply the terms list. At present, Name 
> Mangler doesn't know how to do anything with a multi-column terms list. 
>
> There isn't, because you can't use the terms as elements of an array, for 
> example, to compare them against filenames in a loop. 
>
> regards; 
> -rob. 
>
>

---

From: Rob Griffiths <[email-masked]>
Date: Wed, 18 Apr 2018 14:54:23 -0700

There is not.

regards;
-rob.

---

From: Amy Redfern <[email-masked]>
Date: Wed, 18 Apr 2018 14:21:40 -0700 (PDT)

Hello there,

We need to rename folders (and subsequently their files contained) based on 
a list. I understand how to do this using the Terms in the Arbitrary 
sequence. However, this simply renames them in the order they appear. 

Is there a way for the program to find the original name in a .csv or .txt 
file and find the new name?

For example:
Column A         Column B
abc.ari              def.ari
ghi.ari               jkl.ari
etc

I realize I could sort by name in Excel & in Name Mangler & copy and paste, 
but I'm dealing with hundreds of folders & fear that may be room for error.

In any case, thank you very much for creating this program!

All my best,
Amy