Pdf converted to excel and need to format to table.

Question

Hi I have converted a pdf to excel and now I am trying to put everything in a table format. I am not be to do so as when I combine regex and text to column I am getting all the data in first column. I have attached the workflow and also I have output format in input file.

Thanks in Advance.

New Workflow2.yxmd

sachinsg · Answer

@Qiu

These are supposed to in two different columns. But when I converted the Pdfs, its all coming in one column with no extra spacing. Also some data should be in column 2 and some in column 3. But since there is no data in column 1, everything is falls in column 1 now. I am finding it difficult to the have them placed in the right column.

Qiu · Answer

@sachinsg 
Thank you for the input file.

But it is difficult to me, honestly.

When we do RegEx, there should be some patterns.

For your case, what will be difference betwen there two columns?

Domestic cash rateGas RateMarket OpenABD MultipleMarket CloseEDF Multiple

sachinsg · Answer

@Qiu

Attached now.

New Workflow2.yxzp