Submitted by carloscadu on 2019/09/11 12:49 Hi, I'd appreciate your help regarding batch rename items, for instance adding _ in the beginning of item title:item 1 => _item 1item 2 => _item 2item 3 => _item 3 Is it possible to accomplish? How to? Thank you!Carlos Comments Hi Carlos, Sure it is !In the field properties for Item, check "Parse if starts with ="Select 1 or more items in a gridIn the Properties pane, enter ="_" & [item]Hit EnterDon't forget to uncheck the parse flag in the field properties (unless you find it useful)You can avoid changing the parse flag if you use an intermediate field:In Field F2, enter ="_" & [item]Right-click on F2 and select Parse EquationFor Item, enter =[F2]Right-click on Item and select Parse EquationErase the content in F2Details here: Field Management Dialog Pierre_AdminIQ Designer Log in or register to post comments Hi Pierre,Many thanks for the directions.I recorded a screencast detailing the procedures taught by you: http://bit.ly/2ZWrmirAnother question has appeared: How to perform the inverse batch renaming, in that case removing _ from the items' names?_item 1 => item 1_item 2 => item 2_item 3 => item 3Cheers,Carlos Log in or register to post comments =mid([item],2) should do the trick VBScript reference here: https://docs.microsoft.com/en-us/previous-versions/windows/internet-explorer/ie-developer/scripting-articles/d1wf56tt(v=vs.84) Pierre_AdminIQ Designer Log in or register to post comments Log in or register to post comments
Hi Carlos, Sure it is !In the field properties for Item, check "Parse if starts with ="Select 1 or more items in a gridIn the Properties pane, enter ="_" & [item]Hit EnterDon't forget to uncheck the parse flag in the field properties (unless you find it useful)You can avoid changing the parse flag if you use an intermediate field:In Field F2, enter ="_" & [item]Right-click on F2 and select Parse EquationFor Item, enter =[F2]Right-click on Item and select Parse EquationErase the content in F2Details here: Field Management Dialog Pierre_AdminIQ Designer Log in or register to post comments
Hi Pierre,Many thanks for the directions.I recorded a screencast detailing the procedures taught by you: http://bit.ly/2ZWrmirAnother question has appeared: How to perform the inverse batch renaming, in that case removing _ from the items' names?_item 1 => item 1_item 2 => item 2_item 3 => item 3Cheers,Carlos Log in or register to post comments
=mid([item],2) should do the trick VBScript reference here: https://docs.microsoft.com/en-us/previous-versions/windows/internet-explorer/ie-developer/scripting-articles/d1wf56tt(v=vs.84) Pierre_AdminIQ Designer Log in or register to post comments
Comments
_item 1 => item 1
_item 2 => item 2
_item 3 => item 3
Cheers,
Carlos