Hi there,
How to use Text Parser to extract the content from static headers (highlighted in yellow below) to add in a row at Google sheets ?
Thanks in advance
1 Like
Hello @Jeferson,
This could be done using the Regular Expression with the replace() function.
Check this topic and read it carefully.
I’ve already solved this by giving multiple responses to it. Specifically, check my responses.
Right now I can’t generate Regular Expression specific to your use case, Because I need the exact text from you. Right now you’ve shared an image. Based on the image I can’t exactly get how many line breaks or spaces are used at the end of the line.
Can you just share the exact text from your previous module and then I’ll also create an expression for you?
P.S.: Always search first, Check Make Academy. If this is helpful, Mark Best as Solutions 
and give 
If you need expert help or have questions? Contact or comment below! 
Hi @Jeferson
You can use the following module to extract the key value pairs from a text:
You will get the output as key and values:
Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation
Welcome to the Make community!
When reaching out for assistance with extracting text, it would be super helpful if you could share the actual text you’re trying to match. Screenshots of text can be a bit tricky and troublesome to reproduce, so if you could copy and paste the text directly here, that would be awesome! It ensures we can run it against test patterns effectively. If there’s any sensitive info, feel free to change it to something fictional yet still valid by keeping the format intact.
Providing clear text examples saves time on both ends and helps us give you the best possible solution. Without proper examples, we might end up playing a guessing game, and nobody wants that as it is a waste of time! You are more likely to get a correct answer faster. So, help us help you by sharing those text snippets.
Please format the example text this way to preserve line breaks and special characters:
These are the two ways to format text so that it won’t be modified by the forum:
-
Method 1: Type code block manually
Add three backticks
```before and after the content/bundle, like this:```
content goes here
``` -
Method 2. Highlight and click the format button in the editor
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.
Hello Msquare,
Thanks for the support. The solution have worked as expected ! Thanks very much !
1 Like
Hello Dilipborad
Thanks for you reply ! I got the solution from the post below. Thanks again !
regards
1 Like
Hi @Jeferson
Glad to know your issue is solved.
Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation