Check for existence of line feeds / carriage returns

ebjim — Thu, 11 Jan 2024 05:31:35 GMT

Can Text.Contains be used to detect the existence of line feeds and carriage returns, e.g. TextContains([column1]."#(cr)#(lf)") ?

Thanks!

Re: Check for existence of line feeds / carriage returns

Anonymous — Thu, 11 Jan 2024 07:56:28 GMT

Hi ebjim
Thanks for using Fabric Community.
You can use the below codes for acheiving the above requirement.

Text.Contains([column1], String.Characters({10, 13}))

This approach uses Text.Contains to check if the column contains any of the character codes for carriage return and line feed. String.Characters({10,13}) creates a string containing the character codes for line feed (10) and carriage return (13).

Text.Matches([column1], "\r|\n")

You can also use the Text. Matches function with a regular expression that matches both carriage returns and line feeds. This expression will return a list of matches for either a carriage return (\r) or a line feed (\n) in the text column. If there are any matches, it means the text contains at least one line break.

Hope this helps. Please let us know if you have any further questions.

topic Re: Check for existence of line feeds / carriage returns in Dataflow

Check for existence of line feeds / carriage returns

Re: Check for existence of line feeds / carriage returns