HomeForum
Welcome, Guest

Replace all Alpha characters in a string
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: Replace all Alpha characters in a string

Replace all Alpha characters in a string 1 year, 2 months ago #2055

  • Oscar
  • OFFLINE
  • Fresh Boarder
  • Posts: 7
  • Karma: 0
Hi,

I reading data from the flat file, for one of the fields I need to replace all Alpha characters to zero
For example if the string is 123xx56 it should become 1230056.
I am thinking about using calculation transformation function and writing a script or is there more elegant solution?
Thanks.

Oscar

Re: Replace all Alpha characters in a string 1 year, 2 months ago #2065

  • Michael
  • OFFLINE
  • Fresh Boarder
  • Posts: 9
  • Karma: 0
No need to use calculation or scripts

use Replace characters function

See attached screen shot
Peter
Attachments:
  • Page:
  • 1
Time to create page: 0.17 seconds

Testimonials

Support team is quick and very often they reply to forum posts within minutes.

Mark Jonson,
EDS

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