Recent Discussions
insert newline into API downloaded text
A Pipeline API successfully retrieves text into the QuickBase Rich text field. The sometimes-lengthy text does not have any CRLF so the text is all run together. The User will be editing the text so it would be helpful to pre-insert the new line for them as the text can be long. The new line needs to go before any single or multiple digits followed by a period & 1 space, ex. "1. " or "11. " or "215. ". There can be just a few to over 50 or more instances. A Regex seems to identify the places in the text but have yet to be able to prepend the "\n" or "<br>" in subsequent pipeline steps. 'Find All Matches to a RegEx' has been used to find the areas. In (1) pipeline the Rich Text field was being updated w/ the new line using the QuickBase Update step but each subsequent regex update wiped out the previous change. {% set claimTxt = d.group_0 | replace(d.group_0, '<br>'+d.group_0) %} {{ c.claim | replace(d.group_0, claimTxt)}} Would think that the 'Apply Regular Expressions" should work but have not been able to find examples on how to set that up (below is one example). Several other variations than the one shown above were used but did not get the new line to insert. replace([\d][0-9]{1,4}[.],\n$&) replaceAll([\d][0-9]{1,4}[.],\n$&) substitute([\d][0-9]{0,4}[.],\n$&) ------------------------------ Gabe Figueroa ------------------------------
