combining numerical text

[affa44]

Hi,
I have just started using BRU and have found it great in removing dates from files - has saved so much time.
My query - these same files are created by combining one number e.g 5036 and a second number 0005 to reach a file name of 50360005.EC0. I can add the EC0 using BRU - can I add the 2 separate numbers in BRU? These numbers are in an EXCEL file.
Keep it simple, please guys
affa44
Tongala Australia

[jimwillsher]

You can do this if you concatenate the numbers in Excel (use &) and then use the Import Rename Pairs functionality.


Jim

[affa44]

Hi Jim,
all I have to do is work out what contatenate means - thank you for the prompt reply.
How do I donate to support BRU?
Regards,
David

[affa44]

Hello again Jim,

thanks for your suggestion to concatenate in Excel.
And I can spell it now, too!

Boy, have I saved some time with your suggestion and BRU.

Why didn't I know about both 3 years ago when I started this file reporting job!

Kind regards,
David

[jimwillsher]

No problem, happy to help.


Jim