INTERACT FORUM

Windows => JRiver Media Center 34 for Windows => Topic started by: mvandyke on May 20, 2025, 10:49:53 am

Title: Search and replace for a character and replace with a hard carriage return
Post by: mvandyke on May 20, 2025, 10:49:53 am

I have a large text field that would look a lot better if I could search for a character (ex. •) and replace with a hard carriage return using FIND AND REPLACE in JRiver.  This way each variable would be on it's own line:

 Current:
1987/Cassette - Columbia(JCT-33795) [Born to Run] •  1987/CD - Columbia(33795) [Born to Run] •  1989/Cassette - Columbia(6865813T) [Born to Run] •  1990/CD - Legacy / Sony Music Distribution(52859 CK) [Born to Run] •  1992/Mini-Disc - Columbia(33795) [Born to Run] •  1994/CD - Legacy / Master Sound(64406) [Born to Run] •  2000/CD - Sony Music Distribution(CD 80959) [Born to Run]

Would like:
•  1987/Cassette - Columbia(JCT-33795) [Born to Run]
•  1987/CD - Columbia(33795) [Born to Run]
•  1989/Cassette - Columbia(6865813T) [Born to Run]
•  1990/CD - Legacy / Sony Music Distribution(52859 CK) [Born to Run]
•  1992/Mini-Disc - Columbia(33795) [Born to Run]
•  1994/CD - Legacy / Master Sound(64406) [Born to Run]
•  2000/CD - Sony Music Distribution(CD 80959) [Born to Run]

I've tried some special characters but no luck.

Any help would be appreciated

Thanks
Matt

Title: Re: Search and replace for a character and replace with a hard carriage return
Post by: lepa on May 20, 2025, 12:00:19 pm

I dont think find and replace support extended chars or regex. One solution would be to make new calculated field e.g. "Your Large Field (pretty)" which will format your raw field as you like

expression for new field e.g.

Code: [Select]

Replace(•  [Your Large Field],/ •,<br>•)
Or if you are confident enough you could replace your original field content with something like this

Code: [Select]

=Replace(•  [this],/ •,<br>•)
Creating new formatted field (first suggestion) would be safer as your original data is still there in case you mess up something with expressions

Title: Re: Search and replace for a character and replace with a hard carriage return
Post by: dtc on May 20, 2025, 01:07:21 pm

There is a expression to insert an ASCII character  although there may be limitations on where you can use it.  You might try CHAR(10) and see is that puts in a line feed. Use 13 for a carriage return. I do know know if that will work in a Find and Replace. But, worth a try unless someone has more details.

From the Wiki

Description   Char(Numeric Number Code)
                        Char() has unicode support, however, only decimal values are supported. If you require a Hex to Decimal convertor, try unicode-search.net, or search for an alternative online.

Title: Re: Search and replace for a character and replace with a hard carriage return
Post by: zybex on May 20, 2025, 02:25:24 pm

Yes, char(10) should work:

Code: [Select]

=replace(• [this],•/ / , char(10)•/ )
It's possible to do a more flexible replace with Regex mode -2, but I think it's overkill.

Title: Re: Search and replace for a character and replace with a hard carriage return
Post by: lepa on May 20, 2025, 02:44:07 pm

Looks like Find & Replace tool accepts char() function also. Didn't know that it eats expressions also

Title: Re: Search and replace for a character and replace with a hard carriage return
Post by: mvandyke on May 21, 2025, 08:10:36 am

The search and replace worked just fine with the Char(10).  Thanks for all of your expertise!