HomeForum
Welcome, Guest

Replacing a character with another character
(1 viewing) (1) Guest
  • 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

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:

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
  • Page:
  • 1
Time to create page: 0.15 seconds

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



Our customers

BP

BBC

HSBC


Databases we work with

Go to top