How to use RegEx to convert CRLF to LF?

[daniel347x]

Hello -

I cannot figure out how to use MS to convert CRLF to LF throughout a string variable.

RegEx>(?m)%CRLF%,%mystring%,0,Matches,NumMatches,1,%LF%,mystring_result

... does not seem to work.

I can't find an answer browsing through the forums.

Any suggestions?

Thanks,
Dan.

EDIT: I am baffled by this, but:
RegEx>%CRLF%,%mystring%,0,Matches,NumMatches,1,%LF%,mystring_result
... now works. (The (?m) isn't necessary, but it works with it as well.

I am scratching my head as to why it didn't seem to work before. However, since it works now, I'm happy. Thanks

[adroege]

Do you really need RegEx? or do you just need it to work?

This way works without using Regular Expressions

Code: Select all

StringReplace>SourceString,%CRLF%,%LF%,NewString

[daniel347x]

For some reason, it's working now. (Even using the RegEx)

I've appended an edit to my initial posting to say this.

Obviously, I did something different than is indicated here. I'm sorry for the false alarm - wish it hadn't cost me a couple hours, whatever I did wrong.

Thanks,
Dan.