Aligning and Formatting Text

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?

screee.PNG

Reporting

Settings

Transformation

Interface Tools

Text Mining

Accepted answers

All comments

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.).

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703