Copy link to clipboard
Copied
I use a third party to translate data into Spanish, but the format of my data changes after automatic translation. Iām using a formula to fix the info into the correct format, but one piece is still missing.
The attached image (sample-issue) shows the black text before and after my find/change formula of:
- =^pā¢ ;
This is almost perfect, but it makes an unnecessary line break at the top of the text (red circle in sample image). Iām trying to figure out how to write another formula to remove ONLY the first match of ^p (end of paragraph), but everything Iāve found and tried doesnāt work. Iām pretty sure the formula is using Regex. Can someone please help me with this?
Fyi: I know Find/Change can change multiple returns into single returns, but that has the potential to cause trouble elsewhere in my documents. I believe a formula is my only option here.
Someone outside this discussion solved this for me. After the first formula, I just needed to find ^(^p) and replace it with nothing.
Copy link to clipboard
Copied
Maybe while searching for 2 hard returns to replace with 1, you could also put a search limitation on it by specifying the paragraph style in the Find Format?
Copy link to clipboard
Copied
A simple GREP search would be:
Find: \s*-\s+ (find any space zero or more times; hyphen; any space one or more times)
Replace: \rā¢\t (paragraph return; bullet; tab)
restrict the search to just the style of your bullet points and that should do it.
Copy link to clipboard
Copied
Someone outside this discussion solved this for me. After the first formula, I just needed to find ^(^p) and replace it with nothing.