How do I get TEXT to Google sheet in a table format?

Questions
1

I have converted a PDF file with several job/vacancies in to TEXT. Now I want to list them nicely on google sheet with heading like [POST, REF NO, SALARY, CENTRE, REQUIREMENTS, DUTIES, ENQUIRIES, Tel No: , NOTE]

The TEXT looks like this:

POST 33/07 : DIRECTOR: PROVINCIAL AND DISTRICT PLANNING AND IMPLEMENTATION SUPPORT REF NO: DBE/13/2025 Branch: Delivery and Support Chief Directorate: Planning And Implementation Support SALARY : R1 266 714 per annum CENTRE : Pretoria REQUIREMENTS : Applicants must be in a possession of a relevant Bachelor’s degree (NQF Level 7) or equivalent qualification as recognised by SAQA; A relevant post-graduate qualification will be an advantage; Five years’ experience at Middle/Senior Management level in the education sector; Extensive experience in the education sector with specific focus on District Development Creativity. DUTIES : The successful candidate will be responsible for managing an effective system addressing and identifying planning, implementation and monitoring challenges at provincial and district level; Monitoring policy implementation and supporting the institutionalisation of the District Development Model (DDM) in the sector. ENQUIRIES : Mr M Segowa Tel No: (012) 357 4291 or Ms N Monyela Tel No: (012) 357 3294 NOTE : A Certificate for SMS pre-entry programme is required for all SMS appointments, the full details of the outlined requirements and course information can be sourced by following the link https://www.thensg.gov.za/training-course/sms-pre-entry programme/. All
shortlisted candidates for SMS posts will be subjected to a technical exercise
that intends to test relevant technical element of the job, the logistics of which
will be communicated by the department. Following the interview and the
technical exercise, the selection panel will recommend candidates to attend a
generic managerial competency assessment (in compliance with the DPSA
Directive on the implementation of competency-based assessments). The
competency assessment will be testing generic managerial competencies
using the mandated DPSA SMS competency assessment tools. The incumbent
will have to sign an annual performance agreement as well as annually
disclose his/her financial interests and be subjected to a security clearance.

Please help

3

Hello @masasecomm and Welcome to the Make Community!

Since the output of the PDF conversion isn’t likely to be very consistent, you’re going to get inconsistent results trying to parse that data even further.

Normally, for something like this you would use a Regular Expression parser and perhaps AI can help you develop a regex string for this based on a sample of your data.

This is the Match Pattern Text Parser module I am referring to in Make.

1 Like
4

Welcome to the Make community!

Please format the example text this way to preserve line breaks and special characters:

Here are some ways to provide text content in a way that it won’t be modified by the forum.

  • Method 1: Type code fence manually —
    Add three backticks ``` in a separate line before and after the content, like this,

    ```
text goes here
```

  • Method 2: Highlight and click the “preformatted text” button in the editor —

  • Method 3: Upload your file and share the public link —
    (this method is only recommended for large files exceeding the forum upload limit)

Hope this helps! Let me know if there are any further questions or issues.

— @samliew
P.S.: investing some effort into the tutorials in the Make Academy will save you lots of time and frustration using Make!