string function

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
rmeenakumari822
Participant
Posts: 30
Joined: Sat Oct 25, 2008 9:09 pm
Location: chennai

string function

Post by rmeenakumari822 »

Hi

i have a string like "ap_re_tfg_bftr"

what is the function to find how many "-" symbol is present in a string

Pls help me

Thanks
priya
Top
filename.txt
Participant
Posts: 27
Joined: Thu Mar 20, 2008 11:55 am

Post by filename.txt »

Use COUNT function in transformer.
Count(Link.Inputcolumn,"substring") In you case substring is "_"
Thanks.

"Creativity is the ability to use your available resources to their fullest."
Top
Post Reply

Return to “General”