try this if your field has other spaces in it
="<ANYQUOTE>" + trimright(substitute("""United State's of America ""","<QUOTE>","")) + "<ANYQUOTE>"
In your case replace the text with your field.
Search found 198 matches
- Thu Sep 27, 2007 9:32 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: blank space within quotation
- Replies: 7
- Views: 5185
- Thu Sep 27, 2007 8:03 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: blank space within quotation
- Replies: 7
- Views: 5185
- Thu Sep 27, 2007 2:24 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: blank space within quotation
- Replies: 7
- Views: 5185
- Tue Sep 25, 2007 2:41 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: Comma as a data in a input file
- Replies: 3
- Views: 3587
- Fri Sep 21, 2007 3:32 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: Mapping invalid fields?
- Replies: 7
- Views: 6987
- Thu Sep 20, 2007 2:04 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: Mapping invalid fields?
- Replies: 7
- Views: 6987
- Wed Sep 19, 2007 9:27 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: Mapping invalid fields?
- Replies: 7
- Views: 6987
- Wed Sep 19, 2007 9:15 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: Help to become good?
- Replies: 11
- Views: 7855
- Wed Sep 19, 2007 7:55 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: Help to become good?
- Replies: 11
- Views: 7855
- Mon Sep 17, 2007 8:27 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: Problems with importing from XML Schema(xsd)
- Replies: 21
- Views: 15583
- Mon Sep 17, 2007 7:22 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: Problems with importing from XML Schema(xsd)
- Replies: 21
- Views: 15583
- Sat Sep 15, 2007 6:45 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: special character handling
- Replies: 4
- Views: 5997
- Tue Sep 11, 2007 7:50 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: Resource Registry Use or MisUse Question......
- Replies: 10
- Views: 9639
Well I supose if you are a consultant you would think that way as it provides you with work every time something changes. We prefer to have everything soft coded so that we don't have to wory about changing code, only resource registry or properties files. In our development environment things are c...
- Tue Sep 11, 2007 2:05 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: Resource Registry Use or MisUse Question......
- Replies: 10
- Views: 9639
So what would you do if your ftp destinations were changed for different environments. You would have to change the maps or msl. By using resource registry you can be confident that the mep you tested can be copied to the live environment with no changes. Only change may be resource registry. If you...
- Mon Sep 10, 2007 8:33 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: Problems with importing from XML Schema(xsd)
- Replies: 21
- Views: 15583