Aligning and Formatting Text

[sschong]

Hi everyone

I have used a PDF tool to extract words out of the PDF, but I have a 2 questions:

1. How do I align left on the data fields as per the picture below

2. What tools are available to automate the exporting of this into a word document? I have tried using the render tool but I have missing data fields which did not really allow me to do so. Any advice? 

[Qiu]

@sschong 
For the first question, try to add one Cleasing tool, which would remove the leading and trail spaces.
For the 2nd one, the render tool should do it. can you share your error message?

[sschong]

Hi Qiu, thank you for the reply

1. I have managed to do so, but which field do I need to tick to remove the empty data rows under the results page

2. there is a missing community in the data field, but because the input file is not a structured data and is just images, hence i doubt a data field is required. Is there any other way to bypass this?

[nduan]

Hi @sschong 

For #1, can you try adding a filter with the condition !IsEmpty([Data])

For #2, can you try adding a Table tool before your Render tool? 

Then use the Table as your Data Field in the Render tool.

[sschong]

#2 works thanks for your help nduan

For #1, will it be like this?

[nduan]

Almost -- the syntax will be a little different:

[sschong]

Nice! This was very helpful. As for the table that is exported to word, do you know if its possible to remove the table formatting ?

[nduan]

Yes, you would need to play around with the Default Table Settings (eg. change it so that the Background Color for the Data and Header is white, remove the table borders, etc.).