extract specific data

[Phee]

Gentleman,

we use Datastage 7.1 on a Win 2000 AS with SP4.

I have two questions.

First one: how is it possible to trim a quote character?
I tried this statement to remove all quotes:
Trim("String", " " ","A")
...did not work, but the statement:
Trim"String", " . ", "A")
...works and removes all dots.

Second questions:
I have different data in one cell on a record. Now I would like to segment this data into new cells.
The cell looks similar like:
user1 32437 3 pp: 3
user9 202934 5 pp: 9
user3 30329 9 pp: 5
That should be possible with the expression editor, don't you think so?

Any help would be appreciated.

Kind regards,
Phee

 

[JGirl]

The quote character is used as part of the syntax in the expression editor, so you'll need to use an escape sequence to let datastage know that you are searching for the quote character rather than trying to end your expressions.

I can't remember what the escape secuences in datastage are, but try Trim("String", " \" ","A").

You shouldnt have any trouble splitting the data into new cells using the datastage functions once you've decided how the data needs to be split out.

J

 

[Phee]

JGirl,
thanks for the post.

I found a solution with the Trim function and for the other challenge I wrote a server routine. It even worked.

Kind regards,
Phee