ETL-Tools.Com

Remove Space in Filename

More
4 years 10 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
4 years 10 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
4 years 10 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
4 years 10 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/advanced-etl-proc.../dynamic-file-names/

Please keep us posted on your progress
Mike
ETL Architect

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

More
4 years 10 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
4 years 10 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 © 2008-2026 ETL-tools.com. All Rights Reserved.

Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Google
Accept
Decline
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Google Analytics
Accept
Decline
Functional
Tools used to give you more features when navigating on the website, this can include social sharing.
Advertisement
If you accept, the ads on the page will be adapted to your preferences.
Google Ad
Accept
Decline
Save