SQL code to remove characters

(0) Share

Report

Posted on by Community Member

I am trying to make the computed col. in view , column should return strRem kind of thing suppose I want to remove ## from a field value of the same column , can any one suggest what SQL statement I suppose to write I wrote this expression:

expression = "StrRem("+ SysComputedColumn::returnField(_viewName,_DataSourceParty,_DataSourcePartyField) + ",'//')"

but it giving error while doing sync on view

any suggestion ?

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Martin Dráb 237,967 Most Valuable Professional on at

Like (0)

Report

Do you mean all # characters anywhere in the string, or just at a certain positon, or just if it's a pair of # characters, or what exactly?

Obviously strRem() isn't a valid T-SQL command.

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

Try using Transact-SQL syntax in the expression, that can be interpreted for Views most likely:

stackoverflow.com/.../remove-certain-characters-from-a-string

Was this reply helpful? Yes No
Suggested answer

Brian Kinser 815 on at

Like (0)

Report

please describe usage scenarios....if this is for display only I would create a display method that takes the value and massages it to show you appropriate text. If the data is bad and you actually need to cleanse it, I would write a x++ job that loops through all records that have cleansing need, then modify the text and update the record.....pretty common path to clean up data after imports and I have used this approach often...please mark as answer if appropriate

Was this reply helpful? Yes No