ETL and Data Integration tools - Modern ETL software for everyone
Home
Products
Overview
Advanced ETL Processor
Advanced ETL Processor Pro
Advanced ETL Processor Ent
Visual Importer
Visual Importer Pro
Visual Importer Ent
Data Exchange Wizard
ABI Portal
Active Table Editor
VImp X
DEWizardX
Database Browser
Table2Text
QlikView Connector
Support
Support Procedure
Support Forum
Partners
Partnership Options
Register as a Partner
Partner Login
Software Distribution
Order
Online Shop
Ordering Software
Customer Care Center
Articles
Downloads
Contact Us
Questions? Call us today: +44 (0) 843 289 2768
Home
Forum
Index
Recent Topics
How to get Help today
Search
Welcome,
Guest
ETL-Forum
Forum
Advanced ETL Processor
Replacing a character with another character
(1 viewing) (1) Guest
Reply Topic
New Topic
Page:
1
TOPIC: Replacing a character with another character
Replacing a character with another character
1 year, 2 months ago
#1939
Maria
OFFLINE
Fresh Boarder
Posts: 7
Karma: 0
Hello
I am trying to use calculation function to replace the - with a space
Right now I'm thinking I would have to split the string into three pieces and then concat them back together... Any ideas?
Here is the example of my data dd-mm-yyyy
Thanks,
Maria
Reply
Quote
Re: Replacing a character with another character
1 year, 2 months ago
#1940
admin
NOW ONLINE
Moderator
Posts: 2182
Karma: 12
I thing you are making simple data transformation much more complicated.
Just use Replace Characters function
Mike
Attachments:
replace_ch...ters.gif
(16KB)
Reply
Quote
Re: Replacing a character with another character
1 year, 2 months ago
#1941
Maria
OFFLINE
Fresh Boarder
Posts: 7
Karma: 0
Thank you for taking the time to reply.
That is much more elegant than what I did...
Maria
Reply
Quote
Reply Topic
New Topic
Page:
1
ETL-Forum
Forum
Advanced ETL Processor
Board Categories
Forum
... Data Warehousing and Data integration
... Advanced ETL Processor
... Visual Importer
... Database Browser
... Active Table Editor
... Active Table Editor
... All other ETL and ActiveX Products
... The Suggestion Box
... Independent Consultants
Powered by
Kunena
Online Data transformation tutorials
Converting text files using
Loading data from multiple files into MS Sql Server
Performing Star Transformation
Working with Pivot and Sorter
Exporting data from MySQL Database into text files
Loading Data from Excel file into MySQL Database
ETL News
Loading data from RSS feeds
Automating loading QlikView dashboards in distributed environment
Union ALL Data transformation
Loading data from QVX files
Advanced ETL Processor - Themes
New data transfornation functions
Select Language
English
Arabic
Bulgarian
Chinese (Simplified)
Chinese (Traditional)
Croatian
Czech
Danish
Dutch
Finnish
French
German
Greek
Hindi
Italian
Japanese
Korean
Norwegian
Polish
Portuguese
Romanian
Russian
Spanish
Swedish
Testimonials
If we compare to manual processing this program save more than 200 hours in month.
C Gandhi
Nesa-Canada
User Login
You only need to log in or register to use our support forum
Username
Password
Remember Me
Forgot your password?
Forgot your username?
Create an account
Our customers
Go to top