ETL-Tools.Com

Remove Space in Filename

More
1 year 11 months ago #21360 by downing
Remove Space in Filename was created by downing
Hi together,
I have to remove Spaces in Filenames.
File Operation is in my humble opinion the right Tool.
How do I configure it?

THX downing

Please Log in or Create an account to join the conversation.

More
1 year 11 months ago #21361 by Peter.Jonson
Replied by Peter.Jonson on topic Remove Space in Filename
Not sure I understand your question, can you clarify please
Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.

More
1 year 11 months ago #21362 by downing
Replied by downing on topic Remove Space in Filename
Hi Peter,

BFG 24.jpg --> BFG24.jpg
There are about 5000 Item Pictures.
It could be 1 or 2 spaces in the filename.

downing

Please Log in or Create an account to join the conversation.

More
1 year 11 months ago #21364 by admin
Replied by admin on topic Remove Space in Filename
You can use calcifications inside file names.
something like this will work
DeleteCharacters(ExtractFileName('<File Operation Source File>'),' ')}

www.etl-tools.com/wiki/aetle/packages/filenames_and_directories

Please keep us posted on your progress
Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
1 year 11 months ago #21365 by downing
Replied by downing on topic Remove Space in Filename
Is it possible inside of "File Operation"?



downing
Attachments:

Please Log in or Create an account to join the conversation.

More
1 year 11 months ago #21366 by Peter.Jonson
Replied by Peter.Jonson on topic Remove Space in Filename
Yes it is possible

I have created a working example for you
Here it is
www.etl-tools.com/automation/0020-how-to...-from-file-name.html
Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.

Copyright © 2023 ETL-tools.com. All Rights Reserved.