Convert Text to Table Using Extendscript

Fightergator: However, was wondering if there's a way to convert text to table in extendscript.

I would think so. It's not that hard to generate FM table MIF. I'm not experienced in either FrameScript or ExtendScript, but I have created spreadsheets into which one pastes raw delimited text on one sheet, the next sheet frames each line with row & cell MIF, and a 3rd sheet concatenates all of it in complete Table MIF (in the desired style). Copy'n'paste into the document's .mif. It's been perhaps a decade since, so don't ask for details…

If you have a lot of these to do, there is another approach that I would explore: Use XSLT to convert the comma-delimited text to XML. FrameMaker has a couple of XSLT processors built into it's structured side that can be automatically triggered on File > Open. I have written XSLT stylesheets to convert comma-delimited text to XML. The XML would mimic the table structure that you want in FrameMaker. You would need a FrameMaker structured application that would convert the XML to a table on File > Open. If you want to explore this further, please contact me offlist. Thank you.

Happy New Year and a welcome to a great challenge. I have done a few of these over the years but I think they were all in FrameScript before ExtendScript was a thing in FrameMaker. One of the hardest parts can be separating each delimited line into "fields" if there are quoted fields with commas in them. If you don't have that to worry about, it is easier. One thing to google: parse comma delimited text with regular expressions.

Since it looks like you want to work with selected text, you can use doc.GetTextForRange (Constants.FTI_PgfBegin) to break the selection into a series of lines or paragraphs. Then, for each one, you will need to parse the line into fields. That will give you a count of how many rows and columns your table needs. I know I am not giving you any code here; just exploring the algorithms.